How to: Turn Reporting Services Features On or Off

SQL Server Setup

previous page next page

You can turn off report server features that you do not use as part of a lockdown strategy for reducing the attack surface of a production report server. In most cases, you will want to run Reporting Services features concurrently to use all of the functionality provided in Reporting Services. However, depending on your deployment model, you can disable the features that you do not require. For example, you can enable only the background processing if all report processing is configured as scheduled operations. Similarly, you can run just the Report Server Web service if you only want interactive, on-demand reporting.

The procedures in this topic show you how to turn off Reporting Services features. Features can be configured in different ways, such as by editing the RsReportServer.config file directly or by using the Surface Area Configuration for Reporting Services facet of Policy-Based Management in SQL Server Management Studio. Use the links to locate the procedure or procedures that explain how to turn a feature on or off:

Report Server Web Service

To turn on or off the Report Server Web service by editing configuration

Open the RsReportServer.config file in a text editor. For more information, see How to: Modify a Reporting Services Configuration File.

  • To turn on the Report Server Web service, set IsWebServiceEnabled to true:

    Copy Code
    <IsWebServiceEnabled>true</IsWebServiceEnabled>

  • To turn off the Report Server Web service, set IsWebServiceEnabled to false:

    Copy Code
    <IsWebServiceEnabled>false</IsWebServiceEnabled>

  • Save your changes and then close the file.

    • To turn on or off the Report Server Web service by using SQL Server Management Studio

    1. Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.

    2. In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.

    3. In the Facet list, select Surface Area Configuration for Reporting Services.

    4. Under Facet Properties:

      • To turn on the Report Server Web service, set WebServiceAndHTTPAccessEnabled to True.
      • To turn off the Report Server Web service, set WebServiceAndHTTPAccessEnabled to False.

    5. Click OK.

    Scheduled Events and Delivery

    To turn on or off scheduled events and delivery by editing configuration

    Open the RsReportServer.config file in a text editor. For more information, see How to: Modify a Reporting Services Configuration File.

  • To turn on scheduled report processing and delivery, set IsSchedulingService, IsNotificationService, and IsEventService to true:

    Copy Code
    <IsSchedulingService>true<\IsSchedulingService>
<IsNotificationService>true<\IsNotificationService>
<IsEventService>true<\IsEventService>

  • To turn off scheduled report processing and delivery, set IsSchedulingService, IsNotificationService, and IsEventService to false:

    Copy Code
    <IsSchedulingService>false<\IsSchedulingService>
<IsNotificationService>false<\IsNotificationService>
<IsEventService>false<\IsEventService>

  • Save your changes and then close the file.

    • Note:
    You cannot turn off background processing completely because it provides database maintenance functionality that is required for server operations.

    To turn on or off scheduled events and delivery by using SQL Server Management Studio

    1. Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.

    2. In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.

    3. In the Facet list, select Surface Area Configuration for Reporting Services.

    4. Under Facet Properties:

      • To turn on scheduled events and delivery, set ScheduleEventsAndReportDeliveryEnabled to True.
      • To turn off scheduled events and delivery, set ScheduleEventsAndReportDeliveryEnabled to False.

    5. Click OK.

    Note:
    You cannot turn off background processing completely because it provides database maintenance functionality that is required for server operations.

    Report Manager

    To turn on or off Report Manager by editing configuration

    Open the RsReportServer.config file in a text editor. For instructions, see How to: Modify a Reporting Services Configuration File.

  • To turn on Report Manager, set IsReportManagerEnabled to true:

    Copy Code
    <IsReportManagerEnabled>true<\IsReportManagerEnabled>

  • To turn off Report Manager, set IsReportManagerEnabled to false:

    Copy Code
    <IsReportManagerEnabled>false<\IsReportManagerEnabled>

  • Save your changes and then close the file.

    • To turn on or off Report Manager by using SQL Server Management Studio

    1. Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.

    2. In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.

    3. In the Facet list, select Surface Area Configuration for Reporting Services.

    4. Under Facet Properties:

      • To turn on Report Manager, set ReportManagerEnabled to True.
      • To turn off Report Manager, set ReportManagerEnabled to False.

    5. Click OK.

    Report Builder

    To turn on or off Report Builder by using SQL Server Management Studio

    Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.

  • In Object Explorer, right-click the Reporting Services node, and click Properties.

  • In the Server Properties dialog box, under Select a page, click Security.

    • To turn on Report Builder, select the Enable ad hoc report executions option.
    • To turn off Report Builder, unselect the Enable ad hoc report executions option.

  • Click OK.

    • Windows Integrated Security

    To turn on or off Windows Integrated security by using SQL Server Management Studio

    Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.

  • In Object Explorer, right-click the Reporting Services node, and click Properties.

  • In the Server Properties dialog box, under Select a page, click Security.

    • To turn on Windows Integrated security, select the Enable Windows Integrated security for report data sources option.
    • To turn off Windows integrated security, unselect the Enable Windows Integrated security for report data sources option.

  • Click OK.

    • See Also

    Tasks

    How to: Start Reporting Services Configuration

    Other Resources

    RSReportServer Configuration File
    Component Architecture
    Reporting Services Components and Tools
    Service Architecture (Reporting Services)
    Introducing SQL Server Management Studio
    Administering Servers by Using Policy-Based Management

    previous page start next page