Exposing Reporting Services Reports to the Internet

By using the ASP.NET ReportViewer control on a web page exposed to the internet, it is possible to display Reporting Services reports. The trick is in turning on Anonymous Access on the ReportServer Virtual Directory and creating the anonymous user as a Reporting Services user and granting that user permission to view the reports you want to share.

In the ReportViewer control configure the ReportView Tasks as follows:

  1. Choose Report:
  2. Report Server Url: the path to the ReportServer Virtual Directory
  3. Report Path: the path to the report beginning with ‘/’

On the web server hosting Reporting Services configure the ReportServer Virtual directory as follows:

  1. Turn on Anonymous Access
  2. Remember the Anonymous Access user

In Report Manager do the following:

  1. Configure the Anonymous Access user as a Reporting Services user
  2. Grant that user access to the necessary folders and/or reports

Deploy your web page with the ReportViewer control to your internet server and you are good to go.