cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error while running reports in compliance accelerator

Cdee
Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

After you moved SQL did you reload the reports for CA?

View solution in original post

2 REPLIES 2

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

After you moved SQL did you reload the reports for CA?

Cdee
Level 6

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

cheers!!!