Page History
IDERA SQL Compliance Manager supports auditing a virtual SQL Server instance including the local instance on a cluster running the Collection Server. Use the following checklist to help you deploy
After you install and configure the SQL Compliance Manager in a clustered environment.
...
...
...
Install SQL Compliance Manager.
...
...
Identify which virtual SQL Server instances you want to audit.
...
...
...
...
...
...
Deploy the SQLcompliance Agent to each cluster node using the Cluster Configuration setup program.
...
...
Add the SQLcompliance Agent Service on each cluster node using the Cluster Configuration Console.
...
...
Register the SQLcompliance Agent Service as a generic service using the Microsoft Cluster Administrator tool.
...
...
Register each virtual SQL Server instance with SQL Compliance Manager using the Management Console. Note that you must choose manual deployment for the SQLcompliance Agent.
...
...
Specify the SQL Server events you want to audit on each registered virtual SQL Server instance using the Management Console.
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
...
...
- .
Scroll pdf ignore |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...