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) (Microsoft SQL Server, Error: 53)This error is mainly based ont he fact that SQL Server disables remote connections by default. If you are not sure how to switch remote conenctions on, refer to the screencast on my site for a detailed explanation.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
If the webcast doesn't solve your problem, you can check out:
http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx
it has a great deal of information on how to debug connectivity issues. In fact, if you search for a bit of your error string in their search box there, you should come up with quite a few blogs on configuration issues that can cause this problem and how to resolve them.
I hope this helps,
John
No comments:
Post a Comment