• Article

URLs in Configuration Files (Reporting Services)

Reporting Services stores application settings in a RSReportServer.config file. Within this file, there are configuration settings for both URLs and URL reservations. These configuration settings have very different purposes and rules for modification. If you are accustomed to modifying configuration files to tune a deployment, this topic can help you understand how each URL setting is used.

URL Settings in RSReportServer.config File

Reporting Services stores URLs for application and report access, and to connect Web front-end components to a back-end report server.

URLs for Application Access

URLs are used to access the Report Server Web service and Report Manager. To configure the URLs, you must use the Reporting Services Configuration tool. The tool creates the URL reservations for each application in HTTP.SYS and adds entries for the URLs in the URLReservations section of RSReportServer.config.

URLs for Report Access

Reporting Services includes a report server e-mail delivery extension that you can use to send report links or attachments. A report link is constructed when the report is delivered. The report server e-mail delivery extension uses the UrlRoot setting in the configuration file to create the link. UrlRoot is also used to resolve links in a rendered report that is generated through unattended report processing.

UrlRoot is specified automatically in the RSReportServer.config file when you configure URLs for application access. If you modify this value in the configuration file, you must specify a valid URL address to a Report Server Web service that is connected to a report server database that contains the reports you want to deliver. You can only specify one UrlRoot for a single report server instance; only one UrlRoot entry can exist in the RSReportServer.config file for any given report server instance. If you have multiple URLs reserved for the Report Server Web service, you must choose one of the available values for UrlRoot.

In most cases, you do not need to modify UrlRoot. However, if the report server will be accessed through a fully qualified URL, and you did not configure a URL that uses a host header to the fully qualified site name, you must edit the RSReportServer.config manually to set the UrlRoot to the fully qualified report server URL that will be used to render the report (for example, https://www.adventure-works.com/mywebapp/reportserver).

URLs Connecting Report Manager and Web Parts to the Report Server Web Service

Report Manager and the SharePoint 2.0 Web Parts for Reporting Services are Web front-end components that connect to a report server. URLs used to connect to a backend report server include the following:

  • ReportServerUrl (used by Report Manager)

  • ReportServerExternalUrl (used by Web Parts)

Note

Previous versions of Reporting Services included the ReportServerVirtualDirectory element. This value is obsolete in SQL Server 2008. If you upgraded an existing installation and are using a configuration file that contains this setting, the report server no longer reads this value.

The following table provides a summary of all the URLs that can be specified in a Reporting Services configuration file.

Setting

Usage

Description

ReportServerUrl

Optional. This element is not included in the RSReportServer.config file unless you add it yourself.

Set this element only if you are configuring one of the following scenarios:

  • Report Manager provides Web front-end access to a Report Server Web service that runs on a different computer or a different instance on the same computer.

  • When you have multiple URLs to a report server and you want Report Manager to use a specific URL.

  • You have a specific report server URL through which you want all Report Manager connections to use.

    For example, you might enable Report Manager access for all computers on network, yet require that Report Manager connect to the report server through a local connection. In this case, you might configure ReportServerUrl to "https://localhost/reportserver".

For instructions on how to implement these scenarios, see How to: Configure Report Manager in SQL Server Books Online.

This value specifies a URL to the Report Server Web service. This value is read by the Report Manager application at startup. If this value is set, Report Manager will connect to the report server that is specified in the URL.

By default, Report Manager provides Web front-end access to the Report Server Web service that runs within the same report server instance as Report Manager. However, if you want to use Report Manager with a Report Server Web service that is part of another instance or runs in an instance on a different computer, you can set this URL to direct Report Manager to connect to the external Report Server Web service.

If a Secure Sockets Layer (SSL) certificate is installed on the report server to which you are connecting, the ReportServerUrl value must be the name of the server that is registered for that certificate. If you get the error, "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS security channel", set ReportServerUrl to the fully qualified domain name of the server for which the SSL certificate was issued. For example, if the certificate is registered to https://adventure-works.com.onlinesales, the report server URL would be https://adventure-works.com.onlinesales/reportserver.

ReportServerExternalUrl

Optional. This element is not included in the RSReportServer.config file unless you add it yourself.

Set this element only if you are using the SharePoint 2.0 Web Parts and you want users to be able to retrieve a report and open it in a new browser window.

Add <ReportServerExternalUrl> underneath the <ReportServerUrl> element, and then set it to a fully qualified report server name that resolves to a report server instance when accessed in a separate browser window. Do not delete <ReportServerUrl>.

The following example illustrates the syntax:

<ReportServerExternalUrl>http://myserver/reportserver</ReportServerExternalUrl>

This value is used by the SharePoint 2.0 Web Parts.

In previous releases, it was recommended that you set this value to deploy Report Builder on an Internet-facing report server. This is an untested deployment scenario. If you used this setting in the past to support Internet access to Report Builder, you should consider an alternative strategy.