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.