Configure Timeout Settings for SQL Server

Long-running queries or reports may exceed the default database timeout and fail before the operation completes. To prevent this, you can increase the database command timeout in the VertiGIS Studio Reporting configuration and specify a connection timeout for the SQL Server data source. Increasing these values allows SQL Server queries additional time to finish processing.

To configure the timeout settings for SQL Server:

1. As an administrator, edit the following web.config file:

   [installation_location]\VertiGIS Studio Reporting\Deployment\web.config

   If you installed VertiGIS Studio Reporting in the default location, the web.config file is here:

   C:\Program Files\VertiGIS\VertiGIS Studio Reporting\Deployment\web.config

2. In <appSettings>, add this line:
   <add key="app:DbCommandTimeout" value="180" />

3. Save the file.

4. Add the Connection Timeout in the SQL Server Data Source.