Spotty network communications - 07-24-2006 , 12:14 PM
I have a server which I am connecting to over the Internet.
Usually things are fine, but once in a while, when I open Enterprise
Manager, it sees the server fine, but when I click Tools\Query Analyzer, the
query analyzer fails to connect and says
[odbc sql server driver] TCP/IP Sockets sql server does not exist or access
then gives me the login screen. This may happen all day long, and then the
problem seems to go away and connections pop right up immediately.
When the problem is happening, I can Remote Desktop to the server, start up
Enterprise Manager there, and the query analyzer always pops right up.
Any ideas what is going on, and what I can do to troubleshoot or hopefully
fix this problem?