SQL Server 2000 Requirements

As mentioned in Chapter 1, there are a couple of things required before you can set up your SQL Server. Internet Explorer 5.0 or later is needed solely for the Microsoft Management Console (MMC) and to view help topics in Books Online. There are still some hardware requirements that must be met before SQL Server can be installed, some of which are listed here. After making sure all the prerequisites are taken care of, you can then start the Setup Wizard by simply inserting the CD and clicking on Install SQL Server Components .

The following hardware is needed to install the Enterprise version of SQL Server 2000:

• Computer:

  Intel or compatible

  Pentium 166 MHz or higher

• Memory:

  64MB minimum, 128MB or more recommended

• Hard disk space:

  SQL Server database components: 95-270MB, 250MB typical

  Analysis Services: 50MB minimum, 130MB typical

  English Query: 80MB

  Desktop Engine only: 44MB

  Books Online: 15MB

• Monitor:

  VGA or higher resolution

  800x600 or higher resolution required for the SQL Server graphical tools

• Other Peripherals:

  CD-ROM drive

SQL Server 2000 Enterprise Edition

This edition is comprehensive, as outlined in Chapter 1: It includes the complete set of SQL Server database and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems. Its support for failover clustering also makes it ideal for any mission-critical, line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition. This edition requires the use of Indexed views.