Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

Starting and Stopping the Report Server Windows Service

You can stop the Report Server Windows service to stop many report server operations. When you stop the Report Server Windows service, the following results occur:

  • All report processing that is triggered from scheduled events (for example, subscriptions, report snapshot refreshes, and cache expiration) stops.
  • Encryption and decryption operations are suspended. These operations include initializing servers and accessing encrypted credentials and connection strings.
  • Access to the Remote Procedure Calls (RPC) endpoint used by the Reporting Services Configuration tool, rskeymgmt, and the report server Windows Management Instrumentation (WMI) provider is disabled.
  • Report server database maintenance and cleanup operations stop.

Stopping the Report Server Windows service does not affect the Web service. Web-based access to the report server and the SOAP endpoint continue to be available while the Windows service is stopped. If you want to stop the Web service, you can use Internet Information Services (IIS) Manager to stop the Web site that hosts the report server.

You can use a variety of tools to start or stop the Report Server Windows service, including the Reporting Services Configuration tool, SQL Server Configuration Manager, SQL Server Surface Area Configuration tool, and the Services tool provided in Microsoft Windows.

If you are doing more than starting or stopping the service, such as changing the service account, you must use the Reporting Services Configuration tool. Using other tools to change the service account can break your Reporting Services installation. For more information, see Configuring Service Accounts and Passwords in Reporting Services.

You cannot pause and resume the service. There are no start parameters. Although there are no explicit dependencies, SQL Server Agent must be running if you support any scheduled operations on the server.

How to Start or Stop the Windows Service Using the Reporting Services Configuration Tool
  1. Click Start, click All Programs, click Microsoft SQL Server 2005, click Configuration Tools, and then click Reporting Services Configuration.
  2. Click Connect to connect to the report server.
  3. On the Report Server Status page, click Stop or Start.
How to Start or Stop the Windows Service Using the Services in Administrative Tools
  1. Click Start, click Administrative Tools, and then click Services.
  2. Right-click SQL Server Reporting Services (MSSQLSERVER), and click Stop or Restart. If you are running multiple instance or if the report server is running as a named instance, verify that the instance name in parentheses corresponds to the report server instance you want to stop or restart.
How to Start or Stop the Windows Service Using the SQL Server Configuration Manager
  1. Click Start, click All Programs, click Microsoft SQL Server 2005, click Configuration Tools, and then click SQL Server Configuration Manager.
  2. Click SQL Server 2005 Services, right-click SQL Server Reporting Services, and click Stop or Restart.
How to Start or Stop the Windows Service Using the SQL Server Surface Area Configuration Tool

The SQL Server Surface Area Configuration tool provides a means of starting and stopping the service as a convenience so that you can stop the service before you make it unavailable in the Reporting Services installation.

You can also use this tool to make specific features unavailable. You can disable the Scheduling and Delivery processor and Web service requests. Enabling and disabling features affects configuration settings in the RSReportServer.config file. Specifically, if you select the IsWindowsServiceEnabled option, you set the following values in RSReportServer.config to true: IsSchedulingService, IsNotificationService, IsEventService. The IsWindowsServiceEnabled option in the SQL Server Surface Area Configuration tool is a union of all three configuration settings. Manually editing the values in the configuration file can undermine or reverse the selection you made in the tool.

  1. Click Start, click All Programs, click Microsoft SQL Server 2005, click Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. Click Surface Area Configuration for Services and Connections, expand Reporting Services, and click Stop or Start.

Starting, pausing, resuming, and stopping a service is not generally part of Web service management. ASP.NET starts and stops the Web service as part of managing the service. In most cases, you do not have to start or stop the Web service yourself. If you want to restart the Report Server Web service, you must restart Microsoft Internet Information Services (IIS). If you are running IIS 6.0, you can stop and start the application pool.

To verify whether the Web service is running, you can ping the service by typing http://localhost/reportserver in a browser URL address.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.