Registering the SQLcompliance Agent Service with the Microsoft Cluster Administrator allows the Microsoft Cluster Service to manage the SQLcompliance Agent Service in failover situations. This configuration ensures the SQL trace continues to be audited during a failover and no audit data is lost.
Complete the following procedure on one cluster node hosting the virtual SQL Server instance. You can perform this task on the currently active node or on any passive node in the same cluster. The Microsoft Cluster Administrator tool replicates your completed configuration to the remaining nodes in the cluster.
Specify the following dependencies:
Specify the following generic service permissions:
Agree to replicate registry entries, and then specify the registry key for the SQLcompliance Agent Service. Use the SQL Compliance Manager Agent Details window in the Cluster Configuration Console to copy the registry key path to your clipboard. Paste the name in the provided field.
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |