Now that the IDERA Cluster Configuration Console is installed, you need to add the SQLcompliance Agent to the clustered instance that is to be audited.
These steps must be performed on all nodes of the cluster.
- In the Cluster Configuration Console click Add Service.
- On the General dialog window, specify the name of the clustered instance to be audited by SQL Compliance Manager and click Next.
- On the Collection Server dialog window, specify the host name of the server hosting the SQLcompliance Collection Service and click Next.
- On the SQLcompliance Agent Trace Directory dialog window, specify the path on which trace files will temporarily reside before being transferred to the SQLcompliance Collection Service.
The path specified should be on a drive that is a part of the same resource group as the SQL Server instance that will be audited On the CLR Trigger Location dialog window, specify the path on which trigger assembly files will reside. The path specified should be on a drive that is a part of the same resource group as the SQL Server instance that will be audited.
Click Next.Ensure the agent trace directory and the CLR trigger location specified exist by creating the folder structure manually through Windows Explorer.
- Review the configuration and click Finish.
- The IDERA Cluster Configuration Console displays a confirmation message stating that you have successfully added the SQLcompliance Agent.
Click OK.