Go How SQL Server 2008 Configures Report Manager

This article transferred from: Https://docs.microsoft.com/zh-cn/previous-versions/sql/sql-server-2008/cc281384%28v%3dsql.100%29

How to configure Report Manager

Report Manager is a WEB front-end application that is used to view reports, manage Report server content, and grant users access to native mode report servers. If you select the install as default native mode configuration option in Setup, you can install Report Manager together with the report Server Web service in the same report server instance and configure it selectively. You can also configure Report Manager after the installation is complete. This topic provides information about the following Report Manager configuration scenarios:

• To configure Report Manager to use the default URL

  Report Manager is a Web application that users access in a Web browser. You must therefore at least define the URL that is used to open the application in a browser window. The URL consists of a host name, a port, and a virtual directory. The default value for this URL includes the host name and port value defined for the report Server Web service URL, plus the reports virtual directory name. If there is a named instance, the virtual directory is a report instance, where the instance is the name of the Reporting Services instance.

• To configure Report Manager to use a specific report server URL

  By default, Report Manager connects to the report server Web service that is running in the same Report Server service. Report Manager connects using the report Server Web service URL. If more than one URL is defined for the report Server Web service, Report Manager uses the last URL that is defined. However, for some deployments, you may want Report Manager to always connect to the WEB service through a static URL. One scenario is that you configure packet filtering on a specific port or IP address, and you want all connections to the report server to pass through the filtering rules that you define.

