This window displays the results of a check of the permissions required by 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
HKLM\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
HKLM\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
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.