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