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)

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: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr