Setup Type: Typical, Minimum, or Custom
When you install the Microsoft® SQL Server™ 2000 Enterprise Edition, SQL Server 2000 Standard Edition, or SQL Server 2000 Personal Edition, SQL Server Setup offers three installation types in the Setup Type dialog box. In addition, you can modify the installation location for both program and data files in this dialog box.
Options
Typical
Installs all of SQL Server using the default installation options. This installation is recommended for most users.
Minimum
Installs the minimum configuration necessary to run SQL Server. This installation is recommended for users who have computers with minimum available disk space.
Custom
Installs SQL Server and allows you to change any or all of the default options. Use a custom installation to select components and subcomponents, or to change settings for collations, services accounts, authentication, or network libraries.
Destination Folders
The default installation location is C:\Program Files\Microsoft SQL Server\, for both program and data files.
Program files
Click Browse to select another installation location for the SQL Server program files.
Data files
Click Browse to select another installation location for the SQL Server data files.
Caution It is recommended that program files not be installed on a cluster disk, so that future upgrades to a cluster are possible. If you select a folder on a cluster disk as a destination for SQL Server program files, a message appears requesting another installation path for program files.
When upgrading an installation of SQL Server 7.0 that has previously had program files installed on a cluster disk, a similar message appears: "Setup will move the program files from the cluster disk. Provide a new location for the program files. The drive letter you select must exist on all nodes of the cluster as a local drive so that you can later upgrade to a clustered installation."
For more information, see Upgrading to a SQL Server 2000 Failover Cluster.
Components for Each Installation Type
When you install SQL Server on Microsoft Windows NT® or Windows 2000, these options are offered for all installation types:
- Windows Services accounts (logon accounts) for SQL Server and SQL Server Agent.
- Whether to start SQL Server and SQL Server Agent automatically each time the computer is restarted.
- Use of various network libraries, or protocols, including TCP/IP Sockets, Named Pipes, and Multiprotocol.
This table lists the types of installations and components that each installation provides.
| Component | Typical | Minimum | Custom |
|---|---|---|---|
| Database Server | Yes | Yes | Optional |
| Upgrade Tools1 | Yes | No | Optional |
| Replication Support | Yes | Yes | Optional |
| Full-Text Search | Yes | Yes | Optional |
| Client Management Tools | All | None | Optional |
| Client Connectivity | Yes | Yes | Not an option |
| Books Online | Yes | No | Optional |
| Development Tools | Debugger only | None | Choice of tools |
| Code Samples | None | None | Choice of samples |
| Collation Settings | Yes | Yes | Choice of settings |
1 Upgrade Tools are installed by default only for the default instance of SQL Server 2000, not for any named instances.