Binaryworld - How to access Reporting Services over internet using Fully Qualified D ... [ SQL Server -> Reporting Service ]

After you install reporting services by default report server will be configured to use http://machinename/reportserver virtual server. This will be fine if you want to use Reporting Services with in your intranet but if you want to access it using IP or fully qulified domain name over internet then you have to make some changes to default configuration.

Deploying a Report Server for Internet Access

Settings in the rswebapplication.config file provide values that are used to direct requests from Report Manager to a report server. By default, the configuration file includes ReportServerUrl. Report Manager uses this value to find the report server that contains server state information and stored items. In an intranet deployment model, the Report Manager connects to a report server using a network name (for example, http://server01/reportserver).

To access a report server on the Internet, you must add a ReportServerExternalUrl configuration setting that specifies the fully qualified domain name of the report server. The external client uses this value to access a report server. In this scenario, the browser that is hosting Report Manager must send a fully qualified domain name when making requests on behalf of Report Manager to the report server.

The following example illustrates the syntax for ReportServerExternalUrl:

Note: If you have installed RS at default path then RSWebApplication.config can be found under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager

<UI>
    <ReportServerUrl>http://server01/ReportServer</ReportServerUrl>
    <ReportServerExternalUrl>http://server01.mycompany.com/ReportServer</ReportServerExternalUrl>
</UI>