Answered by:
Linked Server Error

-
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
Question
Answers
-
Please refer to the below link for the solution
- Proposed as answer by Onur Omer Ozturk Tuesday, January 17, 2012 12:13 PM
- Marked as answer by Eileen Zhao Monday, January 23, 2012 2:23 AM
All replies
-
Please refer to the below link for the solution
- Proposed as answer by Onur Omer Ozturk Tuesday, January 17, 2012 12:13 PM
- Marked as answer by Eileen Zhao Monday, January 23, 2012 2:23 AM
-