You can follow below steps to update Remote Query Timeout in MSSQL:
- Login to MSSQL server with SQL Server Management Studio
- On the left side in Object Explorer right click on particular server name and choose “Properties” option.
- A new window will open where you have to click on “connections” option.
- You will find Remote Query Timeout option where you can set the limit according to your need.
- At last click on “OK”.