After installing the SQL Compliance Manager components on your cluster nodes, create the clustered service resources to allow SQL Compliance Manager to recognize the cluster nodes.
Registering SQL Compliance Manager services with Microsoft Failover Cluster Manager allows the Microsoft Cluster Service to manage the services in failover situations. The following configuration ensures the high availability of the services during a failover.
Below you can find a set of instructions to register the SQL Compliance Manager services as a clustered resource:
After finishing the installation in all nodes, go to the active node and follow the steps below.
On the General tab, check the Use Network Name for computer name box, and click Apply
If this action throws an error, try again after configuring the following information:
Go to the Dependencies tab, add the following resources: SQL Server and SQL Server Agent, and click Apply.
Software\Idera\SQLCM and click OK
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.
After registering the collection service as a clustered resource, proceed to install the IDERA Cluster Configuration Console to configure the SQL Compliance Manager Agent.