United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

System Requirements



View the detailed System Requirements for SQL Server 2005

SQL Server 2005 32-bit System Requirements

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 Edition4
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

1 System Configuration Checker (SCC) will block Setup if the requirement for processor type is not met.

2 SCC 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.

3 SCC 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.

SQL Server 2005 64-bit System Requirements

This table shows hardware requirements for installing and running SQL Server 2005 on the 64-bit platform.

SQL Server 2005 (64-bit)

Processor type1

Processor speed2

Memory (RAM)3

SQL Server 2005 Enterprise Edition 4
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition

IA64 minimum: Itanium processor or higher
x64 minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

IA64 minimum: 1 GHz
IA64 recommended: 1 GHz or more
x64 minimum: 1 GHz
x64 recommended: 1 GHz or more

IA64 minimum: 512 MB
IA64 recommended: 1 GB or more
IA64 maximum: 32 TB
Operating system maximum
Minimum:512 MB
x64 recommended: 1 GB or more
x64 maximum: Operating system maximum

1 System Configuration Checker (SCC) will block Setup if the processor type requirement is not met.

2 SCC will warn the user but will not block Setup if the minimum or recommended processor speed check is not met.

3 SCC 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 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition.

SQL Server 2005 Mobile Edition System Requirements

The following table lists the hardware and software requirements for the three SQL Server 2005 Mobile Edition environments: development, client, and server. These environments include up to four systems, running SQL Server, Microsoft Internet Information Services (IIS), a development system, and a Windows Mobile–based device. You can use the same computer for the SQL Server system, the IIS system, and the development system.

Environment

Requirements

Development Environment

  • Microsoft Visual Studio 2005

  • One of the following operating systems: Microsoft Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional, Windows XP Tablet PC Edition, Windows 2000 Professional SP4 or later versions, Windows 2000 Server SP4 or later versions

  • Microsoft Internet Explorer 6.0 or later versions required to access SQL Server Mobile Books Online

  • Microsoft ActiveSync 4.0 or later versions required to debug and deploy applications

Client Environment

  • Any device that runs Microsoft Windows CE 5.0, Microsoft Windows XP Tablet PC Edition, Windows Mobile 2003 Software for Pocket PC, or Windows Mobile 5.0

  • From 2 to 3 megabytes (MB) of available storage space, depending on processor type and components installed

Server Environment

  • Microsoft SQL Server 2000 SP3a or later versions

  • SQL Server 2005: Intel or compatible Pentium 600 megahertz (MHz) or greater processor (recommended processor speed is 1 gigahertz (GHz) or greater), 256 MB RAM minimum (recommended RAM is 512 MB or more), 250 MB hard disk space

  • IIS 5.0 or later versions: Supported on 32-bit Windows Server 2003, 32-bit Windows XP, and Windows 2000 SP4; 120 MB of available disk space on the server

  • Microsoft ActiveSync 4.0 or later versions required when you use Management Studio to manage SQL Server Mobile databases on connected devices

  • Microsoft Internet Explorer 6.0 or later versions

Note: Microsoft Outlook 98 or a later version is required for synchronization of e-mail, calendar, contacts, tasks, and notes to the desktop or portable computer (Outlook 2003 recommended).

SQL Server 2005 on Windows Server 2008 and Windows Vista

In an effort to provide customers with more secure products, Microsoft Windows Server 2008 and Microsoft Windows Vista are supported by SQL Server 2005 Express Edition Service Pack 1 (SP1), and for all other editions will be supported by SQL Server 2005 Service Pack 2 (SP2) or later when it becomes available. Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server 2008 or Windows Vista. Customers running applications with these earlier versions of SQL Server should consider evaluating and upgrading to SQL Server 2005, which was designed to take advantage of the upcoming security and performance enhancements in the operating environment.

Installation Requirements

SQL Server 2005 requires Microsoft SQL Server 2005 Service Pack 2 (SP2) to run on Windows Server 2008 and Windows Vista SP1. You must first install the full release version of SQL Server 2005 before you can apply SP2.
For more information about installing SQL Server Express SP2, see the SQL Server 2005 Express Edition SP2 Readme.

 

Note: SQL Server 2005 Express Edition SP1 can be installed on Windows Vista but has known issues with User Access Control. Service Pack 2 is the recommended patch level for Windows Vista RTM support. SQL Server 2005 Express Edition (SQL Server Express) SP2 can be used to install a new instance of SQL Server Express SP2.
Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a. MSDE), SQL Server 7.0, and SQL Server 6.5 are not supported on Windows Server 2008 or Windows Vista. SQL Server 2005 is not supported on Windows 2008 Server Core. Customers running applications with these earlier versions of SQL Server should consider evaluating and upgrading to SQL Server 2005, which was designed to take advantage of the upcoming security and performance enhancements in the operating environment.

Known Issues

For a list of known issues running SQL Server on Windows Vista, see the SQL Server 2005 SP2 Readme.

Product Details