Home > IT Answers > SQL Server > deployment
Pchandrachoudhary
5 pts.
 deployment
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

Software/Hardware used:
ASKED: November 20, 2008  1:58 PM
UPDATED: November 20, 2008  2:50 PM
RELATED QUESTIONS
Answer Wiki:
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: <a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277">How to configure SQL Server 2005 to allow remote connections</a>
Last Wiki Answer Submitted:  November 20, 2008  2:30 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _