Reporting Services SP1 and rsInvalidDataSourceCredentialSetting errors

  • Article

If you upgraded to RS SP1 and noticed some of your reports that used to work fail now with the following error: “The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)” here is the what to do:

 

  1. if your report’s data sources do not support authentication – for instance, an anonymous web service, an XML/CSV file, Microsoft Access data source, then use rsconfig –e –u –p to configure the unattended execution account. Make sure to use a low privilege user account. Access to the data sources will be made as that user account.
  2. if your report’s data sources support authentication – for instance Microsoft SQL Server data sources, or other RDBMS, switch to using the one of the other credentials options, as they provide better security.

 

 

Credentials stored securely in the report server

User name:

Password:

Use as Windows credentials when connecting to the data source

Impersonate the authenticated user after a connection has been made to the data source

Windows NT Integrated Security

Credentials are not required