SQL Server 2000 Administration in 15 Minutes a Week: Basic Installation
May 10, 2002
Click on "SQL Server 2000 Components" to view the available components you can install.
2. Now we are presented with three options on the components screen. Lets continue our installation by installing the Database Server. We will look at the Analysis Service and English Query components in a later article.
Click on "Install Database Server" to begin the SQL Server 2000 Installation.
3. The installation of the Database Server now begins.
Click Next to continue the installation.
4. We are now prompted to select which computer we would like to install SQL Server on. There are three options:
Local Computer -- Installs SQL Server onto the local computer
Remote Computer -- Installs SQL Server onto a remote computer on the network
Virtual Server -- Used for installing SQL Server onto a Server Cluster
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.