?
Solved

A network-related or instance-specific error occurred while establishing a connection to SQL Server

Posted on 2010-09-02
2
Medium Priority
?
860 Views
Last Modified: 2012-05-10
Our WEB master is setting up a new server. The new server is working as it should except for she is now trying to run some code in ASP.net. SQL 2000 and server 2003

I get my telnet connection to the SQL server. Server I on the DMZ and the data base is on my domain.
Network team tells me that we have all of the right ports open. Please see below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
0
Comment
Question by:fischerbob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 1500 total points
ID: 33596665
The issue is the Named Pipes. You should turn named pipes off and use only TCP/IP. Named Pipes uses domain authentication directly off the AD controller then to the SQL Server. Where TCP/IP gets the authentication request from the server/app through the TCP and then sends to the AD controller for the verification of credentials.
0
 

Author Closing Comment

by:fischerbob
ID: 33599612
we also had a problem with the WEB config file. All is good now thank you
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 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