• To point Report Manager to a remote report server

  By default, Report Manager provides front-end access to the report Server Web service running in the same server instance, but if you want to run Web services and Report Manager in different processes, or configure different server access for each server (for example, if you are using an Extranet or An Internet connection deploys Report Manager to a user and you want to deploy a firewall between the report server and Report Manager, you can configure Report Manager to connect to the Remote report Server WEB service.

• Custom styles and application titles

  You can customize Report Manager, HTML Report Viewer, and the report toolbar by changing the style in a limited way and editing the application title that appears in Report Manager.

• Close Report Manager

  When you install an Reporting Services instance that uses native mode, Report Manager is enabled by default. However, you can close Report Manager if you have a custom front-end application that provides equivalent functionality, if you only want to access the report server by using a SOAP or URL provider, or if you are using Report Manager from another report server instance.

Prerequisite

To use Report Manager, the following prerequisites must be met:

• You must have a minimally configured report server. For more information about minimal configuration of the reporting server, see How to configure a report server.

• The report server must be running in native mode. Report Manager cannot be used when the report server is configured for SharePoint Integrated mode. For more information about determining or switching the report server mode, see how to switch Server mode (Reporting Services configuration).

• You must also have Internet Explorer version 6.0 or later that has scripting enabled. For more information, see Browser support plan.

To configure Report Manager to use the default URL

By default, the Report Manager URL consists of a unique virtual directory name and a port and host name that is defined for the report Server Web service running in the same instance. In most cases, the hostname is the network name of the report server computer, but it can also be the IP address or host header that resolves the computer. To configure Report Manager to use the default URL, use the * * Report Manager URL * * page in the Reporting Services Configuration tool.

Configure default Report Manager URLs and virtual directories

1. Start the Reporting Services Configuration tool and connect to the report server instance.

2. In the Reporting Services Configuration tool, click * * Report Manager URL * to open the page that configures the URL.

3. Enter a unique virtual directory name for Report Manager.

4. Click * * "Apply" * *.

5. If you are using Windows Vista or Windows Server 2008, you may also need to perform additional steps to use Report Manager. For more information, see How to configure a report server for local administration on Windows Vista and Windows Server 2008.

To configure Report Manager to use a specific report server URL

When you configure a URL in the Reporting Services Configuration tool, Report Manager automatically detects and uses any new or updated URLs for the report server running in the same server instance. If your deployment requires a single static URL for all report server requests, you can specify that URL in the RSReportServer.config file.

To configure a static report server URL

1. Open the RSReportServer.config file in a text editor. By default, the file is located under \program Files\Microsoft SQL server\msrs10.< Instance name >\reporting Services\ReportServer.

2. Find ReportServerUrl.

3. Replace it with the URL of the corresponding report server instance.

4. Save your changes, and close the file.

For more information about this configuration file, see How to modify the Reporting Services configuration file and the RSReportServer configuration file.

To configure Report Manager to use a remote report server

For deployment configurations that place Report Manager and report server on different computers, there must be two separate Reporting Services installations. Report Manager is embedded in the Report Server service and cannot be installed on its own. If you want Report Manager to run in its own process on another computer, you must install a second report server. Both of these server instances must be SQL Server 2008 report servers.

To connect Report Manager to a remote report server instance

2. Installs two report server instances.

4. Configure the first installation that hosts a report server:

   1. Start the Reporting Services Configuration tool.

   2. Click * * WEB Service URL * * To configure the host name, port, and virtual directory for the report server.

   3. CLICK * * Database * * To configure the report server database.

6. To configure a second installation that hosts Report Manager:

   1. Start the Reporting Services Configuration tool.

   2. Click * * Report Manager URL * * To enter the virtual directory name for Report Manager.

   Do not configure the database. Do not test URLs.

8. On the Report Manager computer, modify the configuration settings in RSReportServer.config to point to the remote report server instance. At startup, Report Manager reads the configuration file to get the URL to the report server:

   1. Open RSReportServer.config in a text editor. By default, the file is located under \program Files\Microsoft SQL server\msrs10.< Instance name >\reporting Services\ReportServer.

   2. Find ReportServerUrl.

   3. Replace it with the URL of the remote report server instance.

   4. Save your changes, and close the file.

10. If necessary, enable port 80 on both computers to allow requests through that port. For more information, see How to configure a firewall to allow Report server access.

12. Restart the report server.

14. In the browser window, open Report Manager. If it is already open, refresh your browser to verify that Report Manager is connected to the remote server. You should see the contents of the target server.

16. To turn off unused server features:

    • On the Report Manager computer, close webserviceandhttpaccessenabled and scheduleeventsandreportdeliveryenabled.

    • On the report server computer, close reportmanagerenabled.

For more information about the shutdown feature, see How to turn Reporting Services on or off.

Custom style or application title

Microsoft does not support custom Report Manager style sheets. However, if you have the expertise of WEB development, you can modify the style, but you have to take the risk yourself. For more information about which files contain style information, see Customizing the HTML Viewer and Report Manager style sheets.

Report Manager has an application title that appears at the top of the page. By default, the title is SQL Server Reporting Services. You can customize this title. To change this heading, you can use the Site Settings page in Report Manager. To modify application settings in Report Manager, you must have the system Administrator role assigned to set properties on the Site Settings page. To view the application title, the user must be assigned the system user * * role.

Modify the application title

1. Log on with an account that is assigned a report server * * System administrator * * rights.

2. Open Internet Explorer.

3. Enter the Report Manager URL. By default, the URL is http://< server name >/reports, but if Reporting Services is installed as a named instance, the default URL will be the http://< server name >/reports<_ Instance name >.

4. Click * * Site Settings * *.

5. On the General tab, in name, replace SQL Server Reporting Services with a different name.

6. Click * * "Apply" * *.

Close Report Manager

You can close Report Manager if you have a custom application that provides equivalent functionality, or a Report Manager application that is using another service instance. To close Report Manager, you can modify the RSReportServer.config file.

Close Report Manager

1. Open the RSReportServer.config file in a text editor. By default, the file is located under \program Files\Microsoft SQL server\msrs10.< Instance name >\reporting Services\ReportServer.

2. Find isreportmanagerenabled.

3. Set its value to False.

4. Save your changes, and close the file.

For more information about how to modify the configuration file, see How to modify the Reporting Services configuration file. For more information about disabling features in Reporting services, see How to turn the Reporting Services feature on or off.

Please see

Task

How to configure URLs (Reporting Services configuration)

How to verify Reporting Services installation

How to turn the Reporting Services feature on or off

How to configure a report server for local administration on Windows Vista and Windows Server 2008

Concept

Report Manager

Browser support Plan

Customizing the HTML Viewer and Report Manager style sheets

Reporting Services Configuration How-to Topics

RSReportServer configuration file

Go How SQL Server 2008 Configures Report Manager