How to set a Timeout on Accelerate (Connect 2) Queries for SQL Server

If you'd like SS&E Connect to timeout in the case of long-running queries, add an appropriate timeout to your connection string in the Accelerate Configuration.

Note: When adding or changing the timeout length, remember to edit only the Child XML.

To do this:

1. Navigate to Administration SIS Integration Accelerate Configuration.
2. Find the
3. Add to the very end ";queryTimeout=XXXX" where XXXX is the timeout length in seconds.

   For example, in the screenshots below, the Connect2 configuration of the Child XML is set with a ConnectionString timeout length of 30 minutes (1800 seconds).

   

   Right before , we added queryTimeout=1800:

   

4. In addition to the queryTimeout parameter, you may also set a socketTimeout parameter (in milliseconds). If used, the socketTimeout should be in addition to the above queryTimeout, and it should be set to a value that is greater than the queryTimeout.

   The reason being is that while the queryTimeout parameter will indicate to SQL Server to kill the query on the database, the socketTimeout may just kill the connection while allowing the query to continue running. Therefore, we must set the query to timeout first.