This table shows hardware requirements for installing and running SQL Server 2005 on the 32-bit platform.
|
SQL Server 2005 (32-bit)
|
Processor type1
|
Processor speed2
|
Memory (RAM)3
|
|---|
|
SQL Server 2005 Enterprise Edition
4
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
|
Pentium III-compatible processor or higher
|
Minimum: 600 MHz
Recommended: 1 GHz or higher
|
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum
|
|
SQL Server 2005 Workgroup Edition
|
Pentium III-compatible processor or higher
|
Minimum: 600 MHz
Recommended: 1 GHz or higher
|
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum
|
|
SQL Server 2005 Express Edition
|
Pentium III-compatible processor or higher
|
Minimum: 500 MHz
Recommended: 1 GHz or higher
|
Minimum: 192 MB
Recommended: 512 MB or more
Maximum: Operating system maximum
|
|
SQL Server 2005 Express Edition with Advanced Services
|
Pentium III-compatible processor or higher
|
Minimum: 600 MHz
Recommended: 1 GHz or higher
|
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum
|
1System Configuration Checker (SCC) will block Setup if the requirement for processor type is not met.
2SCC will warn the user but will not block Setup if the minimum or recommended processor speed check is not met. No warning will appear on multiprocessor machines.
3SCC will warn the user but will not block Setup if the minimum or recommended RAM check is not met. Memory requirements are for this release only, and do not reflect additional memory requirements of the operating system. SCC verifies the memory available when Setup starts.
4
SQL Server Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition.
During installation of SQL Server 2005, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade to SQL Server 2005, verify that you have 2.0 GB of available disk space on the system drive for these files. This requirement applies even if you install all SQL Server components to a non-default (system) drive. Many files will be installed to the system drive, usually drive C:. For example, Setup log files will be written to the system drive, and can require 80 MB for a stand-alone installation, and more for a failover cluster installation. For more information, see File Locations for Default and Named Instances of SQL Server 2005.
Actual hard disk space requirements depend on your system configuration and the applications and features you choose to install. The following table provides disk space requirements for SQL Server 2005 components.
|
Feature
|
Disk space requirement
|
|---|
|
Database Engine and data files, Replication, and Full-Text Search
|
280 MB
|
|
Analysis Services and data files
|
90 MB
|
|
Reporting Services and Report Manager
|
120 MB
|
|
Notification Services engine components, client components, and rules components
|
50 MB
|
|
Integration Services
|
120 MB
|
|
Client Components
|
850 MB
|
|
SQL Server Books Online and SQL Server Compact Edition Books Online
|
240 MB
|
|
Samples and sample databases. Note that samples and sample databases are not installed by default.
|
410 MB
|
This table shows the operating systems that run the server software for each 32-bit version of SQL Server 2005. For information about how to install SQL Server 2005 on Windows Server 2008, see the list of known issues .
|
|
Enterprise Edition1
|
Developer Edition
|
Standard Edition
|
Workgroup Edition
|
Express Edition and Express with Advanced Services
|
Evaluation Edition
|
|---|
|
Windows 2000
|
No
|
No
|
No
|
No
|
No
|
No
|
|
Windows 2000 Professional Edition SP42, 4
|
No
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows 2000 Server SP42
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows 2000 Advanced Server SP42
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows 2000 Datacenter Edition SP42
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows XP Embedded SP2 Feature pack 2007
|
No
|
No
|
No
|
No
|
Yes9
|
No
|
|
Windows Embedded for Point of Service
|
No
|
No
|
No
|
No
|
Yes10
|
No
|
|
Windows XP Home Edition SP2
|
No
|
Yes
|
No
|
No
|
Yes
|
No
|
|
Windows XP Professional Edition SP24
|
No
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows XP Media Edition SP2
|
No
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows XP Tablet Edition SP2
|
No
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Server 2003 Server SP16
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Server 2003 Enterprise Edition SP16
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Server 2003 Datacenter Edition SP16
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Server 2003 Web Edition SP1
|
No
|
No
|
No
|
No
|
Yes
|
No
|
|
Windows Small Business Server 2003 Standard Edition SP1
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Small Business Server 2003 Premium Edition SP1
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
Windows Vista Starter Edition
|
No
|
No
|
No
|
No
|
No
|
No
|
|
Windows Vista Home Basic Edition
|
No
|
Yes7
|
No
|
No
|
Yes8
|
Yes7
|
|
Windows Vista Home Premium Edition
|
No
|
Yes7
|
No
|
No
|
Yes8
|
Yes7
|
|
Windows Vista Ultimate Edition
|
No
|
Yes7
|
Yes7
|
Yes7
|
Yes8
|
Yes7
|
|
Windows Vista Business Edition
|
No
|
Yes7
|
Yes7
|
Yes7
|
Yes8
|
Yes7
|
|
Windows Vista Enterprise Edition
|
No
|
Yes7
|
Yes7
|
Yes7
|
Yes8
|
Yes7
|
|
Windows Server 2003 64-Bit Itanium Datacenter Edition SP1
|
No
|
No
|
No
|
No
|
No
|
No
|
|
Windows Server 2003 64-Bit Itanium Enterprise Edition SP1
|
No
|
No
|
No
|
No
|
No
|
No
|
|
Windows Server 2003 64-Bit x64 Standard Edition SP16
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
|
Windows Server 2003 64-Bit x64 Datacenter Edition SP16
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
|
Windows Server 2003 64-Bit x64 Enterprise Edition SP16
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
|
Windows XP x64 Professional 2003
|
No
|
WOW643
|
WOW643
|
WOW643
|
WOW643
|
No
|
|
Windows Vista Home Basic 64-Bit x64 Edition
|
No
|
WOW643,7
|
No
|
No
|
WOW643,8
|
WOW643,7
|
|
Windows Vista Home Premium 64-Bit x64 Edition
|
No
|
WOW643,7
|
No
|
No
|
WOW643,8
|
WOW643,7
|
|
Windows Vista Ultimate 64-Bit x64 Edition
|
No
|
WOW643,7
|
WOW643,7
|
WOW643,7
|
WOW643,8
|
WOW643,7
|
|
Windows Vista Business 64-Bit x64 Edition
|
No
|
WOW643,7
|
WOW643,7
|
WOW643,7
|
WOW643,8
|
WOW643,7
|
|
Windows Vista Enterprise 64-Bit x64 Edition
|
No
|
WOW643,7
|
WOW643,7
|
WOW643,7
|
WOW643,8
|
WOW643,7
|
|
Windows Server 2008
Standard
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
|
Windows Server 2008 Enterprise
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
|
Windows Server 2008 Data Center
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
|
Windows Server 2008 Web Edition
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
Yes11
|
|
Windows Server 2008 Standard 64-Bit
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
|
Windows Server 2008 Enterprise 64-Bit
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
|
Windows Server 2008 Data Center 64-Bit
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
|
Windows Server 2008 Web 64-Bit
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
WOW643,11
|
|
Windows Server 2008 Itanium Edition
|
No
|
No
|
No
|
No
|
No
|
No
|
1
SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition, but SQL Server 2005 Enterprise Edition is not supported on all of the operating systems that support Evaluation Edition.
2You can download Windows 2000 SP4 from this Microsoft Web site. Service packs for Windows 2000 Datacenter Edition must be obtained through the original equipment manufacturer (OEM).
3These editions of SQL Server 2005 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.
4You can install Microsoft SQL Server Books Online, client tools and some legacy tools for SQL Server 2005 Enterprise Edition on Windows 2000 Professional SP4, and SP2. Client tools include SQL Server Management Studio, and Business Intelligence Development Studio, SQL Server 2005 software development kit. Legacy tools include the Data Transformation Services Runtime and SQL-DMO.
5
Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS). This includes Windows XP Home Edition, which does not include IIS.
6
SQL Server 2005 support on Windows Server 2003 R2 is the same as support on Windows Server 2003 SP1.
7Requires SQL Server 2005 SP2 on Windows Vista.
8
SQL Server 2005 Express Edition requires SP1 on Windows Vista. SQL Server 2005 Express Edition with Advanced Services requires SP2 on Windows Vista.
9
SQL Server 2005 Express Edition requires SP2 on Windows XP Embedded SP2 Feature Pack 2007. SQL Server 2005 Express Edition with Advanced Services is not supported on Embedded SP2 Feature Pack 2007. For more information, see the Windows XP Embedded Web site or the MSDN Library technical articles.
10
SQL Server 2005 Express Edition requires SP2 on Windows Embedded for Point of Service. SQL Server 2005 Express Edition with Advanced Services is not supported on Windows Embedded for Point of Service. For more information, see the Windows Embedded Web site.
11 Requires SQL Server 2005 SP2 on
The following limitations or issues affect installations on supported operating systems:
-
Native Web Service (SOAP/HTTP) support is only available for instances of SQL Server 2005 running on Windows 2003.
-
Individual topics in Microsoft SQL Server 2005 Integration Services (SSIS) programming, Analysis Management Objects (AMO), and ADOMD.NET documentation may indicate support for earlier versions of Windows, such as Windows 98, Windows ME, or Windows NT 4.0. However, for this release, these three programming interfaces are only supported on Windows XP, Windows 2000, and Windows 2003.
-
SQL Server 2005 failover clusters require Microsoft Cluster Server (MSCS) on at least one node of your server cluster. MSCS is only supported if it is installed on a hardware configuration that has been tested for compatibility with the MSCS software. For more information, see Before Installing Failover Clustering.