Page History

...

1. Log onto the active cluster node using an administrator account and launch the Microsoft Failover Cluster Manager. 
2. Right-click the role created for the clustered instance, point to Add a Resource, and select Generic Service.
   
   
   
   
3. On the Select Service dialog window, select the SQL Compliance Manager Agent service created previously, continue following the wizard, and click Finish.
   
   
   
   
4. The Failover Cluster Manager displays the new resource in the resources tab. Right-click the new resource and select Properties.
   
   
   
   
5. In the General tab, specify the Service name as the Agent Service name found in the SQLcompliance Agent details.
   
   
6. Clear the Startup parameters.
7. Go to the Dependencies tab and add the following dependencies:
   1. SQL Network Name: name of the cluster hosting the SQL instance to be audited.  
   2. Cluster Disk(s): the disk(s) on which the agent trace directory and the CLR trigger assemblies reside. 
   3. SQL Server: the SQL Server instance to be audited by SQL Compliance Manager.
      
      
   
8. Once the dependencies are configured, click Apply.
9. Return to the General tab, check the Use Network Name for computer name box and click Apply. 

10. Go to the Registry Replication tab. 

    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 Newtablink alias Add ClusterCheckPoint url https://docs.microsoft.com/es-es/previous-versions/windows/powershell-scripting/hh847255(v=wps.620) .

    Add a 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.    
    Click OK.

11. On the Properties window, click Apply to save the changes, and click OK to return to the Resources tab. 

12. Right-click the SQLcompliance Agent resource and click Bring Online. 
    
    
    

...

After successfully deploy the SQL Compliance Manager Agent, you can start auditing your virtual SQL Server instances.

...