Tuesday, March 27, 2012

Able to install Report Server component on non-domain web svr?

Hello all,
We are looking at installing Reporting Services at our company here. We wish
to install the Report Server component on an IIS 6 web server that is on our
DMZ network, and hence not in our domain (where the SQL Server resides that
we want to put the RS database.) While reading BOL's "Selecting Components
of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
server and the SQL Server instance hosting the report server database must
be in the same domain or trusted domain." In our case, they would not be. Is
this a deal-killer, or has someone successfully implemented this type of
architecture out there? Any comments would be greatly appreciated.
TIA,
Will DennisOne solution would be to put the Report Server almost anywhere on your
internal network, then access it via web services on your Internet-facing
server.
Look at the Report Server Control example, just modify the URL parameter.
Jeff
"Willard Dennis" <wdennis@.bayada.com> wrote in message
news:#CgzKzJWEHA.1380@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are looking at installing Reporting Services at our company here. We
wish
> to install the Report Server component on an IIS 6 web server that is on
our
> DMZ network, and hence not in our domain (where the SQL Server resides
that
> we want to put the RS database.) While reading BOL's "Selecting Components
> of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
> server and the SQL Server instance hosting the report server database must
> be in the same domain or trusted domain." In our case, they would not be.
Is
> this a deal-killer, or has someone successfully implemented this type of
> architecture out there? Any comments would be greatly appreciated.
> TIA,
> Will Dennis
>

No comments:

Post a Comment