Export (0) Print
Expand All

Standard Deployment Model

SQL Server 2000

If you are deploying Reporting Services in a corporate workgroup or in a small- to medium-sized business, consider installing and running the server components in a standard deployment configuration. The standard deployment model describes a configuration where the Report Server and Report Manager components are installed on a single computer running a Microsoft Windows® server-based operating system. The report server database requires a SQL Server instance, which may be located on the local computer or on a remote computer. A standard configuration supports the following server-side components:

  • Report Server
  • Report Manager
  • Report server database (on a local or remote server)

Report server and Report Manager components have a combination of prerequisites that must be satisfied by a single computer. Report Designer is a client-side component, so it does not need to be installed with the server components. For more information about component requirements, see Software Requirements for Reporting Services.

The following diagram shows the standard deployment model where the report server database is located on a remote server.

Choosing a Standard Configuration

The standard deployment topology is required if you are running the Standard Edition of Reporting Services. It is also recommended if you are evaluating the product or developing an application based on the Reporting Services platform. This deployment model is not intended for organizations that have high-availability or high-volume reporting requirements.

Database Requirements

A primary consideration in choosing where to host the report server database is disk space availability. If you have a remote SQL Server that has extra capacity, you should use a remote server. Although the footprint of a report server database may be small initially, disk space requirements can grow significantly at run time depending on how you run reports and the number of users accessing the report server. For more information, see Report Server Database Requirements.

Important  The SQL Server instance hosting the report server database must be in the same domain as the report server or in a trusted domain with the report server.

See Also

Reporting Services Component Overview

Installing Reporting Services

© 2015 Microsoft