The Permissions Check window of the Configuration wizard displays the results of a check of the permissions required by IDERA SQL Compliance Manager on the SQL Server instance you want to monitor. This check runs automatically each time you register a new instance.

If the check fails, review the issue, make the required change to the target SQL Server instance, and then click Re-check. Once the check in complete, click Next to continue.

Required permissions include:

  • Collection Service must have rights to the Repository databases
  • Collection Service must have rights to read the registry at HKEY_LOCAL_MACHINE\Software\Idera\SQLcompliance
  • Collection Service must have permissions to the collection trace directory
  • Agent Service must have permissions to the agent trace directory
  • Agent Service must have rights to read the registry at HKEY_LOCAL_MACHINE\Software\Idera\SQLcompliance
  • Agent Service must have rights to the SQL Server instance
  • SQL Server must have permissions to the agent trace directory
  • SQL Server must have permissions to the collection trace directory

You can make changes to the registry at HKEY_LOCAL_MACHINE\Software\Idera\SQLcompliance to update permissions for your services. for more information about the registry key, see Manage the registry key.

 

Available actions

Re-check

Allows you to re-check the required permissions after making an update to the target SQL Server instance in case the preliminary check fails.

Available fields

Progress

Displays an icon that shows whether the check is in progress, passed, or failed.

Check

Displays the list of permissions checked in this step.

Status

Displays the current status of the associated check. All checks display Waiting until run.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels