?
Solved

Microsoft SQL Native Client error '80004005'  Named Pipes Provider: Could not open a connection to SQL Server [5]. "

Posted on 2007-08-02
6
Medium Priority
?
5,939 Views
Last Modified: 2008-01-09
Experts,
I am getting this error in an asp application. I am trying to set up a staging environment for this application and the app works in production. When I change the connection string to thit he production database the error disappears. However, I get this error when the application is pointed to the staging database. Named Pipes, TCP/IP and have been enabled. We will really appreciate your help. BTW, our database is a 2005 db.


the error I am getting on the page is,
Microsoft SQL Native Client error '80004005'
Named Pipes Provider: Could not open a connection to SQL Server [5].

0
Comment
Question by:trwd
  • 3
  • 2
6 Comments
 
LVL 25

Expert Comment

by:kevp75
ID: 19619918
make sure you are using the correct provider.  Production and staging may be different versions?

also make sure you are using the correct server.   You may need to include a port number with it, but double check to make sure...
0
 

Author Comment

by:trwd
ID: 19619954
What do you mean by including the port number and Also, Different versions of what? We have the same versions of SQL Server and SQl is listening on the same ports on both systems.
0
 
LVL 25

Expert Comment

by:kevp75
ID: 19620366
post your connection string please  (make sure to take out the username/password/server values)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:trwd
ID: 19620427
Sorry about that, the connection string is below
dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "provider=SQLNCLI;server=SR-FW-TRVT02.trv.org\TRVROE2005;Database=TRV-ROE-DB;UID=username;PWD=password
objConn.Open
0
 
LVL 25

Accepted Solution

by:
kevp75 earned 2000 total points
ID: 19620461
I've never seen a server with the likes of:
SR-FW-TRVT02.trv.org\TRVROE2005  (I assume that this is a SQL Instance?)

try using the only the IP address
0
 
LVL 25

Expert Comment

by:clockwatcher
ID: 19620474
See the following for some troubleshooting.  

  http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

I'd double check that named pipes is really enabled on your development sql server (since it's disabled by default).
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month17 days, 4 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question