I am attempting to connect to a remote default instance of SQL Server
2k on Win2k using Enterprise Manager from my local host but receive a
"SQL Server registration failed, timeout expired" error message each
time.
I am able to connect using Query Analyzer when specifying the IP
address of the server (I am also specifying the IP address in my
Enterprise Manager connection), am able to ping the server from the
command line, and am able to telnet to port 1433. I have tried
connecting both before and after creating an appropriate alias in
Client Network Utilities all to no avail.
I ran SQL Profiler while attempting to connect and do not see the
connection attempt reach the server. What could be preventing
Enterprise Manager from reaching/connecting to the server while all
other utilities (including profiler) are fine?
Thanks in advance.