Reporting Services XML数据源的集成安全性 [英] Integrated Security on Reporting Services XML Datasource

问题描述

我正在设置报告服务器以将Web服务用作XML数据源.我选择使用集成安全性，似乎在Web服务和报表之间存在身份验证问题.这是我所拥有的:

I am working on setting up my report server to use a web service as an XML datasource. I seem to be having authentication issues between the web service and the report with I choose to use Integrated security. Here's what I have:

1)我的网站带有公开服务.该网站配置为仅在Integrated Security上运行.这意味着在目录安全性下，我们将关闭所有其他模式，并且关闭已启用的匿名访问.

1) I have a website w/ an exposed service. This website is configured to run ONLY on Integrated Security. This means that we have all other modes turned off AND Enabled anonymous access turned off under directory security.

2)在网站的Web.config中，我将身份验证模式设置为Windows.

2) Within the Web.config of the website, I have the authentication mode set to Windows.

3)我将报表数据源设置为XML数据源.我具有该服务的正确URL，并将其设置为Windows Integrated Security.由于我要从浏览器跳到报表服务器再到Web服务，因此我想知道是否有Kerberos问题，但是我不确定.

3) I have the report datasource set to being an XML data source. I have the correct URL to the service and have it set to Windows Integrated Security. Since I am making a hop from the Browser to the Reporting Server to the Web Service, I wonder if I am having an issue w/ Kerberos, but I am not sure.

当我尝试访问该服务时，出现401错误.

When I try to access the service, I get a 401 error.

这是我正在生成的IIS日志:

Here are the IIS logs that I am generating:

2011-01-07 14:52:12 W3SVC IP_ADDY POST/URL.asmx-80-IP_ADDY-401 1 0 2011-01-07 14:52:12 W3SVC IP_ADDY POST/URL.asmx-80-IP_ADDY-401 1 5

2011-01-07 14:52:12 W3SVC IP_ADDY POST /URL.asmx - 80 - IP_ADDY - 401 1 0 2011-01-07 14:52:12 W3SVC IP_ADDY POST /URL.asmx - 80 - IP_ADDY - 401 1 5

有人以前解决过这个问题吗?谢谢！

Has anyone worked out this issue before? Thanks!

推荐答案

听起来确实遇到了双跳"问题.是否可以在您的Web服务上创建一个报表服务器显式使用的帐户，而不是通过用户凭据?

It does sound like you are experiencing the "double hop" issue. Is it possible to create an account on your web service that the reporting server uses explicitly instead of passing through the users credentials?

这篇关于Reporting Services XML数据源的集成安全性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！