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 :-)


Comments (2):

Leave a Reply