Groups > comp.databases.ms-sqlserver > #372

Re: SS 2008: Front-End Language Processor for Scripts

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SS 2008: Front-End Language Processor for Scripts
Date	2011-05-25 12:39 +0000
Organization	Erland Sommarskog
Message-ID	<Xns9EF0951605EBAYazorman@127.0.0.1> (permalink)
References	<ctmlt61e9p7uarqa20uc24qurkdirv6lnv@4ax.com> <Xns9EEF5F37CE96DYazorman@127.0.0.1> <8liot6lm9t1b5reup0fqq7kkn68tbg6uhi@4ax.com>

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      I tried and ran into some trouble.  The tests for
> Win32::SqlServer failed.  I got:
> 
> SQL Server message 2, Severity 16, State 1
> Named Pipes Provider: Could not open a connection to SQL Server [2]. 
> Message 08001 from 'Microsoft SQL Server Native Client 10.0',
> Severity: 16
> A network-related or instance-specific error has occurred while
> establishing a connection to SQL Server. Server is not found or not
> accessible. Check if instance name is correct and if SQL Server is
> configured to allow remote connections. For more information see SQL
> Server Books Online.

Which means that you were not able to contact SQL Server.

>      My guess is that it is trying to use the wrong instance name. How
> do I specify the instance?
> 
>      Or is it something else?
 
If you were running the test suite for Win32::SqlServer, you need to set up 
connection details with OLLEDBTEST as described in Tests.html. If you are 
trying to use an AbaPerls tool, use the -S switch to specify a server.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-23 15:24 -0700
  Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-24 07:21 +0000
    Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-24 17:21 -0700
      Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-25 12:39 +0000
        Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-25 12:46 -0700
          Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-25 23:33 +0200
            Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-25 15:21 -0700
              Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-26 23:44 +0200
                Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-26 15:24 -0700
  Re: SS 2008: Front-End Language Processor for Scripts Bernard Peek <bap@shrdlu.com> - 2011-05-25 17:27 +0100

csiph-web