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
• Perform following steps to set required securables, replace "App Control User Account" below with your service account username:
  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 Windows Permissions Are Required for the App Control Service Account
App Control: How to Find the Service Account Used for the App Control Server Service