SQL Server Failure

• Lexa

  Hall of Fame

  Points: 3314

  More actions

  January 22, 2012 at 4:59 pm

  #251589

  SQL Server failed, no information indicating what caused it to restart. System event logs do show any hardware failure.

  Does anyone know what the following message from application log indicate? Or the cause?

  [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]Communication link failure

  The following is from SQL Agent log:

  2012-01-19 18:32:22 - ! [298] SQLServer Error: 121, TCP Provider: The semaphore timeout period has expired. [SQLSTATE 08S01]

  2012-01-19 18:32:22 - ! [298] SQLServer Error: 121, Communication link failure [SQLSTATE 08S01]

  2012-01-19 18:32:22 - ! [298] SQLServer Error: 16389, Communication link failure [SQLSTATE 08S01]

  2012-01-19 18:33:32 - ? [131] SQLAgent$XYZ service stopping due to a stop request from a user, process, or the OS...

  Any idea on what could be be cause for the error?

  Please advise.

  Thansk

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 22, 2012 at 6:44 pm

  #1436932

  It seems a nw issue , please check below links for more details.

  http://ask.sqlservercentral.com/questions/74014/urgent-help-required-the-semaphore-timeout-period-has-expired-sqlstate-08s01

  http://sqlblog.com/blogs/merrill_aldrich/archive/2010/06/10/windows-server-2003-network-boogey-men-every-dba-should-know.aspx