error while running the ssrs subscription

Question

library!WindowsService_3!1e50!07/29/2024-00:05:27:: e ERROR: Error processing data driven subscription 402299b2-b643-43ca-97f5-b6601e666103:

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.

Answer 1

The error message you're encountering indicates an issue with the data source credentials for a report or shared dataset in SQL Server Reporting Services (SSRS). Here are steps to troubleshoot and resolve this issue:

1. Check Data Source Credentials:
   • Ensure that the data source credentials are stored in the report server database.
   • Go to the report server, navigate to the data source, and verify that the credentials are correctly set up.
2. Unattended Execution Account:
   • If the data source is configured not to require credentials, make sure that the unattended execution account is specified.
   • To configure the unattended execution account:
     • Open SQL Server Reporting Services Configuration Manager.
     • Go to the "Execution Account" section.
     • Specify the credentials for the unattended execution account.
3. Shared Data Sources:
   • If using shared data sources, ensure that the shared data source is correctly configured with valid credentials.
   • Navigate to the shared data source in the Report Manager and verify the connection settings.
4. Subscription Settings:
   • Verify the settings of the data-driven subscription to ensure that it is correctly configured to use the appropriate data source credentials.
   • Ensure that the subscription has the necessary permissions to access the data source.
5. Report Server Configuration:
   • Check the report server configuration files (rsreportserver.config) for any incorrect settings related to data sources and credentials.
6. Error Logs:
   • Review the SSRS error logs for additional details about the error. The logs are usually located in the \LogFiles directory under the SSRS installation directory.

Steps to Verify and Update Data Source Credentials:

1. Navigate to Data Sources:
   • Open SQL Server Reporting Services (SSRS) web portal.
   • Go to the "Data Sources" folder.
2. Edit Data Source:
   • Click on the specific data source that the report is using.
   • Select "Manage" from the drop-down menu.
3. Verify Credentials:
   • Go to the "Credentials" tab.
   • Ensure that the "Credentials stored securely in the report server" option is selected.
   • Enter valid credentials that have access to the data source.
4. Save Changes:
   • Save the changes and test the data source connection to ensure it is successful.

Configuring Unattended Execution Account:

1. Open SSRS Configuration Manager:
   • Open SQL Server Reporting Services Configuration Manager on the server.
2. Go to Execution Account:
   • Select the "Execution Account" tab.
3. Set Up Account:
   • Enter a valid Windows account that has permissions to access the necessary data sources.
   • Apply the changes.

By following these steps, you should be able to resolve the InvalidDataSourceCredentialSettingException and ensure that your data-driven subscription can run successfully. If you encounter further issues, please provide more details about the configuration and the steps you've already taken.

Answer 2

Hi @sarma,

You can set the Credential and Connection Information such that a report is run impersonating the unattended user account.

This article explains how to set up this type of report running.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.