Issue reported: While executing any of the SSRS Report getting below error message.

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source
‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’. (rsErrorI
Log on failed. (rsLogonFailed)

1

Solution

Note: Reporting point was on remote SQL

Step 1: Validate existing source path is accessible how we will validate.  open report builder in this data source properties  click on test connections. By validate found there was issue on data source not accessible.

Step 2: Validate status message on reporting service componet found below error The SQL Reporting Services datasource on Reporting point server “” is missing or has been changed outside of Configuration Manager. It will be rebuilt based on the RSP configuration.

Step 3: By seeing above error validate remote server found SMS directory was missing hence report is not accessible.

Step 4: Remove role in sccm  and Rename report SMS_SSRS folder on remote sql server.
Note: If you have any custom report make sure take backup before remove roles

Step 5: Reconfigure reporting point role and it work as normal.

Happy Learning!!!!

Thanks & Regards,
Haresh Hirani
Email: hiraniconfigmgr@outlook.com
Follow me: Twitter @hirravi1
linkedin: https://www.linkedin.com/in/hiraniconfigmgr

Advertisements