Export (0) Print
Expand All

Administering Reporting Services

SQL Server 2005

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.

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.

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.

The following table describes topics in other sections that are useful to report server administrators.

Topic Description

Deploying Reporting Services

Describes deployment topologies and configuration options.

Scripting Deployment and Administrative Tasks

Explains how to automate administrative functions using script.

Managing and Working With Published Reports

Contains information about content management, role-based security, report distribution, and report processing.

Community Additions

ADD
Show:
© 2014 Microsoft