SQL Server 2000 is not listening to TCP

• henrysams2

  SSC Journeyman

  Points: 79

  More actions

  January 16, 2008 at 11:31 am

  #70720

  Hi guys,

  My server is running SQL Server 2000 with SP4 on Windows 2003. This is my problem:

  I cannot connect to it remotely. I checked the error logs and netstat and realized SQL Server was not listening to tcp. I used the server utility to enable and specify the port but did not work even though the new port is updated in the registry after restarting. I need urgent help

  Thanks in advance

  H.S.

• Todd Engen

  SSCrazy Eights

  Points: 9869

  More actions

  January 16, 2008 at 11:55 am

  #768869

  Is it showing as enabled when you run this?

  exec sp_configure 'remote access'

• henrysams2

  SSC Journeyman

  Points: 79

  More actions

  January 16, 2008 at 12:28 pm

  #768888

  This is what it shows:

  name minimum maximum config_value run_value

  remote access 0 1 1 1

• Todd Engen

  SSCrazy Eights

  Points: 9869

  More actions

  January 16, 2008 at 12:54 pm

  #768907

  My apology H.S. That last option has no relevance to your problem.

  You say it's listening on port 1433? Does the PID from a NETSTAT -o -a -n command match up to the PID to that of SQLSERVR.EXE process listed in the SQL Server Logs?

  When the service is restarted there should be a line in the current log that says something like:

  SQL server listening on : port 1433

• henrysams2

  SSC Journeyman

  Points: 79

  More actions

  January 17, 2008 at 1:01 am

  #769100

  Hi,

  I checked that already and it's not listening on TCP or any port.

  Cheers,

  Henry