Page History
...
Run
SQLCMInstall.exe
in the root of the SQL Compliance Manager installation kit.- Review the information you need to start the installation and click Next.
- Follow the steps in the Setup wizard to install and configure SQL Compliance Manager in a clustered environment.
- 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.
Run
SQLcomplianceClusterSetup.EXE.
- Once the setup wizard launches, click the Next button to proceed to the License Agreement.
- Read the license agreement, select the option to accept the terms of the license agreement, and click Next.
- Select the destination path in which you want to install the IDERA Cluster Configuration Console. Define the permissions for the software and click Next.
Click Install to complete the installation.
- The Cluster Configuration Console lauches automatically after installation.
- Click Add Service to specify the listener. SQL Compliance Manager displays the Add SQLcompliance Agent Service - General window.
- 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.
- 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
- On the SQLcompliance Agent Service - SQLcompliance Agent Service Account window.
Specify 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 - On the SQLcompliance Agent Service - SQLcompliance Agent Trace Directory window.
Specify 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.
On the CLR Trigger Location dialog window, Specify
Specifythe location where you want the SQLcompliance Agent to store the corresponding CLR trigger assemblies, and
thenclick 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.Note Ensure the Agent Trace directory and the CLR Trigger location specified exist by creating the folder structure manually through Windows Explorer.
Review the configuration Summary and click
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.
Info |
---|
Repeat these steps on each node in your AlwaysOn Availability Group. When you are finished configuring all the nodes, register the cluster service agent as a shared resource. |