OS WS2008 R2 SQL Server 2008 Express Remote client Windows XP - MS SSMS2008
when I try to connect using the IP address of the server I get this error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server, 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) (.Net SqlClient Data Provider)
the same when I use the IP\InstanceName
enabled on the server is shared memory TCP/IP Named Pipes Allow remote connections
Same when MS firewall is off.
any help will be appreciated thanks
asked Jan 26 '10 at 12:36 PM in Default
check the SQL Browser service is running on the server you are connecting to... and all the other suggestions from here: http://ask.sqlservercentral.com/questions/3350/new-server-registration-failednamed-instance
answered Jan 26 '10 at 12:39 PM
It sounds like you don't have your client configured correctly. It sounds like you're using TCIP but the client thinks it's using named pipes. If you're using 2008, open the Configuration Manager on your client machine and navigate to the SQL Native Client Configuration, then down to Client Protocols. Disable named pipes and enable TCPIP. Also, if you only have an IP address for the server, in this same area, you can set up an alias so that you can connect to the server by name rather than having to try to remember the IP address.
answered Jan 26 '10 at 12:52 PM
Grant Fritchey ♦♦