Granting SQL Server permissions - Security Center 5.7 GA

Security Center Installation and Upgrade Guide 5.7 GA

series
Security Center 5.7 GA
revised_modified
2017-10-25

For the Directory role to run, service users who are not Windows administrators (login name SYSADMIN) must be granted the View server state SQL permission.

What you should know

The minimum SQL server-level role supported by Security Center is dbcreator, and the mimimum SQL database-level role is db_owner. Therefore, you must make sure that members of the dbcreator server role and members of the db_owner database role have the View server state permission granted.

For more information about server roles and their capabilities, see your Microsoft documentation.

NOTE: The following procedure is for SQL Server 2014 Express. If you are using a different version of SQL Server, see your Microsoft documentation for information about granting permissions.

Procedure

To grant SQL Server permissions:

In SQL Server Management Studio, do one of the following:
  • Execute the following query: GRANT VIEW SERVER STATE TO [login name].
  • Manually modify the user permissions as follows:
    1. Right-click on the appropriate SQL server instance and select Properties.
    2. Click the Permissions page.
    3. Under Logins or roles, select the user or role you want to modify.
    4. In the Permissions section, click the Explicit tab and select the Grant check box beside the View server state permission.
    5. Click OK.

After you finish

For users that are granted the permission locally on the Security Center server, you must add them as users on the SQL Server.