Tuesday, 20 March 2012
connect to cluster server issue
I had SQL 2000 client, and tried to register to SQL 7 cluster server in Enterprise Manager. But the registering process hang.
Does anyone know the issue? It happen to other users as well.
Thanks.
yuling
Hi,
Acturally, I tried to connect to SQL 2000 cluster server in Enterprise Manager. But, the process hangs. I am able to register this SQL server from any of my sql server machine. BTW, I can connect by using Query Analyzer without any issue as well. What
's the issue?
Thank you if anyone has this issue. Tks.
Yuling
sqlsql
connect to cluster server issue
I had SQL 2000 client, and tried to register to SQL 7 cluster server in Ente
rprise Manager. But the registering process hang.
Does anyone know the issue? It happen to other users as well.
Thanks.
yulingHi,
Acturally, I tried to connect to SQL 2000 cluster server in Enterprise Manag
er. But, the process hangs. I am able to register this SQL server from any
of my sql server machine. BTW, I can connect by using Query Analyzer witho
ut any issue as well. What
's the issue?
Thank you if anyone has this issue. Tks.
Yuling
Sunday, 11 March 2012
Connect from 2005 Developer Edition to 2000 Developer Edition
Hi, all -
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip address\instance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
I haven't needed to do this before.
Suggestions?
You 'should' be able to connect just fine.
However, since you are getting timeouts, There could be a firewall blocking your connection attempts. Check both computers for IP port 1433 being open.
Do you have a valid login account on his computer?
|||Execute this in command shell:
Code Snippet
telnet your_2000_host_name 1433
Will telnet create connection?