Home Email My Account ☎ 480-624-2500

The OLE DB provider MSOLEDBSQL for linked server reported an error.

.Web Design
September 20, 2024

Error: The OLE DB provider MSOLEDBSQL for linked server reported an error. Execution terminated by the provider because a resource limit was reached.

Cause: The query is exceeding the query timeout set on the linked server.

Solution: Update the timeout setting on the linked server.

1. Using object explorer, right click on the linked database server.

2. Under Connections, set the remote query timeout setting to 0 to disable or set a value that would allow your query to complete.

3. Under Advanced, update remote login timout to 30 or a suitable time.

You can also run the following queries:

sp_configure 'remote login timeout', 30

go 

reconfigure with override 

go

sp_configure 'remote query timeout', 0 

go 

reconfigure with override 

go

 

First Name:
Last Name:
Email:
Comment:
Rating:
Jermaine Fagan
Jermaine Fagan
November 1, 2024
Great article!