Error Message

An error occurred creating the report 
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.
An error has occurred during report processing ---> ...
Cannot impersonate user for data source 'CustomerDatabase'. --->
Logon failed. ---> Logon failure: unknown user name or bad password.
(Exception from HRESULT: 0x8007052E)

The error is caused by specifying incorrect credentials when uploading the Report Templates to the SQL Server Reporting Services (SSRS) server in the EVBAAdmin website. The Accelerator Manager website does not authenticate the logon credentials that are provided during Report Template uploads. Consequently, account validation issues occur when generating reports.

Upload the Report Templates again via the EVBAAdmin website using the correct credentials.

1. Open the Accelerator Manager website.

2. Click Reporting Server at the bottom of the page. The Uploading Reporting Server Templates page appears.

The screenshot above was taken from a non-production test lab environment and is used for example purposes only.

3. In the Reporting Server URL field, type the URL for the SSRS server in the following form:

http://server_name/reportserver_virtual_directory

Where server_name is the host name, fully qualified domain name, or IPv4 or IPv6 address of the SQL reporting server, and reportserver_virtual_directory is the name of the SSRS ReportServer URL. For example:

http://EVSQL/ReportServer

If there are multiple SQL Server instances, type the URL in the following form:

http://server_name/virtual_directory$instance_name

If SSRS has been configured to listen for HTTP requests on a port other than the default, 80, type the URL in the following form:

http://server_name:port_number/virtual_directory

4. In the User Name field and Password field, type the credentials for the Vault Service Account (VSA). This identifies the VSA as the delegate for all Reports created by users, as the VSA has the applicable prerequisite permissions to create Reports.

5. Click Upload Reports. It can take several minutes to upload the report templates to the server. A confirmation message appears when the process has completed.