用户数据源凭据不符合运行此报表的要求或运行报表时共享数据集错误 [英] The user data source credentials do not meet the requirements to run this report or shared dataset error when running reports

问题描述

我在尝试运行报告时收到以下错误:

I get the following error when trying to run reports:

无法完成当前操作.用户数据源凭据不符合运行此报表或共享数据集的要求.用户数据源凭据未存储在报表服务器数据库中，或者用户数据源配置为不需要凭据但未指定无人参与执行帐户.(rsInvalidDataSourceCredentialSetting)

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)

顺便说一下，我从 VS2010 和 SQL Server 2008 Reporting Services 运行它.

By the way I am running it from VS2010 with SQL Server 2008 Reporting Services.

我该如何解决这个问题?

How do I solve this issue?

推荐答案

是的，我已经看过了.您可以设置凭据和连接信息，以便模拟运行报告无人值守的用户帐户.本文解释了如何设置这种类型的报表运行.如果您想在动态连接字符串中使用凭据(例如，当您需要通过参数插入凭据时)，此设置特别有用.

Yes, I've seen this. 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. This setup is especially useful if you want to use the credentials inside a dynamic connection string (for example when you need to insert the credentials through a parameter).

如果您不想使用无人参与的用户帐户运行，则应查看报告中定义的数据源和连接字符串.也许可以使用数据源的设置和不同配置来创建不同的设置.上面的链接应该是一些文档的开始.

If you don't want to run using the unattended user account, you should review your DataSource and connection string as defined in the report. Perhaps play around with the settings and different configurations for the datasource to create a different setup. The above links should be a start for some documentation.

这篇关于用户数据源凭据不符合运行此报表的要求或运行报表时共享数据集错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！