Hi all,
my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster.
I subscribe for SQL server 2005
I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both:
Cannot connect to sqlb2.webcontrolcenter.com
a connectionmwas successfully established with the server, but then an error occured during the login process. (Provider: TCP provider, error: 0 -The specified network name is no longer available )
(Microsoft sql server, error 64)
thank's for your help
These errors indicate that the connection between the client and SQL Server was broken for some reason while SQL Server was writing data to the client. You mention that you are accessing the server across the internet, so part of the issue may be routing/firewall rules/devices between you and your provider...if you are able to get through to the server, you may not be able to get data back from the server or vice-versa.
Can you telnet to the TCP port that SQL Server is listening on? i.e. telnet to the IP and port combination you are trying to connect to?
Additionally, ensure your SQL Server is configured to allow remote connections.
This is typcially more of a transport-level issue than SQL Server error (in this case, TCP for example)...
|||Hello Chad Boyd,
it was my firewall , i put it off and now my connection is working
Thank's for your response
