Forum Discussion

Cdee's avatar
Cdee
Level 6
11 years ago

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

  • Changed teh SQL settings from unattended to the service account and Uploaded the report templates and its working fine now.

    cheers!!!