Monday, May 12, 2014

The user data source credentials do not meet the requirements to run this report or shared dataset

Recently I had an issue with creating  subscription for one of my custom report. I have always received “The create Subscription Wizard completed with errors message” and the actual error message reads as below;
Save Subscription
 Error: Save subscription to server
Errors
System.Web.Services.Protocols.SoapException: 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. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateSubscription(String Report, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters, String& SubscriptionID) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateSubscription(String Report, ExtensionSettings ExtensionSettings, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& SubscriptionID)
The error message indicates about the data source and supplied credentials. I have tried various credentials and numerous settings but still no go.

So eventually I have resolved the issue by assigning the user account for the report on the report server by going to the report manager URL.
Here it is how I did;
1.       Access the report server using the web URL (\\Reportserver\Reports)
2.       Choose your report, Right click on the report, click on Manage
3.       On the report Properties, Click on Datasources

4.       By default custom data source will be selected (If you have created the report using a custom data source).
Under Connect using: select Credentials stored securely in the report server then enter Username and password and select Use as Windows credentials when connecting to the data source.
5.       Run Test Connection. If you have configured step 4 correctly, you should get Connection created successfully.
6.       Click Apply to save the settings.

Now go back to the report subscription then create a new subscription. It should complete without any error.

6 comments:

  1. thanks really helped

    ReplyDelete
  2. Man, you are a legend.
    Our previous consultant created a custom report, now I cannot create subscription to it.
    Your post worked for me.

    Thanks heaps.

    ReplyDelete
  3. Thank you, this saved my day!

    ReplyDelete