SQL Server Setup Help | |
URLs in Configuration Files (Reporting Services) | |
See Also |
Configuring SQL Server 2008 > Configuring Reporting Services > Configuring Report Server URLs > |
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.
-
To view descriptions of each element in the URLReservations section, see RSReportServer Configuration File.
-
For more information about the syntax of just the UrlString element, see URL Reservation Syntax (Reporting Services).
-
For instructions on how to configure URLs for application access, see How to: Configure a URL (Reporting Services Configuration).
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:
For instructions on how to implement these scenarios, see How to: Configure Report Manager. |
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:
|
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. |
See Also
Tasks
How to: Configure a URL (Reporting Services Configuration)Concepts
Configuring Report Server URLsOther Resources
RSReportServer Configuration FileHow to: Modify a Reporting Services Configuration File
Viewing Reports with SharePoint 2.0 Web Parts