I have SQL Server running on a remote server.
I have SQL Server Management Studio 2008 Express on my laptop. It connects to the SQL Server and works fine.
I have SQL Server Management Studion2008 Express on my PC. It doesn't connect but fails with:
A network-related or instance-specific error occured 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: Name Pipes Provider, error: 40- Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
Any clues? Thanks in anticipation
from what I know, connecting to a SQL Server remotely using named pipes has been disabled by default for security reasons. You should connect using TCP instead (port 1433)
Yes but I can connect to a remote SQL Server 2005
can you ping the db server from the PC that's failing?
Not only can I ping the remote server, I can connect to it using Remote Desktop
PING test and Remote Desktop use different ports/responses from SQL Server. From the server, you can check on which port number it is listening to. You can open up SQL Server Configuration Manager, open SQL Server Network Configuration -> Protocols for <instanceName> -> Protocol Name - > TCP IP. Under the IP Addresses tab, check if TCP Dynamic Ports is enabled (a value of 0 I think uses dynamic ports). To be more specific, you can check the SQL Server error log for this message
SQL server listening on X.X.X.X: Y
Run a telnet n that IP and port number to see if the communication is open
C:\> telnet x.x.x.x portnum
That will tell you if the connectivity to SQL Server from your PC works. On top of that, make sure your firewall does allow the SQL Server client tools for outbound communication
I solved the problem, I totally removed sql server, visual studio, management studio etc and cleaned out the registry. I then installed 2008 versions of everything.