SQL Server 2008
Thanks! We'll email you
when relevant content is
added and updated.
I am trying to connect to my database in Visual Studio 2010 using the named instance by
But, I get the following error message:
error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server
I have the following aspects enabled:
open Port 80, 1433, 1434 on router
allow Port 80, 1433, 1434 through Firewall (UDP, TCP)
allow Program Sqlsvr.exe, SqlBrowser.exe through Firewall
server server (instanceName), SQL Server Browser, Named Pipes, TCP/IP
enabled Remote Connection in SQL Server Management
I’ve followed the steps here: http://technet.microsoft.com/en-us/library/cc646023.aspx
, but to no avail.
September 23, 2013 3:56 PM