IDERA SQL Compliance Manager checks the permissions available on each 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, and then access the
HKEY_LOCAL_MACHINE\Software\Idera\SQLcompliance to make the permission changes. For more information about the required permissions, see Configuration wizard - Permissions Check window.
To make a change to the registry key:
services.mscusing the Run command. The system displays the Services window.
- Right-click the SQLcompliance Collection Service, and then select Properties.
- In the SQLcompliance Collection Service Properties dialog box, click the Log On tab.
- Log on to the SQL Compliance Manager Service by typing the service account credentials, and then clicking OK.
- Open the registry editor by typing regedit in the Run command window, and then clicking OK. The system displays the Registry Editor window.
- In the directory tree, expand
- Right-click the SQLcompliance folder, and then select Permissions. The system displays the Permissions for SQLcompliance dialog box.
- On the Security tab, click Add. This step allows you to add a user or group.
- In the Select Users or Groups dialog box, search for the appropriate account by clicking Advanced>Find Now. The Select Users or Groups dialog box displays a list of relevant results.
- In the Search Results field, select the service account used by SQL Compliance Manager Services, and then click OK. The system adds the object to the list.
- Click OK. Note that the account you selected appears in the Group or user names field of the Permissions for SQLcompliance dialog box.
- Select the account name, and then add the appropriate permissions by checking the Allow checkbox for the permission(s).
- Click OK after you make your selections. You can verify the permissions by right-clicking SQLcompliance in the Registry Editor, selecting Permissions, and then viewing the allowed permissions.