Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server 2016 (13.x) Reporting Services and later
Power BI Report Server
A report server is implemented as a Windows service that contains the Report Server web service, the web portal, and a background processing application. The service must be running if you want to use any report server functionality. Stopping the service stops all report server operations.
While the service is stopped, requests for scheduled report and subscription processing that would occur if the service is running are added to the queue. This result happens because jobs that the SQL Server Agent runs create the events. If you want to avoid a backlog of operations while the service is off, consider stopping SQL Server Agent as well.
You can use various tools to start or stop the Report Server service. These tools include the Reporting Services Configuration tool, SQL Server Configuration Manager, and the Services tool provided in Microsoft Windows.
Note
SQL Server Configuration Manager is only an option for SQL Server Reporting Services 2016 and earlier. It does not include Reporting Services 2017 and later or Power BI Report Server.
If you're doing more than starting or stopping the service, you must use the Reporting Services Configuration tool. This tool is designed for comprehensive configuration tasks beyond basic service management. Using other tools to change the service account can break your Reporting Services installation and encryption key. For more information, see Configure the Report Server service account (Report Server Configuration Manager).
You can't pause and resume the service. There aren't start parameters. Although there are no explicit dependencies, SQL Server Agent must be running if you support any subscriptions or scheduled report operations on the report server.
Start Reporting Services Configuration tool and connect to the report server.
On the Report Server Status page, select Stop or Start.
For Reporting Services 2016 and earlier versions, you must verify that the instance name in parentheses corresponds to the report server instance you want to stop or restart. Specifically, you must follow these steps if you're running multiple instances or if the report server is running as a named instance.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Build reports for finance and operations apps - Training
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u