This error message is due to the server setting of Remote Connection Query Timeout. The default is
600 seconds, or
10 minutes.
EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure
EXEC SP_CONFIGURE 'show advanced options', 1
reconfigure
EXEC sp_configure
EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure
After making this change, make sure to close the window and create a new connection in order to inherit the new query timeout settings.
Regards,
Eduard