Setup Type: Typical, Minimum, or Custom

Installing SQL Server

Installing SQL Server

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.



Installs all of SQL Server using the default installation options. This installation is recommended for most users.


Installs the minimum configuration necessary to run SQL Server. This installation is recommended for users who have computers with minimum available disk space.


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.

See Also

Net-Libraries and Network Protocols