A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
The error message you're encountering, Microsoft.ReportingServices.ReportProcessing.ReportProcessingException (rsProcessingError), often indicates issues related to report processing in SQL Server Reporting Services (SSRS). Since you mentioned that this started after changing the Configuration Manager SSRS service account password, it’s possible that the service account is not properly configured or that there are issues with the encryption keys or URL reservations.
Here are some steps you can take to troubleshoot and resolve the issue:
- Update the Service Account Password: Ensure that the password for the SSRS service account is updated in the Reporting Services Configuration Manager. If the password has expired and is not updated, the service may fail to start, leading to processing errors.
- Check Encryption Keys: If the service account change has corrupted the encryption keys, you may need to restore the encryption keys manually. You can do this using the Restore option in the Encryption Keys page of the Reporting Services Configuration Manager. If restoring the keys does not work, you might need to delete the encrypted content and recreate data source connection information and subscriptions.
- Recreate URL Reservations: After changing the service account, URL reservation errors can occur. You may need to recreate the URL reservations to ensure that the new account has the correct permissions. Restarting the computer may help if you're having trouble recreating the URL reservations.
- Check Report Compatibility: Ensure that all reports, including subreports, are compatible with the current version of the report processor. If there are mismatches in versions, it could lead to processing errors.
- Review Logs for More Details: Check the SSRS log files for more detailed error messages. The log files are typically located in the Reporting Services LogFiles directory. Look for entries related to
ReportProcessingExceptionfor additional context on the error.
By following these steps, you should be able to identify and resolve the issues causing the report processing error in SSRS.
References: