IDERA SQL Compliance Manager supports auditing a virtual SQL Server instance including the local instance on a cluster running the Collection Server.
After you install and configure the SQL Compliance Manager Agent on each node of the Microsoft failover cluster where the virtual SQL Server instance is running, you can test your configuration and begin auditing the instance.
To audit the virtual SQL Server:
- Verify that the SQL Compliance Manager Agent is running.
- Use the Registered Server Properties window to modify the existing audit settings or configure additional audit settings for server-level events.
- Use the New Audited Database wizard to configure the audit settings for all databases hosted by the virtual SQL Server instance.
When you decide to stop auditing a virtual SQL Server instance, use the following procedure to remove your configuration settings and uninstall the SQL Compliance Manager Agent.
To stop auditing the virtual SQL Server:
- Use the Microsoft Cluster Administrator tool to remove the registered generic service you created for the SQL Compliance Manager Agent Service. You can perform this task on any node of the cluster hosting the virtual SQL Server instance.
- Use the Cluster Configuration Console window to remove the SQL Compliance Manager Agent Service. This action deletes the SQL Compliance Manager Agent Service. Be sure to perform this task on each node of the cluster hosting the virtual SQL Server instance.
- Use Add/Remove Programs to uninstall the Cluster Configuration Console and the SQL Compliance Manager Agent. You must perform this task on each node of the cluster hosting the virtual SQL Server instance.
- Use the Management Console to remove the registered SQL Server instance.