SQL Server Remote Query Timeout Setting

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;
GO
RECONFIGURE ;
GO

To disable the timeout, set the value to 0:

EXEC sp_configure 'remote query timeout', 0;
GO
RECONFIGURE;
GO

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.