Connecting to SQL Server 2000 through TCP/IP on localhost failed.

Question

I have tried to connect to SQL Server 2000 through TCP/IP.

I followed these steps and enabled SQL Server 2000 on port 1433.

Then I used the command to test whether the port is opened up:

telnet localhost 1433

But I found the following error:

Connecting To localhost...Could not open connection to the host, on port 1433: 
Connect failed

And I also failed to connect to the server by following these steps.

How to solve this problem and connect to Sql Server 2000 through TCP/IP?

See my configs

Answer 1

By default TCP-IP is disabled. You need run SQL Server Configuration Manager->SQL Server Network Configuration and enable the protocol, then restart SQL Server service

Answer 2

I think you need to be running SQL Server Agent to connect via TCP/IP on 2000.

Answer 3

Try disable your firewall temporarily and see if it makes a difference, to isolate the problem.

EDIT: Wait, did you enable TCP/IP on the client or server ? If you only enabled it on the client, then that explains it.

It must be enabled on both to allow communication. From your error, it looks like the server does not accept TCP connections. I don't remember what SQL 2000 calls the program, but find something like "SQL Server Network Configuration", not "Client Configuration". And turn on TCP there.

Perhaps show us a screenshot of your network configuration dialog.