Linked Server Error

• Sushant Yadav

  SSCrazy

  Points: 2780

  More actions

  January 16, 2014 at 9:58 pm

  #281256

  Executed as user: XYY. TCP Provider: The semaphore timeout period has expired. [SQLSTATE 07008] (Error 121) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xx" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xx" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xx" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xx" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.