Page History

...

1. Run SQLCMInstall.exe 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. Type the SQL Server instance name, and then 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. SQL Compliance Manager displays the Add SQLcompliance Agent Service - Collection Server window.
    Image Removed
    Image Added
13. On the Collection Server dialog window, specify Specify the name of the server where SQL Compliance Manager is installed, and then click Next. SQL Compliance Manager displays the Add  
    Image Added
14. On the SQLcompliance Agent Service - SQLcompliance Agent Service Account window.
    Image RemovedSpecify Account dialog window, specify the login credentials for the Agent service account, and then click Next. This account must have administrator privileges. Idera IDERA recommends that you use the same account as used for the Collection Server. After clicking Next, SQL Compliance Manager displays  
    Image Added
15. On the SQLcompliance Agent Service - SQLcompliance Agent Trace Directory window.
    Image RemovedSpecify the trace directory for the cluster agent service, and then click Nextdialog 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. SQL Compliance Manager displays the Add SQLcompliance Agent Service - CLR Trigger Location window.
    Image Removed 
    Image Added

16. On the CLR Trigger Location dialog window, Specify

    Specify

    the location where you want the SQLcompliance Agent to store the corresponding CLR trigger assemblies, and

    then

    click Next.  Note that the administrator account specified for the cluster agent service has read/write permissions for this assembly folder.

    SQL Compliance Manager displays the Add SQLcompliance Agent Service - Summary window.
    Image Removed

     

    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 
    
    Image Added

    
    

18. The IDERA Cluster Configuration Console displays a confirmation message stating that you have successfully added the SQLcompliance Agent. 
    Click OKVerify that the Summary window displays the correct SQL Server instance that you want to audit, and then click Finish.  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. SQL Compliance Manager displays a confirmation message.