The purpose of this article is to let you know that the fix might be as simple as connecting to the name instance instead of localhost. When you install sql server using the web platform installer tools , the sql server is installed as a named instance so it is likely to be ComputerName\SQLEXPRESS not localhost.
If you are trying unsure about the server name please use the browse feature of this pop up to locate your server instance or use the command
sqlcmd -L
at the dos prompt.
If you can connect to your named instance but unable to connect to it from a nother comouter on the network you might have some configurations or firewall related issues . In such cases this article below is what you need.
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
Reference and Related Links
Open a port windows Firewall
http://windows.microsoft.com/en-US/windows7/Open-a-port-in-Windows-Firewall
http://windows.microsoft.com/en-US/windows-vista/Open-a-port-in-Windows-Firewall
3 comments Write a comment