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.
Thanks in advance, Les Caudle
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).
On Wed, 18 Aug 2004 19:17:14 -0500, Les Caudle <very@.tiredofspam.com> wrote:
>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.
No comments:
Post a Comment