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

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

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 <esquel@sommarskog.se>
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	<Xns9EF0951605EBAYazorman@127.0.0.1> (permalink)
References	<ctmlt61e9p7uarqa20uc24qurkdirv6lnv@4ax.com> <Xns9EEF5F37CE96DYazorman@127.0.0.1> <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

Show key headers only | 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