Page History

...

1. Run Run SQLCMInstall.exe in in the root of the SQL Compliance Manager installation kit.
2. Review the information you need to start the installation and click Next.
3. Follow the steps in the Setup wizard to install and configure SQL Compliance Manager in a clustered environment. 
4. Once the installation is complete, go to the SQL Compliance Manager install path. Unless you have specified a different path, the one by default is C:\Program Files\IDERA\SQLCompliance.

5. Run SQLcomplianceClusterSetup.EXE.

6. Once the setup wizard launches, click the Next button to proceed to the License Agreement. 
7. Read the license agreement, select the option to accept the terms of the license agreement, and click Next.
8. Select the destination path in which you want to install the IDERA Cluster Configuration Console. Define the permissions for the software and click Next. 

9. Click Install to complete the installation. 


10. The Cluster Configuration Console lauches automatically after installation.
    
11. Click Add Service to specify the listener. SQL Compliance Manager displays the Add SQLcompliance Agent Service - General window.
12. On the General dialog window, type the name of the clustered instance to be audited by SQL Compliance Manager and click Next. If you receive a message stating that the selected SQL Server instance is not clustered, click Yes. This is correct behavior when configuring a Listener scenario and confirms that the selected SQL Server instance is hosted on a Windows Failover Cluster.
13. On the Collection Server dialog window, specify the name of the server where SQL Compliance Manager is installed, and click Next. 
14. On the SQLcompliance Agent Service Account dialog window, specify the login credentials for the Agent service account, and click Next. This account must have administrator privileges. IDERA recommends that you use the same account as used for the Collection Server. 
15. On the SQLcompliance Agent Trace Directory dialog window, specify the path on which trace files will temporarily reside before being transferred to theSQLcompliance Collection Serviceand click Next. Note that the administrator account specified for the cluster agent service has read/write permissions for this trace directory folder. 

16. On the CLR Trigger Location dialog window, Specify the location where you want the SQLcompliance Agent to store the corresponding CLR trigger assemblies, and click Next.  Note that the administrator account specified for the cluster agent service has read/write permissions for this assembly folder. 

    Note
    Ensure the Agent Trace directory and the CLR Trigger location specified exist by creating the folder structure manually through Windows Explorer.

17. Review the configuration Summary and click Finish.

18. The IDERA Cluster Configuration Console displays a confirmation message stating that you have successfully added the SQLcompliance Agent. 
    Click OK.

...

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 the Role 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, click the Role, 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.

...