Monday, March 19, 2012

Could not open a connection to SQL server error on Vista

Hey,

After install Visual Studio 2005 (with SQL sever express) on recent Vista build, trying to connect to a local sse database file from Data Source Window (accessible from Data/Show data source window) gives this error:


Microsoft Visual Studio

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)

OK

No issues if we install Visual Studio 2005 on WinXP or W2k3.

Is there any configuration we need to set on vista to allow sql connection?

Thanks,

Mei

Not having tried Vista I don't know if there are special issues there, but by default SQL Server instances are installed with the external interfaces disabled. Use SQL Server Configuration Manager to enable the protocols (if they are not enabled already). This can also be done with the SQL Server Surface Area Configuration tool.

If this does not help, see my blog (www.betav.com\blog\billva)

|||

You will have to enable SQLBrowser service.

See more details here:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

|||

I have the same problem. If you have found a solution to the problem, then let me know.

Kindly

Peer Larsen, DK

No comments:

Post a Comment