SQL Server 2000 System Requirements

Updated: May 30, 2006

Related Links

•	SQL Server 2005 System Requirements
•	How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
•	Migrating Oracle Databases to SQL Server 2000
•	Migrating Informix Databases to SQL Server 2000
•	Migrating MySQL to SQL Server 2000
•	Migrating Microsoft Access to SQL Server 2000

Microsoft SQL Server 2000 requires the following minimum system configuration.

Note: If you are running a 64-bit version of a Microsoft Windows Server™ operating system, you need to use SQL Server 2000 Enterprise Edition (64-bit). Visit the SQL Server 2000 (64-bit) System Requirements page for additional information.

Minimum Requirements

Processor

166-megahertz (MHz) or higher processor

Operating System

•

SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:

•	Windows Server 2003 R2
•	Windows Server 2003, Standard Edition¹
•	Windows Server 2003, Enterprise Edition²
•	Windows Server 2003, Datacenter Edition³
•	Windows® 2000 Server
•	Windows 2000 Advanced Server
•	Windows 2000 Datacenter Server

•

SQL Server 2000 Evaluation Edition and Developer Edition and Workgroup Edition can run on the following operating systems:

•	Operating systems listed above for Enterprise and Standard Editions
•	Windows XP Professional
•	Windows XP Home Edition
•	Windows 2000 Professional

•

SQL Server 2000 Personal Edition⁴ and SQL Server 2000 Desktop Engine (MSDE) can run on the following operating systems:

•	Operating systems listed above for Enterprise, Standard, Evaluation, and Developer Editions
•	Windows Server 2003, Web Edition⁵ (MSDE only)
•	Windows 98
•	Windows Millennium Edition (Windows Me)

Memory⁶

•	Enterprise Edition: 64 megabytes (MB) of RAM; 128 MB recommended
•	Standard Edition: 64 MB
•	Workgroup Edition: 64 MB
•	Evaluation Edition: 64 MB; 128 MB recommended
•	Developer Edition: 64 MB
•	Personal Edition: 128 MB for Windows XP; 64 MB for Windows 2000; 32 MB for other operating systems
•	MSDE: 128 MB for Windows XP; 64 MB for Windows 2000; 32 MB for other operating systems

Hard Disk⁷

Enterprise, Standard, Workgroup, Evaluation, Developer, and Personal Editions require:

•	95–270 MB of available hard disk space for the server; 250 MB for a typical installation.
•	50 MB of available hard disk space for a minimum installation of Analysis Services; 130 MB for a typical installation.
•	80 MB of available hard disk space for English Query.

MSDE requires 44 MB of available hard disk space.

Drive

CD-ROM drive

Display

VGA or higher-resolution monitor

Other Devices

•	Microsoft Internet Explorer version 5.0 or later
•	Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000, and Windows XP have built-in network software. Additional network software is required if you are using Banyan VINES or AppleTalk ADSP. Novell NetWare IPX/SPX client support is provided by the NWLink protocol of Windows-based networking.

Client Support:

•	Windows 95⁸, Windows 98, Windows Me, Windows NT Workstation 4.0, Windows 2000 Professional, Windows XP Professional, and Windows XP Home Edition are supported.
•	UNIX, Apple Macintosh, and OS/2 require Open Database Connectivity (ODBC) client software from a non-Microsoft vendor.

1	Windows Server 2003 requires SQL Server 2000 Service Pack 3 or later to be applied.
2	Windows Server 2003 requires SQL Server 2000 Service Pack 3 or later to be applied.
3	Windows Server 2003 requires SQL Server 2000 Service Pack 3 or later to be applied.
4	SQL Server 2000 Personal Edition is offered for desktop and mobile use. Personal Edition does not contain the full functionality of Standard Edition. For more information on the capabilities of Personal Edition, read the "Choosing an Edition of SQL Server" white paper. Analysis Services—including online analytical processing (OLAP), data mining, and other data warehousing features—are included in Personal Edition but cannot be installed on Windows 98 or Windows Me.
5	Windows Server 2003 requires SQL Server 2000 Service Pack 3 or later to be applied.
6	Additional memory may be required, depending on operating system requirements.
7	Hard disk requirements vary based on your system configuration and the applications and features you choose to install.
8	Supported for client connectivity only; does not include graphical tool support.

Top of page