Page History
...
There are two scenarios of how SQL Compliance Manager can work with AlwaysOn availability group databases:
- Listener. Use this scenario when you want to audit a listener (virtual SQL server instance) that works only with a node in the PRIMARY role.
- Nodes. Use this scenario when you want to audit every node that can be in PRIMARY or SECONDARY roles. Note that the secondary role is read-only.
...
Review the following links to configure AlwaysOn Availability Groups:
Configuring Listener scenarioListener scenario:
- Install cluster agent services on all Listener nodes using the SQL Compliance Manager Cluster Configuration Console
- Install cluster agent services on all Listener nodes using the Failover Cluster Manager
- Add the Listener to SQL Compliance Manager
Configuring Nodes scenario:
- Manually deploy the SQL Compliance Manager Agent
...