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

124 million stolen passwords from pcs

Danger de connexion automatique linkedin

Red button disabled saved

Red button registered disabled

Unable to add an email account in outlook.

Pdf file

Fraudsters are now using your real iban in their phishing emails to rob you.

List numbering style

Set up a network

Sony wh-1000xm5 not turning on after getting wet