Monday, May 28, 2007

SQL Server does not Allow Remote Connections Error

When you create your DB Dude project and try to build and deploy the project to the client's sandbox at the first time, you suddenly get the error:

"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."

This error occurred because the networking protocols are disabled by default in SQL Server Express. In order to solve this problem you should configure SQL Server Express to accept remote connections.  I followed  this post's (at SQL Express WebLog) instuctions and the problem was solved.

No comments: