Administering Reporting Services
A Reporting Services installation consists of several server-side components that you need to manage and maintain. The server components include:
- The Report Server Web service, which runs on Microsoft Internet Information Services (IIS).
- The Report Server Windows service, which handles scheduled operations and report delivery.
- The report server database.
This section contains topics to help you administer a Reporting Services installation.
Requirements for Administering Reporting Services
To fully administer a Reporting Services installation, you must have the following permissions:
- Membership in the local Administrator group on the report server computer. If your installation includes server components that run on remote computers, you must have administrator permissions on those computers if you want to manage those servers over a remote connection.
- Database administrator permissions for the SQL Server instance that hosts the database.
- If you are installing Reporting Services on a domain controller, you must be a domain administrator.
In This Section
- Report Server Administration Tools
Provides a comprehensive list of tools that you can use to manage a Reporting Services installation.
- Backup and Restore Operations for a Reporting Services Installation
Explains how to backup and restore all data files used in a Reporting Services installation. It also provides instructions on how to re-establish a connection to a report server database that has been moved to another computer.
- Administering a Report Server Database
Contains overview and administration information about the report server database that provides internal storage for a report server.
- Administering the Report Server Web Service and Windows Service
Provides information about what each service does, explains how to take the services offline, and how to change service accounts and passwords.
- Reporting Services Log Files
Describes the log files used by Reporting Services components and how to retrieve log file information.
- Monitoring Report Server Performance
Describes different approaches for monitoring report server performance and provides information about performance counters.
Related Sections
The following table describes topics in other sections that are useful to report server administrators.
Topic | Description |
---|---|
Describes deployment topologies and configuration options. |
|
Explains how to automate administrative functions using script. |
|
Contains information about content management, role-based security, report distribution, and report processing. |
See Also
Concepts
Reporting Services Component Overview
Report Server Database
Report Server
SQL Server Reporting Services
Other Resources
Installing SQL Server Reporting Services