Microsoft SQL Server Timeout Settings

Owned by Julie Doyle-Whitelock (Deactivated)
Aug 10, 2016
2 min read

Modify - Remote Query Timeout Settings

Use Remote Query Timeout to specify the number of seconds that must elapse when processing a remote operation before Microsoft SQL Server assumes the process failed or took too much time to perform. This length of time can be modified.

The default Remote Query Timeout setting is 600 seconds (10 minutes). A setting of 0 (zero) seconds will result in the server waiting indefinitely for a task to complete.

The setting takes effect immediately (without a server stop and restart).

Important: Please read the Microsoft SQL Server documentation for a comprehensive understanding of the consequences of changing the Timeout Settings.

  1. Open Microsoft SQL Management Studio Express (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
  2. Login to Microsoft SQL Server.
  3. In the Object Explorer list (top left of the screen), right-click on the [Server Name] and select Properties. The Server Properties dialog will be displayed.
  4. Click the Connections page.
  5. Modify the Remote Query Timeout (in seconds, 0 = no timeout).
  6. Click the OK button.

Modify - Remote Login Timeout Settings

Use the Remote Login Timeout option to specify the number of seconds to wait before returning from a failed attempt to log in to a remote server.

Example:  If you are attempting to log in to a remote server and that server is down, remote login timeout ensures that you do not have to wait indefinitely before your computer ceases its attempts to log in.

The Remote Login Timeout option affects connections to OLE DB providers made for heterogeneous queries. The default setting for Remote Login Timeout is 20 seconds. A value of 0 allows for an infinite wait.

The setting takes effect immediately (without a server restart).

Important: Please read the Microsoft SQL Server documentation for a comprehensive understanding of the consequences of changing the Timeout Settings.

  1. Open Microsoft SQL Management Studio Express (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
  2. Login to Microsoft SQL Server.
  3. In the Object Explorer list (top left of the screen), right-click on the [Server Name] and select Properties. The Server Properties dialog will be displayed.
  4. Click the Advanced page.
  5. Modify the Remote Login Timeout field.
  6. Click the OK button.