Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 11, 2002

SQL Server 2000 Administration in 15 Minutes a Week: Basic Installation - Page 2

By Michael Aubert

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

Click to Enlarge

Enter your name and company information and click Next.

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

Click to Enlarge

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. For information on what is and is not a valid Named Instance name, have a look at my first article in this series: SQL Server 2000 Administration Fundamentals.

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.
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$InstanceName\Binn
Named Instance \Program Files\Microsoft SQL Server\Mssql\Data \Program Files\Microsoft SQL Server\MSSQL$InstanceName\Data

* 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.

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.

Page 3: ...and Continues...

 » See All Articles by Columnist Michael Aubert

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM