Linked Server Returns Communication Link Failure after Unspecified Error

• tonya.wakefield

  Old Hand

  Points: 325

  More actions

  January 6, 2014 at 5:39 am

  #281753

  Morning all,

  Over the weekend, one of my servers decided that the linked server was no longer going to function.

  I have had this error once in a while of the occasional semaphore timeout period has expired - due to some type of internet lag.

  But not this time.

  I can not get the object to work at all any more.

  I tested the Linked Server object, and the Test connection - passes, yet when I try to use it in any simple query - it dies.

  I am getting 3 messages -- 1 OLE DB provider "SQLNCLI11" returned message "Unspecified Error" and 2 "Communication link failure".

  Then it says Msg 121 Level 16, State 1 Line 0

  TCP Provider: The semaphore timeout period has expired.

  Anyone have any pointers to which direction I should go with this?

  My first thoughts are maybe the server needs to be rebooted.

  Any pointers are appreciated.

  Thanks,

  Tonya

• hitesh jain

  SSC Veteran

  Points: 229

  More actions

  January 6, 2014 at 7:43 am

  #1677751

  Looks similar to what we had encounter with our servers when DTC was not enabled on a link server. Maybe this will help you with resolving the error:

  http://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction

• tonya.wakefield

  Old Hand

  Points: 325

  More actions

  January 6, 2014 at 7:46 am

  #1677755

  Found the Answer !!

  Apprently there were some networking routing changes done, and a Delay in the Router was added.

  The Delay was removed, and now everything works fine.

  Thanks for taking the time to review!

  Tonya