Deploy SSRS 2016 for Internet Access

Question

Scenario

SSRS 2016 installed and is accessible on the intranet but now the requirement have changed for people to access some of the reports that have been developed via the internet.

How would you enable this functionality?

Answer 1

Hi Gadney,

According to your description, you want to make customers view your deployed reports via internet. Right?

In your scenario, you can use Web Portal to view reports over an internet connection. You can refer to following steps to configure to the connection.

1. Install Reporting Services on an Internet-facing Web server using the files-only installation mode. In SQL Server Installation Wizard, this is the Install but do not configure option.
2. Create and deploy a custom security extension to support forms authentication or a single-sign on technology.
3. Configure Report Manager for minimal permissions. The Browser role and System User role are sufficient for viewing reports.
4. To point Web Portal to a different report server instance that runs on a separate computer, you must configure the Web Portal URL and then modify the <ReportServerVirtualDirectory> and <ReportServerUrl> settings in the RSReportServer.config file to point Web Portal to the report server instance.
5. On the report server that you are connecting to, turn off features that you will not use. Examples might include My Reports, subscription and delivery, Report Builder, and client-side printing.

Please be noticed that if you are using Web Portal as a front-end application for Internet deployment and the report server is also installed on the same computer, you must specify a Web.config setting that allows Web Portal to bypass the proxy server when sending requests to a local report server that is installed on the same computer.

Reference: https://technet.microsoft.com/en-us/library/ms159272(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/cc281383.aspx

If you still have any questions, please feel free to ask.
Thanks,
Xi Jin.

Answer 2

Hi Xi Jin,

I have the similiar case like the the first questioner already asked. I dont understand of your first answer. Can you give official reference of that ?

SSRS 2016 consists of several features such as : paginated report, mobile report, and KPIs, which all of them is supporting responsive UI (html 5). So it make sense if we want to deploy the SSRS 2016 into internet facing.

Is there really any official reference and recomendation for internet deployment strategy specific for SSRS 2016 ? because there is such thing but only for SSRS 2008 >> https://technet.microsoft.com/en-us/library/ms159272(v=sql.105).aspx

Really appreciate for any help

regards

Octoni

Answer 3

Hey Octoni,

A while since you replied but just wondering if you ever achieved your goal?  I am in the same position as you were so just wondering if you implemented a solution that you were happy with.

Cheers,

Dave.