如何在 SSRS 中安装没有凭据的共享数据源
我正在使用 SQL Server 2005 和 Reporting Services。 我安装了许多报告，有些使用共享数据源，有些则不使用； 有些连接到 Web 服务，有些连接到 sql server 数据库，现在我正在尝试连接到 DB2 数据库。
我已经在 Visual Studio 2005 中成功创建了共享数据源和报告。我可以很好地提取数据并将其显示在设计器中的报告上。 我现在尝试通过 ssrs Web 服务安装报告和数据源（与所有其他报告的方式相同）。
问题是我们的大多数数据源都使用集成安全性，对于此数据源，我使用“不需要凭据”，因为它们列在连接字符串中。 这是我的安装代码：
Dim definition As New ServiceProxy.DataSourceDefinition
definition.ConnectString = connectionStringIncludingUsernameAndPassword
definition.Extension = "OLEDB"
definition.CredentialRetrieval = ServiceProxy.CredentialRetrievalEnum.None
ServiceWebService.CreateDataSource(dataSourceName, containingFolderFromRoot, True, definition, Nothing)
这也工作正常并且没有错误，并且似乎在 ssrs 中正确创建了数据源。 但是当我去运行报告时，我收到此错误：
当前操作无法完成 因为用户数据源 所需的凭据 执行此报告不存储在 报表服务器数据库。 （rsInvalidDataSourceCredentialSetting）
我的报表已正确连接到我的数据源，并且我的数据源已正确设置为不需要的凭据，因此它与 Visual Studio 中的完全相同。 我没主意了。
I'm using SQL Server 2005 with Reporting Services. I have many reports installed, some using shared data sources and some not; some go to web services, some to sql server databases, and now I'm trying to connect to a DB2 database.
I have successfully created a shared data source and report in Visual Studio 2005. I can pull data just fine and display it on my report in the designer. I am now trying to install the report and datasource through the ssrs web service (the same way I have for all other reports).
The problem is that most of our data sources use Integrated Security, and for this data source I am using 'Credentials are not required' since they are listed in the connection string. Here's my install code:
Dim definition As New ServiceProxy.DataSourceDefinition
definition.ConnectString = connectionStringIncludingUsernameAndPassword
definition.Extension = "OLEDB"
definition.CredentialRetrieval = ServiceProxy.CredentialRetrievalEnum.None
ServiceWebService.CreateDataSource(dataSourceName, containingFolderFromRoot, True, definition, Nothing)
This also works fine and gives no errors, and appears to create the datasource properly in ssrs. But when I go to run the report I get this 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)
My report is properly connected to my data source, and my data source is properly set to credentials not required, so it is all the same as it is inside Visual Studio. I'm out of ideas.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
问题有多个：
纠正这些问题后，报告就可以工作了！
The problem was several fold:
After correcting these problems, the report works!