Lesson 3: Running the SQL Server 2000 Setup Program

After you have selected your SQL Server 2000 edition, and installed the Windows operating system you have decided to use, you are ready to install SQL Server 2000 by running the SQL Server 2000 Setup program. This lesson covers running the SQL Server 2000 Setup program interactively to install an instance of SQL Server 2000 on the local computer. The details of default, named, and multiple instances are covered in Lesson 4 of this chapter. Remote and unattended installations are covered in Lesson 5 of this chapter. Upgrading from earlier versions of SQL Server is covered in Chapter 4, and installing SQL Server 2000 on a virtual server for failover clustering is covered in Chapter 16.

After this lesson, you will be able to

• Understand how to start the SQL Server 2000 Setup program

• Understand the difference between the Client Tools Only, the Server and Client Tools, and Connectivity Only installation types

• Describe the components that are installed and the software configuration options that are selected when a Typical or a Minimum setup is selected

• Determine when to select a Custom setup

Estimated lesson time: 30 minutes

Running the SQL Server 2000 Setup Program

There are several ways to start the SQL Server 2000 Setup program for an interactive installation of SQL Server 2000. The easiest way to begin is to simply insert the SQL Server 2000 compact disc into the CD-ROM drive. From the initial dialog box, you can install SQL Server 2000, Analysis Services, or English Query by clicking on SQL Server 2000 Components. The initial dialog box presents a number of additional options, including providing access to the setup/upgrade portion of Books Online, the Release Notes, and SQL Server Web site at Microsoft. Double-clicking on Autorun.exe in the root of the CD-ROM also accesses this initial dialog box. After clicking SQL Server 2000 Components, click Install Database Server to start the SQL Server 2000 Setup program. See Figure 2.1.

Note

You can also start the SQL Server 2000 Setup program by double-clicking on Setupsql.exe in the \X86\Setup folder.