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
Log on failed. (rsLogonFailed)
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.
Thanks & Regards,
Follow me: Twitter @hirravi1