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

  • I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that allows me to click on a link to pull up another report (sub-report) passing it a server name as a parameter. The Data Source is setup to use Embedded connection with the following connection string:

    ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=msdb"

    This works with the SQL-performance-dashboard-reports. The credentials is setup to use Windows Authentication (integrated security). The only parameter I am passing is the Servername. I can't get it to work with other reports.

    I followed the instruction in the two links below:

    https://github.com/Microsoft/tigertoolbox/tree/master/SQL-performance-dashboard-reports

    https://learn.microsoft.com/en-us/archive/blogs/sql_server_team/sql-server-performance-dashboard-reports-unleashed-for-enterprise-monitoring

    When I click on a link to open another report, I get the error message below. How do I correct this?

    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. (rsInvalidDataSourceCredentialSetting)

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply