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.

    SQL Server Management Studio

  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.

    Connections

  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.

→ Looking to change the MSSQL database port? Please refer to change MSSQL port for more details?

Related Articles

How to create a Database in MSSQL Server?

If you have a Windows VPS / Dedicated server with MSSQL Server and WebsitePanel installed, you...

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...

Do you offer SQL schedule job?

Windows Shared HostingWe do not offer SQL server schedule job in our Windows shared hosting...

vs shell installation has failed with exit code 1638.

You may receive the following error while installing MSSQL 2017 on Windows 2012 R2 Server. vs...

How to change Database Collation in MsSQL Server?

Collation is a configuration level setting in the MSSQL. It directs how the character data will...

  • 2 Users Found This Useful

Was this answer helpful?