SQL 2000 not listening on TCP port

• cuteprabakar

  SSC Enthusiast

  Points: 174

  More actions

  June 4, 2009 at 9:38 am

  #95656

  Hi,

  SQL Server 2000 with SP4 on Windows 2003.

  I cannot connect to it remotely. I checked netstat and realized SQL Server was not listening to tcp port 2008(which i changed) and or default port 1433. I need urgent help

  Thanks in advance

  FYI:

  exec sp_configure 'remote access'

  0 1 1 1

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 4, 2009 at 10:19 am

  #1004766

  Did you check if the TCP/IP protocol is enabled?

  Does the output of NETSTAT show the TCP port configured in SQL Server Network Utility as LISTENING?

  -- Gianluca Sartori