TCP protocol does not startup after reboot

• Lian

  Say Hey Kid

  Points: 704

  More actions

  September 20, 2006 at 3:07 am

  #62051

  I am supporting an SQL2000 Standard Edition Server with Service Pack 4 running on Windows 2003 Server with Service Pack1 .

  I rebooted the server  and then the users were unable to connect to the server and the message "Server does not exist or access denied " . The sql server errorlog was investigated and it was found that the the TCP protocol did not startup. What could be the reason for this ?

   

  Thanks.

  Lian

• Satwinder

  SSC Veteran

  Points: 298

  More actions

  September 20, 2006 at 5:14 am

  #661447

  There can be multiple reasons

  1. The port for sql server is disabled

  2. The port for sql server is being used by another application

  3. TCP protocol has been disabled in Server Network utility

  4. TCP protocol DLL is corrupted. Check the DLL version & date

  Thanks,

  Satwinder..