How to License Analysis Services Components
The Analysis Services components of SQL Server 2000 include online analytical processing (OLAP) database, Data Transformation Services (DTS), and data mining. To use any of these components, the server on which Analysis Services is installed must have a valid SQL Server 2000 license.
The following three scenarios illustrate how to properly license Analysis Services components.
Scenario 1—Licenses Required for Database Server, DTS, and OLAP Server with a Defined Number of Users
In scenario 1, the database server is accessed by Internet users, DTS, and an OLAP server. The following SQL Server licenses are required:
| • | Database server. Requires four Processor licenses. The database server must be licensed under the Per Processor licensing model because the Internet users indirectly access the database server through the application server. |
| • | DTS. Requires one Server license and two client access licenses (CALs). DTS requires CALs for both the database server and the OLAP server. |
| • | OLAP server. Requires one Server license and three CALs. CALs are required for the two Analysis Services users and the DTS server. |
Scenario 2—Licenses Required for Database Server, DTS, and OLAP Server with an Undefined Number of Users
In scenario 2, the database server is accessed by Internet users, DTS, and an OLAP server. The following SQL Server licenses are required:
| • | Database server. Requires four Processor licenses. The database server must be licensed under the Per Processor licensing model because the Internet users indirectly access the database server through the application server. |
| • | DTS. Requires one Server license and two CALs. CALs are required for both the database server and the OLAP server. |
| • | OLAP server. Requires four Processor licenses. The OLAP server must be licensed under the Per Processor licensing model since users access the OLAP cubes through the Internet and the reporting server. |
Scenario 3—Licenses Required for Database Server and OLAP Server on the Same Box
In scenario 3, the database server and OLAP server are installed on the same box, with users accessing both via the Internet. The following SQL Server licenses are required:
| • | Database server and OLAP server. Requires eight Processor licenses. The Database server and the OLAP server instances are installed on the same server, which must be licensed under the Per Processor licensing model because the Internet users indirectly access the database server through the application server. |
