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