Page History

...

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 two sets a set of instructions to register the SQL Compliance Manager services as a clustered resource:

...

Adding

...

SQL Compliance Manager

...

Collection service to an existing role

Creating a new role for SQL Compliance Manager services

To create the clustered service resource:

After finishing the installation in all nodes, go to the active node and follow the steps below. 

1. Open the Microsoft Failover Cluster Manager, go to the Failover Cluster Manager, and select Roles
2. Right-click on the SQL Server role, point to Add Resource, and select Generic Service
   
   Image Added
   
   
   
3. Microsoft Failover Cluster Manager displays the New Resource Wizard
4. Select the SQLcompliance Collection Service, click Next, review the generic service configuration summary, and click Finish
5. In the Roles section, right-click the SQLcompliance Collection Service, and select Properties
   
   Image Added
6. Log onto the currently active cluster node using an administrator account, and then start the Microsoft Failover Cluster Manager.
7. Right-click the SQL Server role, and then select Add Resource > Generic Service.
8. Complete the New Resource Wizard to create the SQLcompliance Collection Service.
9. Right-click the service you just created, and then select Properties.
   
   

10. On the General tab, check the Use Network Name for computer

    name check box.

    name box, and click Apply
    
    

    Info
    If this actions 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.

11. On the Registry Replication tab, click AddClick Add to add a new root registry key.

12. Type Software\Idera\

    SQLcompliance,

    SQLcompliance and

    then click OK.Start the new generic service by bringing the resource online.

    click OK

    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.

13. In the Roles section right-click the SQLcompliance Collection Service and Bring the resource Online. 
    
    Image Added
    
    
14. Open the Microsoft Failover Cluster Manager on the other nodes and verify if the SQLcompliance Collection Service is online.