Troubleshooting timeout errors
Note: This topic applies only to
on-premises environments.
If you receive timeout errors when executing long-running processes, use this topic as a troubleshooting guide. The items listed are listed in the order you should check them. It is a good idea to keep track of the original settings so you can change them back if you need or want to.
-
Edit the Query
Timeout value in the Configuration Manager:
- On the application server, select .
- Select the configuration and click .
- For the application database, ensure Query Timeout is set to 0 to make the timeout unlimited.
-
On the SQL Server (database server), set the Query Wait value:
- Open SQL Server Management Studio and log in.
- Right-click on your SQL Server and select .
- Click .
- Set the value of Query Wait to 0 to make the timeout unlimited.
-
Set the MSDTC Transaction Timeout value:
- On the application server, select .
- Expand until you find .
- Right-click on and select .
- Click the Options tab and set Transaction Timeout value to 0.
-
Set the
httpRuntime executionTimeout
value in the web.config file on the application server where IIS is running: -
Set the
machineSettings maxTimeout
value in the machine.config file on the application server: