How to Increase the MS SQL Remote Query Timeout

How to Increase the MS SQL Remote Query Timeout

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a remote operation can take before SQL Server times out. Note that, it only applies to an outgoing (not incoming) connection initiated by the Database Engine as a remote query. The default value for this option is 600 seconds, which can be configured either via SQL Server Management Studio or Transact-SQL.

Using SQL Server Management Studio: 

  1. Connect to MS SQL server via SQL Management Studio.
  2. In Object Explorer, right-click on the server name and then select Properties.

     3. In the new tab, click on Connections node.

     4. In Remote Query Timeout change it to your desired value or specify 0 to set no limit.
 

 

     5.  Click on OK to save the changes.

Using Transact-SQL

  1. Connect to MS SQL server via SQL Management Studio.
  2. From the Standard bar, click on New Query.
  3. Run the below query to set the Remote Query Timeout to 0 seconds ( 0 is unlimited). Similarly, you can replace 0 with your desired value (default is 600 seconds).

EXEC SP_CONFIGURE 'remote query timeout', 0 reconfigure EXEC sp_configure

        4. Click Execute or F5.


    • Related Articles

    • Accessing MS SQL database using myLittleAdmin

      To access MS SQL database using myLittleAdmin please follow the below steps. STEP: 1 Login to the Plesk panel and click on Website and Domains on left Menu Bar then select Database Option 1 and 2 will open the Database panel wherein option 3 will ...

    • MS SQL database creation

      Log in SQL Server Management Studio to create database. Create a folder in "C:\SQLdomain\" as your domain name. C:\SQLdomain\testdomain.com Click right mouse button on Databases to open database menus and click New Database link. Assign a Database ...

    • How to use MSSQL Activity Monitor to find the most expensive query

      There are certain ways to identify and troubleshoot long running queries.This prevents potential performance issues. SQL Activity Monitor is the easiest and rich UI tool available in SQL Server Management Studio.It provides information about ...

    • How to Create MS SQL Database Through SQL Server Management Studio

      This article will assist you to create MS SQL database through SQL Server Management Studio. 1. Open Run box by pressing Windows key + R. 2. In Run box type SSMS and hit enter. This will open connect to server window.

    • How to change password for MS SQL admin user

      Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you have working sa or windows user password. 1. Login to MSSQL server by using current sa password through MS SQL management studio. 2. In left pane of ...