Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.news-service.com!85.214.198.2.MISMATCH!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: SS 2008: Front-End Language Processor for Scripts Date: Wed, 25 May 2011 12:39:20 +0000 (UTC) Organization: Erland Sommarskog Lines: 33 Message-ID: References: <8liot6lm9t1b5reup0fqq7kkn68tbg6uhi@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Wed, 25 May 2011 12:39:20 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="15840"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/HqhmafFbk8KO0mqP/P2qV" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:By7anN6ZNojH5wWZ9Hglcom7CGc= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:372 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