none
Linked Server Error

    Question

  • Hello guys,

    I get one issue when I tried to run a job.

    It gives me below error.

    Please help me out from this.

     

    Executed as user: CONTECH\sqlserver. 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 "SQL2" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412)  OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412)  OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412)  OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412).  The step failed.

     

    Thank s in advance.

    Maulik

    Tuesday, January 17, 2012 5:46 AM

Answers

All replies