Extending the coordinator SQL connection retry interval (4344556)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Extending the coordinator SQL connection retry interval
Description

By default, the coordinator will retry to connect to the SQL server every 60 seconds, up to three times, once it has lost connectivity to the database. If your database is offline for more than three minutes, you might want to try and extend that retry interval to give the database time to come back online.
Cause

There are several reasons why the coordinator could lose connectivity to the database. A temporary loss of network connectivity, a fail-over event, the service may need to recover from an unexpected halt, the server may have been rebooted.
Resolution

You can modify the retry interval by adding/adjusting the following key using the registry editor on the coordinator server:

Location: Registry

Path: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor\Coordinator

Value Name: DatabaseRetryIntervalInSeconds

Value Type: DWORD (32-bits)

Value Base: Decimal

Value Data: 60 (Default)

Restart the Coordinator service to commit changes.

NOTE: Consider increasing if the coordinator is experiencing login failures due to a SQL server restart (e.g., during a patch). 3 attempts are made between each timeout interval to reconnect to the database, and this cannot be changed.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title