Sunday, January 14, 2007


Sometimes I run into this error, when deploying a BizTalk project from VS.NET: "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)"

I take a quick look at it, bang my head in the desk for doing it again, and then I perform the following steps:

  1. Rightclick on the project and choose Properties
  2. Go to "Configuration Properties" => "Deployment"
  3. Change the "Server" property to be the servername of the SQL Server you are deploying to
  4. Save changes
  5. Deploy again

This happens if you receive a copy of someone elses project - since the servername is listed in the projectname.btproj.user file that is a part of the project.

Hope someone else gets quickly past this hurdle now it has been blogged.


Sunday, January 14, 2007 9:43:48 PM (Romance Standard Time, UTC+01:00)  #    Comments [4]  | 
Friday, January 26, 2007 2:35:27 PM (Romance Standard Time, UTC+01:00)
another thing that I like to do, when on the development cycle is to change the name of the server field to (LOCAL). This way you can share your code.
Tuesday, December 4, 2007 9:41:09 PM (Romance Standard Time, UTC+01:00)
Thanks for the blog post ... I just moved some apps from one dev machine to another, and sure enough, I forgot to change the deployment server name ... so it goes
Ashwin Srinivas
Tuesday, December 4, 2007 9:43:14 PM (Romance Standard Time, UTC+01:00)
Yeah, exactly what happened to me :-)

Glad I could help.

Sunday, July 19, 2009 1:32:00 PM (Romance Daylight Time, UTC+02:00)

i was facing the error when opening connection using sqlconnection

nw got solved

See This
All comments require the approval of the site owner before being displayed.
Please login with either your OpenID above, or your details below.
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):

Live Comment Preview

Theme design by Jelle Druyts