June 7, 2007 at 12:55 am
Hi,
I have SQL Server 2005 running on a machine with "Allow Remote Connections" property turned on. This server has SQL Server Authetication mode turned on.
I can connect to the server locally with sa login and password but when I try connecting to the server remotely it gives me following error:
TITLE: Connect to Server
------------------------------
Cannot connect to ServerName.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, 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: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233).
Any help is appreciated.
June 7, 2007 at 8:55 pm
Are remote connections for TCP/IP enabled on the box?
June 7, 2007 at 10:22 pm
Yes.
June 8, 2007 at 10:51 am
Some suggestions
1. Run the surface area configuration tool on your SQL 2005 instance and ensure that it will accept remote connections. Note the port number that SQL 2005 is using for step 3.
2. Verify that the server OS will accept remote connections. (Apparently you've already done this step?)
3. From a command prompt on your remote machine, try to "telnet 3389" - this will test the remote desktop port, or if you're trying to just get an SQL Connection use "telnet " and use the SQL Server port that you opened up in step one. If you don't get any connectivity, you may have an intervening firewall/networking issue.
Steve G.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply