Page History

...

• While enabling Audit Logs from Web or Windows Management console. 
  • SQL Compliance Manager checks for the following conditions, which all must be met to successfully enable Audit Logs:
    • The Agent is reachable.
    • SQL Server 2017 or above.
    • SQL Compliance Agent 5.5 or above.

Enable Audit Logs mode using the

...

Web Console

Users wanting to take advantage of SQL Server Audit Logs auditing capabilities can do so by completing the following steps:

1. In your IDERA SQL CM Dashboard menu, Select the Instances tab.
2. Click the gear icon under the Options column of Right-click on the instance you want to audit, and select select Properties(instance). 
3. Select the In the Registered SQL Server Properties window, select the Audited Activities tab tab. 
4. Under the Audited Activity options, select the the Capture DML and SELECT activities using Select activities options, select the Via SQL Server Audit Specifications checkbox option. Click OK
5. Click OK.

For more information about enabling this feature using the Web Console, see Manage Instance Properties - Audited Activities tab. 

Enable Audit Logs mode using the

...

Windows Management Console

Users wanting to take advantage of SQL Server Audit Logs auditing capabilities can do so by completing the following steps:

1. Right-click the instance you want to audit and select Properties. 
2. In the Registered SQL Server Properties window, select the Audited Activities tab. 
3. Under the

...

1. Capture DML and Select activities options, select the

...

1. Via SQL Server Audit Specifications

...

1. option.
2. Click OK. 

Click the gear icon of the instance you want to audit, located under the Options column, and select Properties.