Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to deploy my Database to a web server but I can't get a connection to the SQL server installed in the web server using management studio 2008. I have already enabled TCP/IP protocol in sql server configuration manager. I also disabled the windows firewall but no result. I always get this error message :

TITLE: Connect to Server

Cannot connect to,1430.


A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

Any ideas?

share|improve this question
Is there a hardware firewall in between, if so, is it protocol aware (Watchguard Firewalls are the ones I have run into). If so, sometimes they like to detect a protocol and muck it up (esp. if it is an older version of the firmware, and the software you are using is newer). – jgv999 Aug 28 '11 at 0:33
No there isn't such a thing. I could connect once with the same options but just once I don't know what's wrong. – Milad Aug 28 '11 at 0:59
Can you try with an invalid login? Does it say "Login Failed"? – jgv999 Aug 28 '11 at 1:17
up vote 2 down vote accepted

You need to ensure that the SQL port which is 1433 is open between the web server and e database server. You also need to ensure that the SQL sever is listening for remote connections. This can be cycled in the SQL Server Configurion Tool.

share|improve this answer

Is your server running as a named instance? I have seen something like this before and ended up installing the native client tools on the server and configuring my SQL server up in that. Seemed to resolve my issue, give it ago and see what happens.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.