Installing SQL Server 2000

Note that a Custom Installation, by default, selects all the options of a typical Installation. The following table will give you an idea of how much disk space each setup type uses.

Type – System Files – Program Files – Database Files
Typical/Custom* – 182,917K – 38,205K – 34,432K
Minimum – 75,116K – 12,127K – 25,600K

*By adding and removing components the Custom installation size will change.

On this screen we are also prompted to select the destination folders for the Program Files and Data Files.

  • Program Files – The files that make up the SQL Server engine and tools
  • Data Files – The SQL Server databases

The default drive selected to install SQL Server 2000 is the System Drive (the same drive that contains your Windows installation). Finding the default directories is a little different and depends on whether you are installing a default or named instance. Use the table below to locate the default directories.

Instance Type – Program Files Directory – Data Files Directory
Default Instance – \Program Files\Microsoft SQL Server\Mssql\Binn – \Program Files\Microsoft SQL Server\Mssql\Data
Named Instance* – \Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn – \Program Files\Microsoft SQL Server\MSSQL$InstanceName\Dat

* Where “InstanceName” is the name of your SQL Server Instance

Select “Custom” and unless you have a specific reason to change the destination folders (such as not having the disk space needed) leave them as default and click Next.

11. At this point the installation gives you the opportunity to select optional components.

Click Next to continue the installation.

12. Choosing the proper service accounts (the accounts that SQL Server will use to authenticate to Windows when it needs to access resources such as NTFS hard drives or other computers) is an important one. SQL Server 2000 uses two accounts: one for SQL Server and one for the SQL Server Agent. The SQL Server account is used by the SQL database engine which provides all the database related services. The SQL Server Agent account is used by the SQL Server Agent which provides alerts and job scheduling for your SQL Server. For now just understand there are two different accounts, the differences will become apparent when we discuss the SQL Server Agent in more detail.

The first option you must select is whether you want the two services to use the same account and have the SQL Server agent start automatically or if you want to customize the accounts for each service. If you select to use the same account, you then have the option to use the Local System account or use a Domain User account.