You can install and deploy SQL Compliance Manager to meet your unique auditing and SQL Server environment needs. For example, you can select which specific databases on your SQL Server instances you want to audit.
Typical environment
The following figure illustrates a typical SQL CM implementation scenario. This configuration includes the following installations:
- Management Console on your workstation (and, optionally, the Collection Server computer)
- Collection Service and Repository on a SQL Server database server
- SQLcompliance Agents on each computer hosting databases you want to audit
Clustered environment
You can install and configure SQL Compliance Manager to audit virtual SQL Servers. A virtual SQL Server is a SQL Server running on a Microsoft failover cluster managed by Microsoft Cluster Services.
This configuration includes the following installations:
- Management Console on your workstation
- Collection Service and Repository on a SQL Server Database server
- SQLcompliance Agents on each cluster node hosting the virtual SQL Server you want to audit
For more information, see Audit a virtual SQL Server instance.
Non-trusted environment
You can install and configure SQL Compliance Manager to audit SQL Server instances running in non-trusted domains or workgroups. This configuration includes the following installations:
- Management Console on your workstation
- Collection Service and Repository on a SQL Server database server
- SQLcompliance Agents on each SQL Server instance you want to audit in a non-trusted domain or workgroup