Remote query timeout server configuration option in SQL Server specifies how much time in seconds will SQL Server wait for a remote query of an outgoing connection before it times out. It has no effect on incoming queries issued by clients connected to SQL Server. Query timeout is a client-side setting. An example is a query to a linked server, in which case our SQL Server becomes a client to another server.
The default value for this setting is 600 seconds. You can check the current Remote query timeout setting by running:
sp_configure 'remote query timeout (s)'
To change the value for the Remote query timeout setting (for example to 900 seconds):
EXEC sp_configure 'remote query timeout', 900;
To disable the timeout, set the value to 0:
EXEC sp_configure 'remote query timeout', 0;
You can check and change the current setting by right-clicking on the instance name in Object explorer in SQL Server Management Studio, and selecting Properties, and Connections:
This setting is located just below the checkbox that allows remote connections to the server. It is important to be aware that the remote query timeout value below is not a timeout setting for incoming connections to the server. Clients need to set the query timeout in their connection setting.