SQL Server 2000 Installation

Introduction

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

Hardware and Software Requirements

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

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:

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:

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:

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

There are three installation types:

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

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

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