Registering a SQL Server instance allows you to audit this instance and the associated databases. For each database you want to audit, register the corresponding SQL Server instance. When you register the instance, you can also deploy the SQL Compliance Manager Agent to begin auditing SQL events on this instance.
Before registering your SQL Server instance:
- Ensure the SQL Server instance you want to register meets the hardware and software requirements.
- Decide which SQL Server events you want to audit on this instance.
- Start the Management Console, and then click New > Registered SQL Server.
To Register your SQL Server instance follow the steps from the New Registered SQL Server wizard below:
- Configuration wizard - Add Server window
- Configuration wizard - License Limit Reached window
- Configuration wizard - Existing Audit Data window
- Configuration wizard - Existing Incompatible Database window
- Configuration wizard - SQL Server Cluster window
- Configuration wizard - SQL Compliance Manager Agent Deployment window
- Configuration wizard - Add Databases window
- Configuration wizard - Audit Collection Level window
- Configuration wizard - Permissions Check window
- Configuration wizard - Summary window
- Configuration wizard - Specify Connection Credentials window