provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

I am running SQL Server 2005 Enterprise Edition, on a Dell  PowerEdge 2950 64 bit server.When I try to connect to the data in the database i recieve this error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The Windows Firewall service isnt enable, I have allowed local and remote connections using both TCP/IP and Named Pipes and the SQL Server Browser is enabled. Any ideas why I still can't make the connection?
Who is Participating?
mdotenAuthor Commented:
Missed a setting in the web.config file.
Faiga DiegelSr Database EngineerCommented:
Ive used some of the tips here:



And double check all configurations you have, sometimes we missed it :p
Open SQL Server 2005 Surface Area COnfiguration
Select the Surface Area Configuration for Services and Connections
Under Database Engine , you will find remote Connections.
Select Local and Remote Connections and Using both TCP/IP and named Pipes.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mdotenAuthor Commented:
Faiga16: I have looked at both of those forms and the problem still exists.

Indianguru2: I stated that I had already done that in the quesiton description.
Did you restart the SQL service after doing it?
mdotenAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.