Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

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

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

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


Labels (1)
Tags (2)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎11-03-2014
Views:
3889