SQL Server 2000 Installation



Introduction

Hardware and Software Requirements

SQL Server Editions

Installation Types

Testing an installation

Literature

Introduction

In this article I want to tell you about some general details of
SQL Server 2000 installation.

I also described hardware and software requirements for SQL Server 2000
and SQL Server 2000 editions.

Hardware and Software Requirements

Hardware requirements:

  • Intel or compatible platform

  • Pentium 166 MHz or higher (Pentium II, Pentium III and compatible)

  • 32MB RAM (minimum for Desktop Engine),
    64MB RAM (minimum for all other editions)
    128 MB RAM or more recommended

  • 270MB (full installation), 250MB (typical), 95MB (minimum),
    44 MB (Desktop Engine) plus Analysis Services: 50 MB minimum
    and 130 MB typical and 80MB for the English Query
  • By the way, there is no hardware restriction on the processor speed
    (you can run SQL Server 2000 on the Pentium with minimum mhz), I have
    checked it on Pentium 120, but don’t use this hardware on production
    server, only for the test purpose.

    SQL Server 2000 will run under Windows 98, Windows NT Server 4.0 with
    Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5
    or later and Windows 2000 (all editions).

    SQL Server 2000 also requires Internet Explorer 5.0 or later, as it is
    required for Microsoft Management Console and HTML Help.
    Internet Explorer is not required to be the default browser and a
    minimal install is sufficient.


    SQL Server Editions

    There are three main SQL Server 2000 editions:

  • Personal Edition

  • Standard Edition

  • Enterprise Edition
  • Personal Edition can works on the Windows 98, Windows NT Server 4.0
    with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5
    or later and on the all editions of Windows 2000. This edition is related
    to SQL Server 7.0 Desktop Edition.

    This edition has some restrictions:

  • maximum 2 CPU

  • no Distributed Partitioned Views

  • no Log Shipping

  • no Parallel DBCC

  • no Parallel index creation

  • no Failover clustering

  • no publishing for transaction replication

  • maximum 2Gb RAM
  • Standard Edition can works on the Windows NT Server 4.0 with
    Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the
    Windows 2000 Server/Advanced Server/DataCenter.

    This edition has the following restrictions:

  • maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)

  • no Distributed Partitioned Views

  • no Log Shipping

  • no Parallel index creation

  • no Failover clustering

  • maximum 2Gb RAM
  • Enterprise Edition can works on the Windows NT Server 4.0 with
    Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the
    Windows 2000 Server/Advanced Server/DataCenter.

    This edition can uses:

  • up to 32 CPU on the Windows 2000 DataCenter
    up to 8 CPU on the Windows 2000 Advanced Server and on the
    Windows NT Server 4.0 Enterprise Edition
    up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000
    Server

  • up to 64Gb RAM on the Windows 2000 DataCenter
    up to 8 Gb RAM on the Windows 2000 Advanced Server
    up to 4 Gb RAM on the Windows 2000 Server
    up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition
    up to 2 Gb RAM on the Windows NT Server 4.0

  • Distributed Partitioned Views

  • Log Shipping

  • Parallel index creation

  • Failover clustering
  • There are also Developer Edition, Desktop Engine, SQL Server CE and
    Evaluation Edition.

    The Developer Edition can be used by developer to create and debug
    stored procedures, triggers used by client applications. This edition
    comes with its own compact disc and can be upgraded to SQL Server 2000
    Enterprise Edition.

    The Desktop Engine has no graphical user interface and is related to
    the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of
    Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can
    use maximum 2 CPU.

    The SQL Server CE edition can works only on the Microsoft Windows CE,
    so it has all restrictions of this operation system (can use only 1 CPU,
    no Parallel index creation, no Full-Text Search and so on).

    The Evaluation Edition can be used only for the test purposes to learn
    more about the new features and enhancements and should be uninstalled
    after a 120-day evaluation period.


    Installation Types

    SQL Server Setup offers three installation types in the Setup Type
    dialog box, when you install the SQL Server 2000 Enterprise Edition,
    SQL Server 2000 Standard Edition, or SQL Server 2000 Personal Edition,

    There are three installation types:

  • Typical

  • Minimum

  • Custom
  • Typical

    The Typical installation option is recommended for most users. This is
    the default installation options. The Typical option installs the upgrade
    tools, replication support, client management tools, online documentation
    and so on.

    Minimum

    This installation can takes only 95Mb on your hard drive and contains
    the minimum configuration necessary to run SQL Server.

    There are no upgrade tools, full-text search, client management tools,
    online documentation, development tools and code samples.

    Microsoft recommends this installation for users who have computers with
    minimum available disk space.

    Custom

    This type of installation allows you to change any or all of the default
    options. Custom installation is recommended for advanced users. You can
    install code samples, choose to install the development libraries, network
    libraries, code samples and so on.


    Testing an installation

    There are several ways to test SQL Server 2000 installation. When the
    installation is complete, you can verify SQL Server installation with
    osql (or isql) utility. This is the description:

    1. Start MSSQLServer service.

    You can start MSSQLServer service by entering from a command prompt:


    net start mssqlserver

    or by run SQL Server Service Manager and start MSSQLServer service
    manually.

    2. Run osql utility.

    Once the server is running, type the following command-line options:


    OSQL -Usa -P

    If successful, this osql prompt appears:

    1>

    Now you can verify SQL Server 2000 installation by entering this simple
    query:


    SELECT @@SERVERNAME
    GO

    If successful, this query returns the name of the server on which SQL
    Server 2000 is running. Now you can exit by typing exit command.


    Literature

    1. SQL Server Books Online

    2. SQL Server 2000 Evaluation Edition

    http://www.microsoft.com/sql/productinfo/evaluate.htm

    3. SQL Server 2000 System Requirements

    http://www.microsoft.com/sql/productinfo/sysreq.htm

    4. Hardware Compatibility List page

    http://www.microsoft.com/hcl/default.asp


    »


    See All Articles by Columnist
    Alexander Chigrik

    Alexander Chigrik
    Alexander Chigrik
    I am the owner of MSSQLCity.Com - a site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQs, Scripts, Tips and Test Exams.

    Latest Articles