Enter the IP port of the telnet server in Dos or the command line to see if you can connect.

Such as telnet 202.114.100.1001433.

Usually the port value is 1433, because 1433 is the default listening port of Tcp/IP in sql server 2000. If there is a problem, this step will usually go wrong. The usual prompt is "... unable to open the connection, connection failed".

If there are problems with this step, you should check the following options.

1 Check whether the remote server has started the sql server 2000 service. If not, start.

Check whether the Tcp/IP protocol is enabled on the server side, because the remote connection (via the Internet) depends on this protocol. Check method is to open the start menu on the server->; Program-> Microsoft SQL Server-& gt； The Server network utility checks whether there is a tcp/ip protocol among the enabled protocols, and if not, enables it.

3 Check whether the tcp/ip port of the server is configured as port 1433. Still check the properties of tcp/ip in the enabling protocol of the server network utility, and make sure that the default port is 1433, and the hidden server check box is not selected.

In fact, it is possible to modify the default port, but when the client does telnet test, the port number of the server must be consistent with the port number configured by the server. If the "Hide server" check box is selected, it means that the client cannot see the server by enumerating the servers, which protects the server, but does not affect the connection. However, the default port of Tcp/ip protocol will be implicitly changed to 2433, and the client must make corresponding changes when connecting.

4 If the server-side operating system has been patched with sp2, you need to configure a windows firewall and open the port 1433 for it. Usually, you can directly close the windows firewall during the test (it is better to close other firewalls).

5 Check whether the server is listening on port 1433. If the server does not listen on the port 1433 of tcp connection, it will not be connected. The check method is to enter it under the dos or command line of the server.

Netstat -a -n or netstat -an, and see if there are any items in the result list similar to TCP127.0.0.11433 listening. If not, you usually need to install at least sp3 patches for sql server 2000. In fact, start the query analyzer on the server side and enter select @@version to see the version number. Versions below 8.0.2039 need to be patched.

If all the above are all right, then do the telnet server ip 1433 test again, and you will see the cursor in the upper left corner flashing after the screen flashes. Congratulations, you can start connecting in Enterprise Manager or Query Analyzer immediately.