can see sql2k sp3, but cannot connect? -- sql server connect

Les Caudle
8/18/2004 7:17:14 PM

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also
see that port 1433 is open.

But, when I try to connect to it, I get the connection could not be
estiablished.

sql server does not exist or access denied.

I have pretty much all the port except for 1433 tcp and udp blocked.

How can I troubleshoot getting this connected. It is located on my local
network - so it is not a connection problem.
--

Les Caudle
8/18/2004 7:44:34 PM

I think it was a name resolution problem, with so few ports open.

When I created a registration by ip address rather than name, it connected
immediately.

Confusing that the name showed up in Enterprise Manager. Would be nice if it
would automatically try to use just the ip (which it must know, as it can see
it).

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : can see sql2k sp3, but cannot connect?