We are facing error when trying to connect to and execute queries using a linked server. The SQL Server and the Linked Server are able to ping
and telnet
each other. Also testing the link returns positive. However, the following error is returned when we execute a query accessing the linked server:
OLE DB provider "SQLNCLI11" for linked server returned message "Protocol error in TDS stream".
OLE DB provider "SQLNCLI11" for linked server returned message "Communication link failure".
Msg -1, Level 16, State 1, Line 0
Session Provider: Physical connection is not usable [xFFFFFFFF].
OLE DB provider "SQLNCLI11" for linked server returned message "Communication link failure".
Msg -1, Level 16, State 1, Line 0
Session Provider: Physical connection is not usable [xFFFFFFFF].
OLE DB provider "SQLNCLI11" for linked server returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
I'm trying to prove that this is a network issue, but since the communication channel is open and ping
and telnet
work, the task fell back in my basket.
Any advice will be greatly appreciated.