App Control: How Do We Assign the Required Permissions to Our App Control Server Service Account in SQL?

[#1]

Environment

• App Control Server: All Versions
• Microsoft SQL Server: All Supported Versions

Objective

To assign the required permissions to the App Control server service account in SQL.

Resolution

• To assign the sysadmin server role to the App Control server service user follow the steps below:
  1. Login to SQL Management Studio
  2. Expand the Security folder
  3. Expand Logins
  4. Right click the App Control Server service account user
  5. Select properties
  6. Select Server Roles
  7. Check sysadmin
• To set the required securables replace "App Control User Account" with your server account username, and follow the steps below:
  1. Open SQL Management Studio
  2. Click New Query
  3. Set the database dropdown to das
  4. Run the following scripts:
     • GRANT ALTER TRACE TO "App Control service account"
     • GRANT VIEW ANY DEFINITION TO "App Control service account"
     • GRANT VIEW SERVER STATE TO "App Control service account"
     • GRANT ALTER SERVER STATE TO "App Control service account"

Related Content

App Control: What permissions are needed for the App Control Service account on the App Control serv...
App Control: How to find the service account used for the App Control Server service