Page History

...

1. Install cluster agent services on all Listener nodes using the SQL Compliance Manager Cluster Configuration Console
2. Install cluster agent services on all Listener nodes using
3. Add the Listener to SQL Compliance Manager Manager 

1.

Anchor
Install cluster agent Install cluster agent

Install cluster agent services on all Listener nodes using the SQL Compliance Manager Cluster Configuration Console

...

2.

Anchor
install cluster agent2 install cluster agent2

Install cluster agent services on all Listener nodes using the Failover Cluster Manager

Use the following steps on each node involved in the AlwaysOn group before adding the listener to SQL Compliance Manager for auditing.

1. After installing the cluster agent service on all Listener nodes, open Server Manager.
2. In the Server Manager tree, click Server Manager > Features > Failover Cluster Manager. The system displays Failover Cluster Manager.
3. Select the Cluster Service Group (Windows Server 2008) or the Role (Windows Server 2012 and later) created for the cluster agent service. 
4. In the Server Name area, right-click the resource name and click Properties. Failover Cluster Manager displays the Properties window. 
5. Click the Dependencies tab.
6. Verify that the Resource field displays the listener IP address.
7. In the Other Resources area of the Failover Cluster Manager window, right-click the the resource within the cluster service group or the role, and select Properties. Failover Cluster Manager displays the Properties window. 
8. Click the Dependencies tab.
9. Verify that the Resource field displays the listener name. Click Cancel to close this window.
10. After adding the resource information, right-click the Cluster Service Group (Windows Server 2008) or the Role (Windows Server 2012 and later) in the tree, and point to Add a resource.
11. Click on Generic Service. Failover Cluster Manager displays the New Resource Wizard.
12. In the Select Service page, select the cluster service agent from the available list. The cluster service names are displayed in the format SQLcomplianceAgent$[listener name] where [listener name] is a virtual SQL Server name. 
13. Click Next, continue following the wizard, and click Finish. 
14. In the Other Resources area of the Failover Cluster Manager window, right-click the SQLcomplianceAgent$[listener name], and Bring Online the resource. 
15. While the cluster service is online, right-click the SQLcomplianceAgent$[listener name] cluster service, and click Properties.
16. On the General tab verify that the Role is added.

17. On the Registry Replication tab, click Add. Failover Cluster Manager displays the Registry Key window.

    Note
    The Registry Replication tab is not available in Windows Server 2012. If you are using Windows Server 2012, you must use the "Add-ClusterCheckpoint" PowerShell cmdlet to add the necessary setting. For more information, see Add ClusterCheckpoint.

18. Type the specific registry path. To obtain the correct path, go to the IDERA Cluster Configuration Console and copy the Replicated Registry Key from the SQLcompliance Agent details.    
19. Click OK. The new root registry key appears in the Registry Replication tab of the Properties window, as shown in the following example.
20. Close the Properties window by clicking OK.

3.

Anchor
addthelistener addthelistener

Add the Listener to SQL Compliance Manager

Use the following steps to add the listener to SQL Compliance Manager for auditing.

...

After configuration, review some Additional information information on SQL Compliance Manager and AlwaysOn Availability Groups.