Installing SQL Server 2000

In this article we will look at an installation of SQL Server 2000 on a local computer only. In the next article of this series I will discuss Remote and Clustered installations.

Select “Local Computer” and click Next.

5. Now that we have selected where we would like to install SQL Server we have to choose what we would like to do in this installation.

  • Create a new instance – Allows you to install a new instance of SQL Server or the Client Tools
  • Upgrade, remove, or add components – Allows you to work with an existing instance that is already installed
  • Advanced options – Allows you to create custom installation files, rebuild registry keys, and maintain Virtual Servers for Failover Clustering

For now we will look at how to create a new instance. In my next article I will cover how to upgrade an existing instance, perform unattended installations, and configure a clustered server.

Select “Create a new instance of SQL Server, or install Client Tools” and click Next.

6. The next few screens are common and fairly simple so I will cover them quickly.

Enter your name and company information and click Next.

7. To continue the installation we are asked to read the licensing agreement.

Read the agreement and click “Yes” if you agree or click “No” if you do not agree with the licensing terms. Note if you click “No” the installation will be terminated.

8. Next we need to choose what type of Installation we would like to perform.

  • Client Tools Only – Installs the Client Tools that allow you to manage a remote SQL Server
  • Server and Client Tools – Installs an instance of SQL server and the Client Tools
  • Connectivity Only – Installs the Data Access Components (DAC) and Network Libraries so applications can access a SQL Server instance

Select “Server and Client Tools” and click Next.

9. The Instance Name is the next option we are presented with. If you are installing SQL Server as a Default Instance you leave the “Default” checkbox checked. If you need to install a Named Instance you must uncheck “Default” and you will then be required to enter a valid name for the instance in the “Instance Name” textbox. Click here for information on what is and is not a valid Named Instance name.

Leave the “Default” checkbox checked and click Next.

10. We must now select the setup type.

  • Typical – Installs required files and the most commonly used optional files
  • Minimum – Installs only required files
  • Custom – Installs required files and then you will be prompted to select which optional files you would like installed. Custom setup also allows you to set the collation and network libraries that are used.