Last updated
© Patch My PC 2024
Last updated
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:
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.
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
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.
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
See:
Advanced Insights ConfigMgr SQL Permissions requirements