Getting “An error has occurred while establishing a connection to the server” error message

Tags:
SQL error messages
SQL scripts
SQL Server 2005
While running the setup on client machine, An error Number 5 occurred telling - "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 default settings SQL server does not allow remote connections. (Provider: Named pipes provide, error:40 - could not open connection to SQL server) source:.Net SQLclient Data provider

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you using the express or developer edition?
As the message says, the problem could be caused by the fact that these editions do not allow remote connections by default.

This is what is needed to allow remote connections:

– Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
– Turn on the SQL Server Browser service.
– Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

A detailed explanation on how to do that, is found at this page: How to configure SQL Server 2005 to allow remote connections.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following