Post reply

SQL Server 2000 is not listening to TCP

  • 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.

  • January 16, 2008 at 11:55 am

    #768869

    Is it showing as enabled when you run this?

    exec sp_configure 'remote access'

  • 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

  • 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

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply