Remote server connection issue

Question

Hello,

I am having trouble connecting to a remote server on SQL Server 2000. I have disabled the firewall on this server to better identify the cause of the problem, but the issue persists, and I am unable to connect to this server.

I am able to connect to other SQL Server servers on different remote machines, except for this one that I just put into production. I’ve been going around in circles on this issue for the past two days.

Here is the error message:

Please help me.

Sincerely.

pulls · Answer

In continuing the research, I realize that port 1433 is not listening on the remote server. I verified it with the command:

netstat /an in the command prompt.

Yet, port 1433 is indeed enabled in SQL Server 2000. How can I make this port listen on the remote server?

Best regards.

pulls · Answer

Yes, but how to make SQL Server 2000 active on the remote server? Moreover, I have 2 SQL Server instances: a default instance and a named instance. When I execute this script:


DECLARE @TCP_port varchar(5)
 , @registry_path varchar(100)

SELECT @registry_path = CASE @@SERVICENAME
 WHEN 'MSSQLSERVER' THEN 'SOFTWARE\Microsoft\MSSQLSERVER\MSSQLSERVER\SuperSocketNetLib\TCP'
 ELSE 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @@SERVICENAME + '\MSSQLServer\SuperSocketNetLib\TCP'
 END

EXEC master.dbo.xp_regread
 @rootkey = 'HKEY_LOCAL_MACHINE'
 , @key = @registry_path
 , @value_name = 'TcpPort'
 , @value = @TCP_port OUTPUT

SELECT @TCP_port AS PortNumber
 , @@SERVERNAME AS ServerName
 , @@SERVICENAME AS ServiceName

- In the default instance, it says it is listening on port 1433
- In the named instance, it is listening on port 0 (zero)

Is this normal?

Regards.

Remote server connection issue

2 answers

Xiaomi redmi note 140 -

New simplified cancellation feature for online purchases

Downloaded .rar file becomes .htm when finished

Self-invoking js function

Computer locked

Question about transferring data ps4 to ps5

Connecting a sony handycam video 8 ccd f555e to an hd tv

How to change my username

Texture issues in enshrouded

Gotek information