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
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.