HOW TO: Install SQL Server 2000 - Basic Local Installation

Article translations Article translations
Article ID: 303747 - View products that this article applies to.
This article was previously published under Q303747
Expand all | Collapse all

On This Page

SUMMARY

This step-by-step guide describes how to install a SQL Server 2000 basic local installation.

Note SQL Server 2000 64-bit uses Windows Installer to completely integrate the installation of SQL Server features in a single feature tree. Minimum and typical installation modes are no longer implemented. For more details, see the SQL Server 2000 64-bit documentation.

Installing SQL Server 2000

To Install SQL Server 2000 Basic Local Installation

  1. Insert the Microsoft SQL Server 2000 compact disc in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, and then select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.
  2. In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.
  3. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next. Follow directions on the User Information, Software License Agreement and related pages. In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
  4. In the Instance Name dialog box, if the Default check box is available, you can install either the default or a named instance. If the Default check box is not available, a default instance has already been installed, and you can install only a named instance.
    • To install the default instance, click to select the Default check box, and then click Next.
    • To install a named instance, click to clear the Default check box, type a new named instance in the Instance Name box, and then click Next.
  5. In the Setup Type dialog box, click Typical or Minimum, and then click Next.
  6. In the Service Accounts dialog box, accept the default settings, type your domain password, and then click Next. In the Authentication Mode dialog box, accept the default setting, and then click Next. When you finish specifying options, click Next in the Start Copying Files dialog box.
  7. In the Choose Licensing Mode dialog box, make selections according to your license agreement, and then click Continue to begin the installation. In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.

To Install Client Tools Only for SQL Server 2000

  1. Insert the Microsoft SQL Server 2000 compact disc in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, select Install Database Server, and then click Next at the Welcome page of the SQL Server Installation Wizard.
  2. In Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the edit box. Click Next.
  3. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
  4. Follow the directions on the User Information, Software License Agreement, and related pages.
  5. In the Installation Definition dialog box, click Client tools only, and then click Next.
  6. In the Select Components dialog box, accept the defaults or select the components you want, and then click Next. You can select an item in the Components list, such as Management Tools, and then select items from the related Sub-Components list, such as Enterprise Manager. Click to select items that you want to install, and click to clear the check box for the items you do not want to install. For information about each component, select the item, and view the Description box.
  7. In the Start Copying Files dialog box, click Next to complete the installation of the client tools.

To Install Connectivity Only for SQL Server 2000

  1. Insert the Microsoft SQL Server 2000 compact disc into your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), and then select SQL Server 2000 Components.
  2. Select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.
  3. In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.
  4. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
  5. Follow the directions on the User Information, Software License Agreement and related pages.
  6. In the Installation Definition dialog box, click Connectivity Only, and then click Next.
  7. In the Start Copying Files dialog box, click Next to complete the installation.

REFERENCES

Microsoft SQL Server Books Online:

"Basic Installation Options"


For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
257716 Frequently Asked Questions - SQL Server 2000 - Setup

Properties

Article ID: 303747 - Last Review: January 21, 2004 - Revision: 3.4
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbgraphxlink kbhowtomaster KB303747

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com