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.




  • 2 Users Found This Useful

Was this answer helpful?

Related Articles

How to Install Advanced Features on Existing Instance of MS SQL Server?

If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll...

How to assign particular permissions to SQL server database user from SQL Server Management Studio?

We can restrict SQL database users to fire some critical queries, e.g. Update, Delete, etc....

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...