Versions Compared

Key

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

...

  1. Start the SQL Compliance Manager Management Console.
  2. Select the SQL Server instance to which you want to manually deploy the agent, and click Add Server. SQL Compliance Manager displays the SQL Compliance Manager Configuration Wizard - Add Server.

  3. On the Specify SQL Server page, specify or browse the node, and click Next.

  4. On the Existing Audit Data page, select the option to retain all of the previously-collected audit data and use the existing database, and click Next.

  5. On the SQL Server Cluster page, check this option if the instance is a virtual SQL Server, and click Next.

  6. On the SQLcompliance Agent Deployment page, verify that the Manually Deploy option is selected, and click Next

  7. On the Select Databases page, select the AlwaysOn database, and click Next. T 

  8. SQL Compliance Manager displays the AlwaysOn Availability Group Details page. This page displays information about all nodes where the AlwaysOn database will be replicated. Note that this page does not appear if the database is not AlwaysOn.

  9. Review the available information, and click Next
  10. On the Audit Collection Level page, select the Default audit level, and click Next
  11. On the Permissions Check page, verify that all permissions pass, and click Next
  12. SQL Compliance Manager displays the Summary page. Click Finish.

...