Connect to SSRS 2008 on the domain from the internet

  • I have the following architecture: Web server in the DMZ, SSRS 2008 server on the domain and the SQL 2008 DB server on the domain. I have just gotten a request from a developer on how to access the SSRS server from the Web server in the DMZ. The SSRS box has an unattended execution account set up and is configure for Windows auth in the RSReportserver.config file

    <Authentication>

    <AuthenticationTypes>

    <RSWindowsNTLM/>

    </AuthenticationTypes>

    <EnableAuthPersistence>true</EnableAuthPersistence>

    </Authentication>

    How do I tell him to connect to the domain SSRS server from the DMZ/internet? I put the SSRS server on the domain, not the internet as almost all of our reports are used by domain users. Perhaps I should have put the Reporting server in the DMZ?

    Thanks for your assistance in advance!

    'nix

  • it would require some coding and can be done, all depends how you want to do it.

    what you will need is to call the reportviewer.aspx control from your dmz web server which uses impersonation of an authenticated SSRS user, to display the report.

    so click link on your web site, it calls the aspx control as DOMAIN\SSRSUser to login to SSRS and access the report, then the control renders the report in an Iframe or how ever you want to display it.

    if you want the SSRS home page available on the web, then you will need to look at a custom authentication method, or annonymous authentication.

    that way you can just go to http://www.companyname.com/reports for example and use custom authentication methods to login, or use annonymous to just get the webpage without loggin in.

  • Thank you Anthony,

    That was exactly what I was looking for. The developer was trying to just put the URL in the code the way you would on an intranet. I knew that wouldn't work and of course I found out about the problem yesterday and the project was due today. I just did not know how to explain it to him.

    'nix

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply