Can not start sql server 2005 instance

• awu

  SSCrazy

  Points: 2037

  More actions

  October 23, 2008 at 5:02 pm

  #154847

  I applied latest service patch 3282 to all the instances on qa box, and two of them failed to start after, got the errors:

  Server TCP provider failed to listen on [ 'any' 23141]. Tcp port is already in use.

  TDSSNIClient initialization failed with error 0x2740, status code 0xa.

  I tried to change the TCP port number, but it didn't work, got the same error.

  Wondering if anybody know how to fix this ? Thx.

  ddfg

• Nikhil Shikarkhane

  Default port

  Points: 1498

  More actions

  October 23, 2008 at 6:02 pm

  #888964

  Sql server service is not able to listen on the given port cause some other application is using it.

  Try rebooting the server. This fixed it for me.