stevegray
4Penny.net
Points: 55409

9/1/2023 11:04:13 AM

OLE DB provider "SQLNCLI11" for linked server "[my server]" returned message "Query timeout expired".

I'm trying to run a query on a linked server and it's timing out and giving me 

OLE DB provider "SQLNCLI11" for linked server "[my server]" returned message "Query timeout expired".

I looked at the linked server properties and the Connection Timeout setting is 0, which usually means 'unlimited'

Solution below. 

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3