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 sql2008.metropol-beauty.com,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)