Edit URL Link to Report Server within SSRS Subscription

Question

I recently upgraded from SSRS Report Server 2008 to Power BI Report Server 2017. I have set up an alias URL link to get to the server as well.

When sending a report from the new server via an email Subscription, there is an option to send a link to the reportserver along with it. When using the new reportserver, the link does not use the reportserver alias to link to the server. It instead uses the machine name of the SSRS server itself.

Example: http://machinename/reports/reportname Instead of: http://reportserveralias.example.com/reports/reportname

I did find microsft's link that describes a URLRoot properly in the rsreportserver.config file. Here is a link to Microsoft's website that describes the file's capabilities.

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-2017

I tried editing it, but to no avail. I also tried restarting the reporting service afterward and that did not work. May anyone please help me with this?

Thanks!

Answer 1

You indeed have to configure the UrlRoot in the RSReportServer.config file, but it must not point to the Web Portal but to the Web Service. In most cases, the virtual directory is named "reportserver" (verify this in Reporting Services Configuration Manager under Webservice URL).

The configuration option in the RSReportServer.config file is found under

<Configuration>
    ...
    <Service>
        ...

and in your scenario it should look like this:

<UrlRoot>http://reportserveralias.example.com/reportserver</UrlRoot>

As an additional suggestion, bind the webservice and webportal URLs to an SSL certificate (issued for reportserveralias.example.com or *.example.com) and use https instead.