SQL 2k8 reporting services authentication through DMZ

authenticationreporting-servicessql server

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

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?

Best Answer

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?

Related Solutions

Sql-server – Add alternating row color to SQL Server Reporting services report

Go to the table row's BackgroundColor property and choose "Expression..."

Use this expression:

= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

This trick can be applied to many areas of the report.

And in .NET 3.5+ You could use:

= If(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

Not looking for rep--I just researched this question myself and thought I'd share.

Php – Calling SQL Server Reporting Services from PHP – authentication problem

I have a similar situation, which for now I just take care of by distributing the second, reporting services password, to people who need it. In my case my web app authenticates against our Novell LDAP data, but there does not seem to be a way to pass that to the reporting services box. I have not got around to it yet, but my thinking was to create a guid or random string on clicking a report generating button, storing that in a table, adding that to the report request (querystring or post), and then putting a conditional in the sproc driving the report so that if the the string doesn't exist in the table, no data is returned. The strings can be deleted periodically. Kind of rube goldberg, but maybe easier than the executable wrap you mention and its the best I could think of short of trying to build my own ldap provider for reporting services, in which case the person would still have to do a second login.

Best Answer

Related Solutions

Sql-server – Add alternating row color to SQL Server Reporting services report

Php – Calling SQL Server Reporting Services from PHP – authentication problem

Related Topic