SQL server can only connect in Management Studio
Posted on 2014-08-21
seems to be a lot on internet about this error, but can't get connection to work
note the error happens on both same and remote server
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
both SQL and Windows authentication enabled
both SQL and Windows authentication work in SQL Server Management studio
HOWEVER neither methods (Windows or SQL) works in e.g. Visual studio etc. (either on same or remote LAN Server)
I've tried using IP address and also the domain e.g. me.mysite.com
I have Express and Standard SQL installed, not sure if that would be problem
server name: 126.96.36.199
server name: me.mysite.com
correct username/password input
SO, how do I get BOTH SQL Management Studio AND other programs e.g. Visual studio, ASP.Net to connect..thanks