SQL 2k8报告服务通过DMZ进行身份验证

时间:2022-08-24 08:23:34

I have SQL 2k8 server and reporting services installed on a server inside a domain. I also have a webserver that is outside the domain. I'm trying to run a reporting services report from the webserver (either through a URL or the report viewer component).

我在域内的服务器上安装了SQL 2k8服务器和报告服务。我还有一个域外的网络服务器。我正在尝试从网络服务器运行报告服务报告(通过URL或报告查看器组件)。

I have managed to authenticate (as detailed in this post ), and now the report kind of runs; the reporting service website loads with the 'run report' button and the parameters bar etc, however the report itself doesn't show, and all the images associated with the report web-page (e.g. arrows for 'next' and 'back' and things) don't load. I'm guessing this is because everything points to resources inside the domain, which are unavailable from outside?

我已经设法进行身份验证(详见本文),现在报告类型的运行;报告服务网站加载“运行报告”按钮和参数栏等,但报告本身不显示,以及与报告网页相关的所有图像(例如“下一个”和“后退”的箭头和事情)不加载。我猜这是因为所有内容都指向域内的资源,这些资源是从外部无法获得的?

To summarise, my question can be stated: how do I run a SQL reporting services report hosted on a machine in a domain, from outside the domain?

总而言之,我的问题可以说明:如何在域外运行托管在域中的计算机上的SQL报告服务报告?

1 个解决方案

#1


Well, this certainly is possible. So something must be not quite right.

嗯,这当然是可能的。所以有些东西一定不太对劲。

If you access the ReportServer.aspx page directly, and supply arguments in the form of a get-request, then you'll get a very spartan looking appearance. Could you clarify the circumstance when you're seeing this barren report? Is it when you use a direct-url, or through the report viewer?

如果您直接访问ReportServer.aspx页面,并以get-request的形式提供参数,那么您将获得非常简洁的外观。当你看到这份贫瘠的报道时,你能澄清一下情况吗?是在使用直接网址还是通过报告查看器时?

#1


Well, this certainly is possible. So something must be not quite right.

嗯,这当然是可能的。所以有些东西一定不太对劲。

If you access the ReportServer.aspx page directly, and supply arguments in the form of a get-request, then you'll get a very spartan looking appearance. Could you clarify the circumstance when you're seeing this barren report? Is it when you use a direct-url, or through the report viewer?

如果您直接访问ReportServer.aspx页面,并以get-request的形式提供参数,那么您将获得非常简洁的外观。当你看到这份贫瘠的报道时,你能澄清一下情况吗?是在使用直接网址还是通过报告查看器时?