Question
How do I increase the timeout setting in SQL?
Answer
In order to increase the timeout setting in SQL, please follow below steps:
Step 1
Run Microsoft SQL Server Management Studio
Step 2
Right-click on the instance name - Properties
Step 3
Go to Connection page - Remote server connections. Here we can increase the value or put 0 as no timeout.
Step 4
Click OK to apply changes.