We have a job that does use linked server to copy some data from a MS SQL 2000 database and insert it into a database which runs in MS SQL Server 2005.This job is configured in the 2005 server.
Offlate we started encountering the error
OLE DB provider "SQLNCLI" for linked server "RSSDR" returned message "Communication link failure". [SQLSTATE 01000]
Error Number::121 Error Message::TCP Provider: The semaphore time-out period has expired.
Initially thought its a network issue but network team have confirmed there were no network issue at the specified time.Is it something related to network adapters,card or some other firware.
Any help would be highly appreciated.
View Complete Post