Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Info

You need to must perform these steps on all nodes of the cluster.

  1. Once the Cluster Configuration Console launches, click Add Service.
  2. On the General dialog window, specify the name of the clustered instance to be audited by IDERA SQL Compliance Manager Manager and click Next.
  3. On the Collection Server dialog window, specify the name of the server hosting the SQLcompliance Collection Service and click Next.
  4. 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 to be audited.
  5. 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 to be audited.
    Click Next.

    Note

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

  6. Review the configuration and click Finish.  
  7. The The  IDERA Cluster Configuration ConsoleConsole  displays a confirmation message stating that you have successfully added the SQLcompliance Agent
    Click OK. 

...