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