AnnaB
Reputation: 35
SQL SERVER - TCP an OLE DB Provider Errors
I'm using a Linked Server to execute remote queries between two DBs on different servers. Both DBs are SQL SERVER. However, I'm getting the following errors:
1 - TCP Provider: The semaphore timeout period has expired.
2 - OLE DB Provider: "SQLNCLI10" for linked server "xxx" returned message: "communication link failure".
The queries are executed through C# and these errors occur sporadically, not all the time. Also, I'm executing the same code/queries with another linked server and none of these errors have occured. Both linked servers are configured the same way. The code has been running for 72 hours on both machines. I can't understand why the errors happen. So, any help would be appreciated :)
Upvotes: 0
Views: 482
Answers (0)
Related Questions
- The OLE DB provider "SQLNCLI11" for linked server could not INSERT
- An OLE DB Provider was not specified in the ConnectionString. 'Provider=SQLOLEDB;
- Error: "OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found ..."
- Linked server error OLE DB provider "SQLNCLI10"
- SQL SERVER LINKEDSERVER ERROR OLE DB provider "SQLNCLI10" for linked server
- Connect to SQL using OleDbConnection failing
- OLe DB provider "SQLNCLI" for linked server was unable to begin a distributed transaction
- Error with "ad hoc access to OLE DB provider" when I'm not using that provider in ASP application
- OLE DB provider "SQLNCLI" for linked server "MY_DB" returned message "Communication link failure"
- Keep getting an error when using OledbConnection