Error: OLE DB provider "MSOLEDBSQL" for linked server returned message "Query timeout expired".
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.
You can also run the following query:
sp_configure 'remote query timeout', 0
go
reconfigure with override
go
