Return
-
Title
Report generates, but job fails with error: The user data source credentials do not meet the requirements to run this report -
Description
When a Report Job completes, the following error is recorded in "InTrust Manager | Workflow | Sessions" but the report is emailed and contains the correct data:
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. 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.
-
Cause
This error pertains to an issue when generating the Reporting Server snap-shot of the report. Likely, the user data source is configured not to require credentials but the unattended execution account is not specified.
-
Resolution
WORKAROUND
Disable the "Create the Reporting Server snap-shot" check box on the "Delivery" tab of a InTrust reporting job.RESOLUTION
Set the unattended execution account in SQL Server Reporting Services (SSRS) as per the following Microsoft article: