How to License Reporting Services
|
The server components of SQL Server 2000 Reporting Services include the Report Server and the Report Server Database. The Report Server processes and renders reports, and handles scheduled events and report delivery. The Report Server Database stores report definitions, report metadata, subscription information, and so on. Each Report Server requires either a local or remote connection to a Report Server Database. To use any of these components, each computer on which the Report Server and the Report Server Database are installed must have a valid SQL Server 2000 license.
Two licensing options are available for SQL Server 2000 Reporting Services:
| • | Per-processor licensing. Required for extranet or Internet deployments. Requires a single license for each CPU in the operating system instance running Reporting Services. This license does not require any device or user client access licenses (CALs). |
| • | Server plus CALs licensing. Requires a license for the computer running Reporting Services, as well as a CAL for each user or client device that accesses reports either directly or indirectly (including the Report Designer). |
The following four scenarios illustrate how to properly license SQL Server 2000 Reporting Services.
Scenario 1. Licenses Required for Report Server and Report Server Database on the Same Computer
In scenario 1, the Report Server and Report Server Database are installed on the same computer, so only one valid license for SQL Server 2000 is required.
Scenario 2. Licenses Required for Report Server and Report Server Database on Different Computers Using the Same Edition of SQL Server 2000
In scenario 2, the Report Server and the Report Server Database are installed on different computers, with each computer using the same edition of SQL Server 2000. In configuration A, both computers are using SQL Server 2000 Standard Edition; in configuration B, both are using SQL Server 2000 Enterprise Edition. Either configuration requires two valid licenses of SQL Server 2000, one for each computer on which SQL Server 2000 is installed.
Scenario 3. Licenses Required for Report Server and Report Server Database on Different Computers Using Different Editions of SQL Server 2000
In scenario 3, the Report Server and the Report Server Database are installed on different computers, with each computer using a different edition of SQL Server 2000. In configuration A, the computer with the Report Server is using SQL Server 2000 Standard Edition while the computer with the Report Server Database is using SQL Server 2000 Enterprise Edition. In configuration B, the computer with the Report Server is using SQL Server 2000 Enterprise Edition while the computer with the Report Server Database is using SQL Server 2000 Standard Edition. Either configuration requires two valid licenses of SQL Server 2000, one for each computer on which SQL Server 2000 is installed.*
* For more information about which edition of SQL Server 2000 you should use with the Report Server and the Report Server database, see SQL Server 2005 Reporting Services Feature Matrix.
Scenario 4. Multiple Report Server Computers Connect to a Remote Report Server Database in a Web Farm Configuration
In scenario 4, a Web farm configuration has Report Server installed on three separate computers that are all connected to a common Report Server database on a fourth computer. Because Web farm configurations are only supported by SQL Server 2000 Reporting Services Enterprise Edition, this scenario requires three valid licenses of SQL Server 2000 Enterprise Edition for the computers running the Report Server, plus another valid license of SQL Server 2000 for the computer running the Report Server Database. The Report Server Database can run with either SQL Server 2000 Standard or Enterprise edition.
