Page tree

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:

  1. Start services.msc using the Run command. The system displays the Services window.
  2. Right-click the SQLcompliance Collection Service, and then select Properties.
  3. In the SQLcompliance Collection Service Properties dialog box, click the Log On tab.
  4. Log on to the SQL CM Service by typing the service account credentials, and then clicking OK.
  5. Open the registry editor by typing regedit in the Run command window, and then clicking OK. The system displays the Registry Editor window.
  6. In the directory tree, expand HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLcompliance.
  7. Right-click the SQLcompliance folder, and then select Permissions. The system displays the Permissions for SQLcompliance dialog box.
  8. On the Security tab, click Add. This step allows you to add a user or group.
  9. 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.
  10. In the Search Results field, select the service account used by SQL CM Services, and then click OK. The system adds the object to the list.
  11. Click OK. Note that the account you selected appears in the Group or user names field of the Permissions for SQLcompliance dialog box.
  12. Select the account name, and then add the appropriate permissions by checking the Allow checkbox for the permission(s).
  13. 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.

 

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