When Active Roles is configured to use a database hosted on a SQL instance which is using a custom port or Always On Availability Groups, it is possible to successfully configure Active Roles to use this SQL instance by specifying the port number in the SQL server connection string like so:
sqlServer\instanceName,1234
However, attempting to configure a second Active Roles service to use the same configuration database using the Active Roles Configuration Center will fail. The SQL server settings for the Management History database will have the port stripped out, and the connectivity check will timeout and fail. When using a SQL Always On Availability Group, the Management History database does not use the listener and instead is hard-coded to use a particular SQL instance.
WORKAROUND
Run the Active Roles Management Shell to configure the administration service.
STATUS
As of Active Roles 7.3.1, this issue is resolved as a registry-enabled fix as per the Active Roles 7.3.1 release notes:
7.3.1 Registry Fix:
NOTE: Active Roles service account must have the View Server State permission in the SQL server.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy