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
January 17th, 2012 12:46am
Please refer to the below link for the solution
http://blogs.msdn.com/b/jneave/archive/2011/04/15/tcp-provider-error-semaphore-timeout-from-an-ssis-package.aspx
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2012 1:04am
I am having this same issue however my priority boost was already set to 0
June 22nd, 2012 3:53pm