SQL Server Performance

SQL Server 2005 Linked Server Issue

Discussion in 'SQL Server 2005 General DBA Questions' started by sonnysingh, Oct 17, 2011.

  1. sonnysingh Member

    Hi All

    I am importing data every 5 minutes from production server using linked server. This service (job) running on 2 server e.g. fetching data from this production Server to the 2 Server and these are on SQL Server 2005.

    ON 1 server data importing service running without any error (issue) but on other server service giving following Error...

    "Executed as user: NT AUTHORITY\SYSTEM. Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 10054) OLE DB provider "SQLNCLI" for linked server "LS_101210040" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "LS_101210040" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "LS_101210040" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "LS_101210040" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed."

    There are some solutions that I have found on net, but I am confused which one this could be. I need help here to solve this ASAP...

    Thanks in Advancve
    Sonny
  2. satya Moderator

    What kind of client connectivty driver are you using, is it SQLNative client or JDBC/JTDS?
    Also check what other protocols are enabled between the servers.

Share This Page