SQL Server 2000: Editions and Components
Topic last updated -- January 2004
SQL Server 2000 editions include the Enterprise Edition, the Standard Edition, the Personal Edition, the Developer Edition, and the Evaluation Edition.
Note The Microsoft SQL Server 2000 Personal Edition replaces the Microsoft SQL Server version 7.0 Desktop Edition. To install client tools only, you can use the Personal Edition, which is also available when you purchase the Standard and Enterprise Editions of SQL Server 2000.
When you select SQL Server 2000 Components on the opening screen, three options appear on the Install Components screen:
Install Database Server
Starts SQL Server Setup, with screens for selecting installation options.
Install Analysis Services
Installs Analysis Services on computers processing OLAP cubes. For more information, see Installing Analysis Services.
Install English Query
Installs English Query on computers running English Query applications. For more information, see Installing English Query.
Choosing Components and Options to Install
You may have a database server, an Internet server, or require a database on a client computer. If running database client/server applications you may or may not require a database on your computer. You may need tools to administer a database server, or you may want to run applications that access an instance of SQL Server. Installation choices for these and other SQL Server configurations are described in the following paragraphs.
Installing SQL Server on a Database Server
If installing a database server, install either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition. If installing a personal database on your workstation, install SQL Server 2000 Personal Edition. These installations typically include the database engine, the client database management tools, and the client connectivity components.
On a database server, you can install a default instance of SQL Server 2000 relational database engine. You can also install one or more named instances of the SQL Server 2000 database engine. Other than specifying an instance name, the setup choices are similar to those for installing a default instance.
When installing an instance of SQL Server 2000, you must specify whether you want the instance to use failover clustering. For more information, see Before Installing Failover Clustering.
Using SQL Server with Client/Server Applications
For a computer running database client/server applications, such as Microsoft Visual Basic® applications that connect directly to an instance of SQL Server, you have several options:
- If you require a personal database on your client computer, install the Personal Edition of SQL Server. This setup typically installs the client tools and client connectivity components along with the database engine.
- If you do not require a database on your computer, but need to administer an instance of SQL Server on a database server, or plan to develop SQL Server applications, install the option for Client Tools Only. This option includes the client connectivity components. For more information, see How to install client tools only (Setup).
- If you want to only run applications that access instances of SQL Server on database servers, install the connectivity only components. For more information, see How to install connectivity only (Setup).
Using SQL Server with an Internet Server
On an Internet server, such as a server running Microsoft Internet Information Services (IIS), you typically install the SQL Server 2000 client tools. Client tools include the client connectivity components used by an application connecting to an instance of SQL Server. In addition, the client tools include the utility for configuring the virtual roots needed for applications to access SQL Server through URLs.
After installing the SQL Server client tools, you configure the virtual roots that support accessing an instance of SQL Server through a URL. For more information about configuring the virtual roots, see Using IIS Virtual Directory Management for SQL Server Utility.
Note Although you can install an instance of SQL Server on a computer running IIS, this is typically done only for small Web sites that have a single server computer. Most Web sites have their middle-tier IIS system on one server or cluster of servers, and their databases on a separate server or federation of servers. For more information about federations, see Federated SQL Server 2000 Servers.
If some of the Web pages on an Internet server use English Query, you would also install that component.
Other SQL Server Components
- For distributing SQL Server 2000 with applications, use the SQL Server 2000 Desktop Engine (MSDE 2000), a stand-alone database engine that independent software vendors can package with their applications. For more information, see Distributing SQL Server Applications Overview.
Note The Desktop Engine (MSDE 2000) has no graphical user interface and is not related to the SQL Server 7.0 Desktop Edition.
In addition to the major components and editions shown on the Install SQL Server 2000 Components screen, other editions of SQL Server 2000 are available: SQL Server 2000 Developer Edition, SQL Server 2000 Windows CE Edition, and the SQL Server 2000 Enterprise Evaluation Edition. For more information, see Features Supported by the Editions of SQL Server 2000.