Getting error while running reports in compliance accelerator
Hi All,
I migrated my SQL server 2 weeks back all is working fine except the reporting feature in CA, when users try to run the report it fails and gives error.
The current action cannot be completed.The user data source credentials do not meet the requirements to run this report or shared dataset.Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.
SQL server is 2008 R2 and CA server version is 9.0.2
After you moved SQL did you reload the reports for CA?