Modifying the execution account after installing Configuration Manager R3

In a previous post I described how you create and configure an execution account for SQL Reporting Services and Configuration Manager R2. The execution account is a requirement for those who want to use the e-mail subscription feature.

Due to changes in security the execution account does not have the needed permission to open the new Power Management reports. Instead you will get error messages like these:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSet3’. (rsErrorExecutingCommand)
The EXECUTE permission was denied on the object ‘PowerManagementGetDayRange’, database ‘SMS_A01’, schema ‘dbo’.

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset ‘DataSet2’.
The EXECUTE permission was denied on the object ‘PowerManagementGetPowerCapabilities’, database ‘SMS_A01’, schema ‘dbo’.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSetStartDate’. (rsErrorExecutingCommand)
The EXECUTE permission was denied on the object ‘PowerManagementGetDayRange’, database ‘SMS_A01’, schema ‘dbo’.

To solve the problem you need to modify the permissions granted to the dataset execution account.

  1. Open SQL Server Management Studio
  2. Navigate to Databases, SMS_Sitecode, Security, Users
    image 
  3. Open the properties for your dataset execution account. In user mappings select ConfigMgrDashBoardReader or smsschm_users and click OK.
    image
  4. You are now able to run the Power Management reports using the dataset execution account.

    image

 

Thanks to Ulrik Jensen for teling me about the smsschm_users group 🙂

By | 2010-11-17T21:58:26+00:00 November 17th, 2010|Configuration Manager (SCCM), General info|2 Comments

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

Leave A Comment