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.

Published 18 July 2007 11:51 PM by Maor David-Pur

תגים:Team System, Data Dude, SQL Server 2005

Comments

# Siddiq said on 02 February, 2008 08:39 AM: "An error has occurred while establishing a connection to the server.this need Named pipes Provider 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."
# Maor David said on 17 May, 2008 04:54 PM: Last week it was exactly one year since I started blogging, so this is my blog first birthday!! Come and read about the blog's statistics, top posts and more.
# Maor David said on 17 May, 2008 04:55 PM: Last week it was exactly one year since I started blogging, so this is my blog first birthday!! Come and read about the blog's statistics, top posts and more.
# Maor David said on 17 May, 2008 04:57 PM: Last week it was exactly one year since I started blogging, so this is my blog first birthday!! Come and read about the blog's statistics, top posts and more.