Hardware and Software Requirements for Installing SQL Server 2008 R2

The following sections list the minimum hardware and software requirements to install and run SQL Server 2008 R2. For more information about requirements for Analysis Services in SharePoint integrated mode, see Hardware and Software Requirements (PowerPivot for SharePoint).

For both 32-bit and 64-bit editions of SQL Server 2008 R2, the following apply:

• For minimum version requirements to install SQL Server 2008 R2 on Windows Server 2012 or Windows 8, see Installing SQL Server on Windows Server 2012 or Windows 8 (https://support.microsoft.com/kb/2681562).

• SQL Server 2008 R2 Datacenter is available for evaluation during a 180-day trial period. For more information, see the SQL Server: How to Buy Web site.

• Microsoft recommends that you run SQL Server 2008 R2 on computers with the NTFS file format. For upgrades to SQL Server 2008 R2, FAT32 file systems will not be blocked.

• SQL Server Setup will block installations on read-only or compressed drives.

• For information about using SQL Server 2008 R2 tools to prepare for an upgrade to SQL Server 2008 R2, see Using Upgrade Advisor to Prepare for Upgrades.

• SQL Server does not install the .NET Framework 3.5software development kit (SDK). However, the SDK contains tools that are useful when you use the .NET Framework for SQL Server development. You can download the .NET Framework SDK from the .NET Framework Web site.

• Requirements to restart computers during SQL Server Setup: Installation of the .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until the .NET Framework and Windows Installer components have installed before restarting.

• For more information about features of SQL Server 2008 R2, see the following:

  • Editions and Components of SQL Server 2008 R2

  • Features Supported by the Editions of SQL Server 2008 R2

Hardware and Software Requirements

The following requirements apply to all SQL Server 2008 R2 installations:

Component	Requirement
Framework2	SQL Server Setup installs the following software components required by the product: .NET Framework 3.5 SP11 SQL Server Native Client SQL Server Setup support files
Software2	SQL Server Setup requires Microsoft Windows Installer 4.5 or a later version After installing required components, SQL Server Setup will verify that the computer where SQL Server 2008 R2 will be installed also meets all the other requirements for a successful installation. For more information, see Check Parameters for the System Configuration Checker.
Network Software	Network software requirements for the 64-bit versions of SQL Server 2008 R2 are the same as the requirements for the 32-bit versions. Supported operating systems have built-in network software. Stand-alone named and default instances support the following network protocols: Shared memory Named Pipes TCP/IP VIA Note   Shared memory and VIA are not supported on failover clusters. Note The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Virtualization	SQL Server 2008 R2 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions. The virtual machine must run an operating system supported for the specific SQL Server 2008 R2 edition listed later in this topic. In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2008 R2 instance. Requirements are listed later in this topic.3 Within the Hyper-V role on Windows Server 2008 SP2, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit or 64-bit editions. A maximum of 2 virtual processors can be allocated to virtual computers that are running Windows Server 2003 32-bit editions. For virtual computers that host other operating systems, a maximum of one virtual processor can be allocated to virtual computers. For more information about the Hyper-V role in Windows Server 2008 SP2, see the Windows Server 2008 Web site. Note Guest failover clustering is supported in SQL Server 2008 R2. For more information about the supported versions of SQL Server and operating systems for guest failover clustering, and the support for virtualization, see Support policy for Microsoft SQL Server products running in a hardware virtual environment.
Internet Software	Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server 2008 R2. Internet Explorer 6 SP1 or a later version is required for Microsoft Management Console (MMC), SQL Server Management Studio, Business Intelligence Development Studio, the Report Designer component of Reporting Services, and HTML Help.
Hard Disk	Disk space requirements will vary with the SQL Server 2008 R2 components you install. For more information, see Hard disk space requirements later in this topic.
Drive	A CD or DVD drive, as appropriate, is required for installation from disc.
Display	SQL Server 2008 R2 graphical tools require Super VGA or higher resolution: at least 800x600 pixel resolution.
Other Devices	Pointing device: A Microsoft mouse or compatible pointing device is required.

1The following .NET Framework versions are required:

• SQL Server 2008 R2 on Windows Server 2003 (64-bit) IA64 — .NET Framework 2.0 SP2

• SQL Server Express — .NET Framework 2.0 SP2

• All other editions of SQL Server 2008 R2 — .NET Framework 3.5 SP1

Installation of .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until .NET Framework and Windows Installer components have installed before restarting.

Note

Installing .NET Framework 2.0 SP2: .NET Framework 2.0 SP2 is not available as a separate download. You will need to install .NET Framework 3.5 SP1 which includes .NET Framework 2.0 SP2.

2SQL Server Setup will not install the following required components for SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup:

• SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista SP2, use .NET Framework 3.5 SP1.

• SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

• SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

3As with all virtualization technologies, SQL Server 2008 R2 running in a Windows Server 2008 SP2 Hyper-V virtual computer will be slower than on a physical computer with the same physical resources.

Processor, Memory, and Operating System Requirements

• Reporting Services

  Starting in SQL Server 2008 R2, the Reporting Services component no longer supports Itanium-based servers running Windows Server 2003 or Windows Server 2003 R2. Reporting Services continues to support other 64-bit operating systems, including Windows Server°2008 for Itanium-Based Systems and Windows Server°2008°R2 for Itanium-Based Systems. To upgrade to SQL Server 2008 R2 from a SQL Server 2008 installation with Reporting Services on an Itanium-based system edition of Windows Server 2003 or Windows Server 2003 R2, you must first upgrade the operating system.

• WOW64

  WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is running on the 64-bit operating system. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations

  For SQL Server 64-bit Edition installations on 64-bit supported operating systems, Management Tools are supported in WOW64. For more information about supported operating systems, select an edition of SQL Server 2008 R2 from the sections below.

  On a supported 64-bit operating system, SQL Server 32-bit Edition installations can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

• Other operating system notes

  SQL Server 2008 R2 is not supported on Windows Server 2008 SP2 Server Core or Windows Server 2008 R2 Server Core installations.

  Operating systems listed in the SQL Server Standard sections are also supported for SQL Server Standard for Small Business

  SQL Server editions that are supported on Windows Server 2008 R2 64-bit x64 Standard are also supported on Windows Small Business Server 64-bit x64.

To view system requirements, select an edition of SQL Server 2008 R2 in the sections below.

Core Server Editions of SQL Server 2008 R2

• SQL Server 2008 R2 Datacenter (64-bit) IA64

• SQL Server 2008 R2 Enterprise (64-bit) IA64

• SQL Server 2008 R2 Datacenter (64-bit) x64

• SQL Server 2008 R2 Enterprise (64-bit) x64

• SQL Server 2008 R2 Standard (64-bit) x64

• SQL Server 2008 R2 Datacenter (32-bit)

• SQL Server 2008 R2 Enterprise (32-bit)

• SQL Server 2008 R2 Standard (32-bit)

Specialized Editions of SQL Server 2008 R2

• SQL Server 2008 R2 Developer (64-bit) IA64

• SQL Server 2008 R2 Developer (64-bit) x64

• SQL Server 2008 R2 Workgroup (64-bit) x64

• SQL Server 2008 R2 Web (64-bit) x64

• SQL Server 2008 R2 Express (64-bit) x64

• SQL Server 2008 R2 Express with Tools (64-bit) x64

• SQL Server 2008 R2 Express Advanced (64-bit) x64

• SQL Server 2008 R2 Developer (32-bit)

• SQL Server 2008 R2 Workgroup (32-bit)

• SQL Server 2008 R2 Web (32-bit)

• SQL Server 2008 R2 Express, Express with Tools, and Express with Advanced Services (32-bit)

Additional information in this topic

• Hard disk space requirements

• Cross language support

• Support for installing SQL Server 2008 R2 on a domain controller

Core Server Editions (64-bit and 32-bit)

SQL Server 2008 R2 Datacenter (64-bit) IA64

The following table shows system requirements for SQL Server 2008 R2 Datacenter (64-bit) IA64.

Component	Requirement
Processor	Processor type: Itanium processor or faster Processor speed: Recommended: 1.0 GHz or faster
Operating system	Windows Server 2008 R2 64-bit Itanium Windows Server 2008 SP2 64-bit Itanium Windows Server 2003 SP2 64-bit Itanium Datacenter Windows Server 2003 SP2 64-bit Itanium Enterprise Windows Server 2003 R2 SP2 64-bit Itanium Datacenter Windows Server 2003 R2 SP2 64-bit Itanium Enterprise Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server 2008 R2 Enterprise (64-bit) IA64

The following table shows system requirements for SQL Server 2008 R2 Enterprise (64-bit) IA64. Note that this edition of SQL Server 2008 R2 is not available in the following localized versions: Italian, Spanish, Portuguese (Brazil), or Russian.

Component	Requirement
Processor	Processor type: Itanium processor or faster Processor speed: Recommended: 1.0 GHz or faster
Operating system	Windows Server 2008 R2 64-bit Itanium Windows Server 2008 SP2 64-bit Itanium Windows Server 2003 SP2 64-bit Itanium Datacenter Windows Server 2003 SP2 64-bit Itanium Enterprise Windows Server 2003 R2 SP2 64-bit Itanium Datacenter Windows Server 2003 R2 SP2 64-bit Itanium Enterprise Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more 2 TB (SQL Server Enterprise Edition supports a maximum of 2 TB of RAM or operating system maximum, whichever is lower).

SQL Server 2008 R2 Datacenter (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Datacenter (64-bit) x64.

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Datacenter  Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise, Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows Server 2008 x64 for Windows Essential Server Solutions Windows 2008 R2 64-bit x64 Datacenter Windows 2008 R2 64-bit x64 Enterprise Windows 2008 R2 64-bit x64 Standard Windows 2008 R2 64-bit x64 Web Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum:1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server 2008 R2 Enterprise (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Enterprise (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003  SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise,  Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows 2008 R2 64-bit x64 Datacenter Windows 2008 R2 64-bit x64 Enterprise Windows 2008 R2 64-bit x64 Standard Windows 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum:1 GB Recommended: 4 GB or more 2 TB ( SQL Server Enterprise Edition supports a maximum of 2 TB of RAM or operating system maximum, whichever is lower).

SQL Server 2008 R2 Standard (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Standard (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system2	Windows XP Professional SP2 x64 Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 x64 Datacenter, Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise, Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard, Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 SP2 for Windows Essential Server Solutions2 Windows Server 2008 SP2 x64 Foundation Server Windows 7 x64 Ultimate Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:1 GB Recommended: 4 GB or more Maximum: 64 GB

SQL Server 2008 R2 Datacenter (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Datacenter (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Windows Server 2008 SP2 Standard without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 x64 Datacenter Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server 2008 R2 Enterprise (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Enterprise (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Windows Server 2008 SP2 Standard without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 x64 Datacenter Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows 2008 R2 64-bit x64 Datacenter Windows 2008 R2 64-bit x64 Enterprise Windows 2008 R2 64-bit x64 Standard Windows 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more 2 TB ( SQL Server Enterprise Edition supports a maximum of 2 TB of RAM or operating system maximum, whichever is lower).

SQL Server 2008 R2 Standard (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Standard (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP Professional SP3 Windows XP SP3 Tablet Windows XP SP2 x64 Professional Windows XP SP3 Media Center 2002 Windows XP SP3 Media Center 2004 Windows XP SP3 Media Center 2005 Windows XP Professional SP3 Reduced Media Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate Windows Vista SP2 Enterprise Windows Vista SP2 Business Windows Vista SP2 Ultimate x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Server Windows Server 2008 SP2 Standard Server without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 x64 Datacenter Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 SP2 for Windows Essential Server Solutions Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 SP2 x64 Foundation Server Windows 7 Ultimate Windows 7 Enterprise Windows 7 Professional Windows 7 x64 Ultimate Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 64-bit Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 32-bit Windows 8 Professional 32-bit Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 32-bit Windows 8.1 Professional 32-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: 64 GB

Specialized Editions (64-bit and 32-bit)

SQL Server 2008 R2 Developer (64-bit) IA64

The following table shows system requirements for SQL Server 2008 R2 Developer (64-bit) IA64. Note that this edition of SQL Server 2008 R2 is not available in the following localized versions: Italian, Spanish, Portuguese (Brazil), or Russian.

Component	Requirement
Processor	Processor type: Minimum: Itanium processor or faster Processor speed: Minimum: 1.0 GHz or faster
Operating system	Windows Server 2003 SP2 64-bit Itanium Datacenter Windows Server 2003 SP2 64-bit Itanium Enterprise Windows Server 2003 R2 SP2 64-bit Itanium Datacenter Windows Server 2003 R2 SP2 64-bit Itanium Enterprise Windows Server 2008 SP2 64-bit Itanium Datacenter Windows Server 2008 R2 64-bit Itanium Enterprise
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server 2008 R2 Developer (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Developer (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP SP2 x64 Professional Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit DataCenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server 2008 R2 Workgroup (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Workgroup (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP SP2 x64 Professional Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 SP2 x64 Foundation Server Windows 7 x64 Ultimate Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:1 GB Recommended: 4 GB Maximum: 4 GB

SQL Server 2008 R2 Web (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Web (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Server 2008 SP2 x64 Datacenter Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise, Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard, Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64- bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation
Memory	RAM: Minimum:1 GB Recommended: 4 GB or more Maximum: 64 GB for the Database Engine, 4 GB for Reporting Services

SQL Server 2008 R2 Express with Tools (64-bit) x64

The following table shows the system requirements for SQL Server 2008 R2 Express with Tools (64-bit) x64.

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 x64 Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate x64 Windows Vista SP2 Home Premium x64 Windows Vista SP2 Home Basic x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows Server 2008 SP2 64-bit x64 Foundation Server Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:512 MB Recommended: 1 GB Maximum: 1 GB for the Database Engine.

SQL Server 2008 R2 Express with Advanced Services (64-bit) x64

The following table shows system requirements for SQL Server 2008 R2 Express with Advanced Services (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 x64 Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate x64 Windows Vista SP2 Home Premium x64 Windows Vista SP2 Home Basic x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows Server 2008 SP2 64-bit x64 Foundation Server Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:512 MB Recommended: 1 GB Maximum: 1 GB for the Database Engine, 4 GB for Reporting Services

SQL Server Developer (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Developer (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP Home Edition SP3  Windows XP Professional SP3  Windows XP Tablet SP3 Windows XP Professional x64 SP2 Windows XP SP3 Media Center 2002 Windows XP SP3 Media Center 2004 Windows XP SP3 Media Center 2005 Windows XP Professional SP3 Reduced Media Windows XP Home Edition SP3 Reduced Media Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate Windows Vista SP2 Home Premium Windows Vista SP2 Home Basic Windows Vista SP2 Enterprise Windows Vista SP2 Business Windows Vista SP2 Ultimate 64-bit x64 Windows Vista SP2 Home Premium 64-bit x64 Windows Vista SP2 Home Basic 64-bit x64 Windows Vista SP2 Enterprise 64-bit x64 Windows Vista SP2 Business 64-bit x64 Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Windows Server 2008 SP2 Standard without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows 7 Ultimate Windows 7 Home Premium Windows 7 Home Basic Windows 7 Enterprise Windows 7 Professional Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8 32-bit Windows 8 Professional 32-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit Windows 8.1 32-bit Windows 8.1 Professional 32-bit
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: Operating system maximum

SQL Server Workgroup (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Workgroup (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP Professional SP3 Windows XP SP3 Tablet Windows XP Professional SP2 64-bit x64 Windows XP SP3 Media Center 2002 Windows XP SP3 Media Center 2004 Windows XP SP3 Media Center 2005 Windows XP Professional SP3 Reduced Media Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 64-bit x64 Datacenter Windows Server 2003 64-bit x64 Enterprise Windows Server 2003 64-bit x64 Standard Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 64-bit x64 Datacenter Windows Server 2003 R2 64-bit x64 Enterprise Windows Server 2003 R2 64-bit x64 Standard Windows Vista SP2 Vista Ultimate Windows Vista SP2 Enterprise Windows Vista SP2 Business Windows Vista SP2 64-bit x64 Ultimate Windows Vista SP2 64-bit x64 Enterprise Windows Vista SP2 64-bit x64 Business Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Windows Server 2008 SP2 Standard without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows Server 2008 SP2 x64 Foundation Server Windows 7 Ultimate Windows 7 Enterprise Windows 7 Professional Windows 7 64-bit x64 Ultimate Windows 7 64-bit x64 Enterprise Windows 7 64-bit x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 32-bit Windows 8 Professional 32-bit Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 32-bit Windows 8.1 Professional 32-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: Operating system maximum for the Database Engine, 4 GB for Reporting Services

SQL Server Web (32-bit)

The following table shows the system requirements for SQL Server 2008 R2 Web (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Server Windows Server 2008 SP2 Standard Server without Hyper-V Windows Server 2008 SP2 Web Windows Server 2008 SP2 x64 Datacenter Windows Server 2008 SP2 x64 Datacenter without Hyper-V Windows Server 2008 SP2 x64 Enterprise Windows Server 2008 SP2 x64 Enterprise without Hyper-V Windows Server 2008 SP2 x64 Standard Windows Server 2008 SP2 x64 Standard without Hyper-V Windows Server 2008 SP2 x64 Web Windows 2008 R2 64-bit x64 Datacenter Windows 2008 R2 64-bit x64 Enterprise Windows 2008 R2 64-bit x64 Standard Windows 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 32-bit Windows 8 Professional 32-bit Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 32-bit Windows 8.1 Professional 32-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum: 1 GB Recommended: 4 GB or more Maximum: 64 GB for the Database Engine, 4 GB for Reporting Services

SQL Server Express (32-bit), Express with Tools, and Express with Advanced Services (32-bit)

The following table shows the system requirements for SQL Server Express (32-bit), SQL Server Express with Tools, and SQL Server Express with Advanced Services (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating system	Windows XP SP3 Home Windows XP SP3 Professional Windows XP SP3 Tablet Windows XP SP3 Media Center 2002 Windows XP SP3 Media Center 2004 Windows XP SP3 Media Center 2005 Windows XP Professional SP3 Reduced Media Windows XP Home Edition SP3 Reduced Media Windows Server 2003 SP2 Datacenter Windows Server 2003 2003 SP2 Enterprise Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Web Edition Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 R2 SP2 Datacenter Windows Server 2003 R2 SP2 Enterprise Windows Server 2003 R2 SP2 Standard Windows Server 2003 R2 SP2 Web Edition Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate Windows Vista SP2 Home Premium Windows Vista SP2 Home Basic Windows Vista SP2 Enterprise Windows Vista SP2 Business Windows Vista SP2 Ultimate 64-bit x643 Windows Vista SP2 Home Premium 64-bit x643 Windows Vista SP2 Home Basic 64-bit x643 Windows Vista SP2 Enterprise 64-bit x643 Windows Vista SP2 Business 64-bit x643 Windows Server 2008 SP2 Datacenter Windows Server 2008 SP2 Datacenter without Hyper-V Windows Server 2008 SP2 Enterprise Windows Server 2008 SP2 Enterprise without Hyper-V Windows Server 2008 SP2 Standard Server Windows Server 2008 SP2 Standard Server without Hyper-V Windows Server 2008 SP2 Web Edition Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Edition Windows Server 2008 SP2 x64 Foundation Server Windows XP Embedded SP3 feature pack 20072 Windows Embedded for Point of Service SP32 Windows 7 Ultimate Windows 7 Home Premium Windows 7 Home Basic Windows 7 Enterprise Windows 7 Professional Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 32-bit Windows 8 Professional 32-bit Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 32-bit Windows 8.1 Professional 32-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum: 256 MB for SQL Server Express Minimum: 512 MB for SQL Server Express with Tools, and SQL Server Express with Advanced Services Recommended: 1.024 GB Maximum: 1 GB for the Database Engine that installs with SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services, 4 GB for Reporting Services that installs with SQL Server Express with Advanced Services

2Supports SQL Server 2008 R2 Express, not SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services.

3 with Tools and SQL Server 2008 R2 Express with Advanced Services can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server with this operating system.

Note

SQL Server 2008 R2 support on Windows Server 2003 R2 is the same as support on Windows Server 2003 SP2.

Note

SQL Server 2008 R2 is not supported on Windows Server 2008 SP2 Server Core and Windows Server 2008 R2 Server Core installations.

Note

Install SQL Server 2008 R2SP2 on Windows Server 2012 R2 or Windows 8.1.

SQL Server 2008 R2 Express x64 (64-bit)

The following table shows system requirements for SQL Server 2008 R2 Express x64 (64-bit):

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating system	Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise Windows Server 2003 SP2 64-bit x64 Standard Windows Server 2003 R2 SP2 64-bit x64 Datacenter Windows Server 2003 R2 SP2 64-bit x64 Enterprise Windows Server 2003 R2 SP2 64-bit x64 Standard Windows Vista SP2 Ultimate x64 Windows Vista SP2 Home Premium x64 Windows Vista SP2 Home Basic x64 Windows Vista SP2 Enterprise x64 Windows Vista SP2 Business x64 Windows Server 2008 SP2 64-bit x64 Datacenter Windows Server 2008 SP2 64-bit x64 Datacenter without Hyper-V Windows Server 2008 SP2 64-bit x64 Enterprise Windows Server 2008 SP2 64-bit x64 Enterprise without Hyper-V Windows Server 2008 SP2 64-bit x64 Standard Windows Server 2008 SP2 64-bit x64 Standard without Hyper-V Windows Server 2008 SP2 64-bit x64 Web Windows Server 2008 SP2 x64 Foundation Server Windows 7 x64 Ultimate Windows 7 x64 Home Premium Windows 7 x64 Home Basic Windows 7 x64 Enterprise Windows 7 x64 Professional Windows Server 2008 R2 64-bit x64 Datacenter Windows Server 2008 R2 64-bit x64 Enterprise Windows Server 2008 R2 64-bit x64 Standard Windows Server 2008 R2 64-bit x64 Web Windows Server 2008 R2 x64 for Windows Essential Server Solutions Windows Server 2008 R2 64-bit x64 Foundation Server Windows Server 2012 64-bit Datacenter Windows Server 2012 64-bit Standard Windows Server 2012 64-bit Essentials Windows Server 2012 64-bit Foundation Windows Server 2012 R2 64-bit Datacenter Windows Server 2012 R2 64-bit Standard Windows Server 2012 R2 64-bit Essentials Windows Server 2012 R2 64-bit Foundation Windows 8 64-bit Windows 8 Professional 64-bit Windows 8.1 64-bit Windows 8.1 Professional 64-bit
Memory	RAM: Minimum:256 MB Recommended: 1.024 GB Maximum: 1 GB for the Database Engine

Cross-Language Support

For more information about cross-language support and considerations for installing SQL Server in localized languages, see Local Language Versions in SQL Server.

Extended System Support

SQL Server 2008 R2 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system.

Hard Disk Space Requirements (32-Bit and 64-Bit)

During installation of SQL Server 2008 R2, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 3.6 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

Actual hard disk space requirements depend on your system configuration and the features that you decide to install. The following table provides disk space requirements for SQL Server 2008 R2 components:

Feature	Disk space requirement
Database Engine and data files, Replication, and Full-Text Search	711 MB
Analysis Services and data files	345 MB
Reporting Services and Report Manager	304 MB
Integration Services	591 MB
Client Components (Other than Books Online and Integration Services tools)	1823 MB
SQL Server Books Online	157 MB

Installing SQL Server on a Domain Controller

For security reasons, Microsoft recommends that you do not install SQL Server 2008 R2 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

• On Windows Server 2003, SQL Server services can run under a domain account or a local system account.

• You cannot run SQL Server services on a domain controller under a local service account or a network service account.

• After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.

• After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.

• SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.

• SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

Supported Clients (64-Bit)

SQL Server 2008 R2 64-bit client components can be installed on Windows Server 2003 (64-bit).

Stay Up to Date with SQL Server Install, and Upgrade information For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Reference

Check Parameters for the System Configuration Checker

Editions and Components of SQL Server 2008 R2

Concepts

Planning a SQL Server Installation

Security Considerations for a SQL Server Installation

Quick-Start Installation of SQL Server 2008 R2

SQL Server Management Studio Express

Other Resources

Using SQL Server Management Studio