SQL Permissions
Advanced Insights ConfigMgr SQL Permissions requirements
Applies to: Advanced and Patch Insights
If Advanced Insights is installed on your ConfigMgr site server, then you should not need to do any SQL permissions configuration.
The Advanced Insights IIS Application Pools can run as the local computer Identity, which has ConfigMgr SQL database access by default.
Alternatively, a custom ID can be used. See: IIS Application Pool Identity
Advanced Insights needs read access to the ConfigMgr SQL database. If Advanced Insights is installed on a server that is not the ConfigMgr site server, or a custom Active Directory account is used for the IIS application pools, you will need to grant some SQL permissions.
Assigning Rights to ConfigMgr SQL
Option 1 - Using the Advanced Insights Computer Account
Open SQL Management Studio and connect to the required SQL instance for your ConfigMgr database
Execute the following script replacing the domain\computername and CM_XXX database name
Option 2 - Using a user account for Advanced Insights
Advanced Insights access to the Configuration Manager SQL database can be configured to use a Active Directory user account. This account is set as the IIS application pool identity.
See: IIS Application Pool Identity
Open SQL Management Studio and connect to the required SQL instance for your ConfigMgr database
Execute the following script replacing the domain\username and CM_XXX database name
Last updated
Was this helpful?