Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL 2008 - Link Server Issue

Author  Topic 

etfocus
Starting Member

1 Post

Posted - 2010-12-02 : 11:20:57
Has anyone encountered this error before? SQL Logs and Windows Event Viewer provide no clue there was a problem. Here's the message (btw: a sql job was executing when it encountered the message):
Message
Executed as user: NT AUTHORITY\SYSTEM. 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 "SQLNCLI10" for linked server "<<server ip>>" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server "<<server ip>>" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server "<<Server IP>>" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server "<<Server IP>>" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.
   

- Advertisement -