Recently, i was working on a deployment where we need to configure SQL Server Reporting Services 2016 with ARR so that reporting services is exposed over the internet without exposing the machine itself. If you are looking for such implementations, then this guide is for you. Please do note that I’ve tested this against Reporting Services 2016. But this should be fairly the same for prior versions or Reporting Services 2017 as well.

1. Make sure that you’ve installed the ARR module on the machine which is hosting IIS.
2. Open the INETMGR and click on the Server name.
3. In the right hand side, you should see Application Request Routing. Double click to open it.
   
4. Under Actions tab in the right hand side, click on “Server Proxy Settings…”
5. Click on Enable proxy and close the INETMGR.
   
6. Open the “applicationHost.config” located under “C:WindowsSystem32inetsrvconfig”
7. Make sure you keep a back up of the file.
8. Search for the element within the file. That should be located underneath “” element.
9. Replace the element with the following:
   

   https://xxxxxxxxxxxx/{R:0}” /> http://xxxxxxxxxxxxx/{R:0}” /> xxxxxxxxxxxxx /(.*)” /> xxxxxxxxxxxxx /{R:2}” />

10. Do ensure that the hostname values are changed to the appropriate server URL that hosts Reporting services under the Global rules as shown below:

    https://SSRS Server name from URL /{R:0}” />

    http://SSRS Server name from URL /{R:0}” />

11. . Under the Outbound rules, replace the pattern with the Report server URL name and the rewrite action with the ARR server URL name as shown below:

    pattern=”(.*)// SSRS Server name from URL /(.*)”

    ARR Server URL name/{R:2}” />

12. Restart IIS using the command IISRESET.

Do note that this rule is written for both HTTP as well as HTTPS. So, if you use either one of them, it should continue to work. The authentication that we enabled for ARR server was Anonymous and for Reporting Services we used Basic authentication (RSWindowsBasic).

Hope this helps!

Selva.

[All posts are AS-IS with no warranty and support]