-
Title
Can the Synchronization Service Utilize SQL AlwaysOn Availability Groups? -
Description
Some customers may wish to leverage a SQL AlwaysOn Availability Group (AG) for the Active Roles Synchronization Service component.
-
Resolution
The Active Roles Synchronization Service fully supports having its Configuration and/or Synchronization databases hosted on a SQL AlwaysOn Availability Group.
When configurating the product and where prompted for a Data Source, specify the Availability Group Listener.
It is also possible to change an existing installation of the Active Roles Synchronization Service to leverage an AG by modifying existing registry keys located here:
Active Roles 7.1 and earlier:
HKEY_LOCAL_MACHINE\SOFTWARE\Dell\Active Roles\Configuration\SyncService\DBConnectionStrings\QCConfiguration
Active Roles 7.2 and later:
HKEY_LOCAL_MACHINE\SOFTWARE\One Identity\Active Roles\Configuration\SyncService\DBConnectionStrings\QCConfiguration
