Hardware and Software Requirements for Installing SQL Server 2012
The following sections list the minimum hardware and software requirements to install and run SQL Server 2012. For more information about requirements for Analysis Services in SharePoint integrated mode, see Hardware and Software Requirements (PowerPivot for SharePoint and Reporting Services in SharePoint Mode).
For both 32-bit and 64-bit editions of SQL Server 2012, the following apply:
- We recommend that you run SQL Server 2012 on computers with the NTFS file format. Installing SQL Server 2012 on a computer with FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.
- SQL Server Setup will block installations on read-only, mapped, or compressed drives.
- For information about using SQL Server 2012 tools to prepare for an upgrade to SQL Server 2012, see Use Upgrade Advisor to Prepare for Upgrades.
- To make sure that the Visual Studio component can be installed correctly, SQL Server requires you to install an update. SQL Server Setup checks for the presence of this update and then requires you to download and install the update before you can continue with the SQL Server installation. To avoid the interruption during SQL Server Setup, you can download and install the update before running SQL Server Setup as described below (or install all the updates for .NET 3.5 SP1 available on Windows Update):
- If you install SQL Server 2012 on a computer with the Windows Vista SP2 or Windows Server 2008 SP2 operating system, you can get the required update from here.
- If you install SQL Server 2012 on a computer with the Windows 7 SP1 or Windows server 2008 R2 SP1 operating system, this update is included.
- The installation of SQL Server 2012 fails if you launch the setup through Terminal Services Client. Launching SQL Server Setup through Terminal Services Client is not supported.
![clip_image001[16]](http://gunnalag.files.wordpress.com/2012/05/clip_image00116.gif "clip_image001[16]"){kind=small}
Hardware and Software Requirements
The following requirements apply to all SQL Server 2012 installations:
|
Component |
Requirement |
||
|
Framework1 |
.NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Replication, Master Data Services, Data Quality Services, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step. SQL Server Express does not install .NET 4.0 on the Server Core mode of Windows Server 2008 R2 SP1. You must install .NET 4.0 before you install SQL Server Express on a Server Core installation of Windows Server 2008 R2 SP1. SQL Server Setup installs the following software components required by the product:
|
||
|
Windows PowerShell |
SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio. If Setup reports that Windows PowerShell 2.0 is not present, you can install or enable it by following the instructions on the Windows Management Framework page. |
||
|
Network Software |
Supported operating systems for SQL Server 2012 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols:
For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries. |
||
|
Virtualization |
SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions, and Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions. 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 2012 instance. Requirements are listed later in this topic.2 Within the Hyper-V role on Windows Server 2008 SP2 and Windows Server 2008 R2 SP1, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 or Windows Server 2008 R2 SP1 32-bit or 64-bit editions. For more information on compute capacity limits for different editions of SQL Server 2012 and how they differ in physical and virtualized environments with hyperthreaded processors, see Compute Capacity Limits by Edition of SQL Server. Notes:
|
||
|
Internet Software |
Internet Explorer 7 or a later version is required for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help. |
||
|
Hard Disk |
SQL Server 2012 requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server 2012 components you install. For more information, see Hard Disk Space Requirements (32-Bit and 64 Bit) later in this topic. For information on supported storage types for data files, see Storage Types for Data Files. |
||
|
Drive |
A DVD drive, as appropriate, is required for installation from disc. |
||
|
Monitor |
SQL Server 2012 requires Super-VGA (800×600) or higher resolution monitor. |
||
|
Internet |
Internet functionality requires Internet access (fees may apply). |
![clip_image002[34]](http://gunnalag.files.wordpress.com/2012/05/clip_image00234.gif "clip_image002[34]"){kind=small}
1If you are installing the SQL Server Express editions, ensure that an Internet connection is available on the computer. SQL Server Setup downloads and installs the .NET Framework 4 because it is not included in the SQL Server Express media. SQL Server Setup will download.NET Framework 4 to complete the installation of the prerequisites.
2Running SQL Server 2012 on a virtual machine will be slower than running natively because of the overhead of virtualization.
![clip_image001[17]](http://gunnalag.files.wordpress.com/2012/05/clip_image00117.gif "clip_image001[17]"){kind=small}
Processor, Memory, and Operating System Requirements
The following memory and processor requirements apply to all editions of SQL Server 2012:
|
Component |
Requirement |
|
Memory[1] |
Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. |
|
Processor Speed |
Minimum:
Recommended: 2.0 GHz or faster |
|
Processor Type |
|
[1]The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server 2012 minimum memory requirement. For information about installing DQS, see Install Data Quality Services.
WOW64 Support:
WOW64 (Windows 32-bit on Windows 64-bit) is 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 a 64-bit operating system.
- On a supported 64-bit operating system, SQL Server 32-bit edition can be installed to the WOW64 32-bit subsystem of a 64-bit server. 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 supported 64-bit operating systems, Management Tools are supported in WOW64. For more information about supported operating systems, select an edition of SQL Server 2012 from the sections below.
Server Core Support:
SQL Server 2012 is now supported on a Server Core installation of Windows Server 2008 R2. Installing SQL Server 2012 is supported on the Server Core mode of the following Windows Server 2008 R2 editions:
- Windows Server 2008 R2 SP1 64-bit x64 Datacenter
- Windows Server 2008 R2 SP1 64-bit x64 Enterprise
- Windows Server 2008 R2 SP1 64-bit x64 Standard
- Windows Server 2008 R2 SP1 64-bit x64 Web
For more information on installing SQL Server 2012 on Server Core, see Install SQL Server 2012 on Server Core.
|
|
|
SQL Server editions that are supported on Windows Server 2008 R2 64-bit x64 Standard edition are also supported on Windows Small Business Server |
![clip_image002[35]](http://gunnalag.files.wordpress.com/2012/05/clip_image00235.gif "clip_image002[35]"){kind=small}
Operating System Support:
The SQL Server 2012 editions are classified into the following:
- Principal Editions of SQL Server 2012
- Specialized Editions of SQL Server 2012
- Breadth Editions of SQL Server 2012
Principal Editions of SQL Server 2012
The following table shows the operating system requirements for the principal editions of SQL Server 2012:
|
SQL Server Edition |
32-bit |
64-bit |
|
SQL Server Enterprise |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web |
|
SQL Server Business Intelligence |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web |
|
SQL Server Standard |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 32-bit Ultimate Windows 7 SP1 32-bit Enterprise Windows 7 SP1 32-bit Professional Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 32-bit Ultimate Windows Vista SP2 32-bit Enterprise Windows Vista SP2 32-bit Business |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business |
Specialized Editions of SQL Server SQL Server 2012
The following table shows the operating system requirements for the specialized editions of SQL Server 2012:
|
SQL Server Edition |
32-bit |
64-bit |
|
SQL Server Web |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web |
Breadth Editions of SQL Server 2012
The following table shows the operating system requirements for the breadth editions of SQL Server 2012:
|
SQL Server Edition |
32-bit |
64-bit |
|
SQL Server Developer |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64 Standard Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 64-bit Home Premium Windows 7 SP1 64-bit Home Basic Windows 7 SP1 32-bit Ultimate Windows 7 SP1 32-bit Enterprise Windows 7 SP1 32-bit Professional Windows 7 SP1 32-bit Home Premium Windows 7 SP1 32-bit Home Basic Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 64-bit Home Premium Windows Vista SP2 64-bit Home Basic Windows Vista SP2 32-bit Ultimate Windows Vista SP2 32-bit Enterprise Windows Vista SP2 32-bit Business Windows Vista SP2 32-bit Home Premium Windows Vista SP2 32-bit Home Basic |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 64-bit Home Premium Windows 7 SP1 64-bit Home Basic Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 64-bit Home Premium Windows Vista SP2 64-bit Home Basic |
|
SQL Server Express |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 64-bit Home Premium Windows 7 SP1 64-bit Home Basic Windows 7 SP1 32-bit Ultimate Windows 7 SP1 32-bit Enterprise Windows 7 SP1 32-bit Professional Windows 7 SP1 32-bit Home Premium Windows 7 SP1 32-bit Home Basic Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 64-bit Home Premium Windows Vista SP2 64-bit Home Basic Windows Vista SP2 32-bit Ultimate Windows Vista SP2 32-bit Enterprise Windows Vista SP2 32-bit Business Windows Vista SP2 32-bit Home Premium Windows Vista SP2 32-bit Home Basic |
Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 64-bit Home Premium Windows 7 SP1 64-bit Home Basic Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 64-bit Home Premium Windows Vista SP2 64-bit Home Basic |
![clip_image001[18]](http://gunnalag.files.wordpress.com/2012/05/clip_image00118.gif "clip_image001[18]"){kind=small}
Cross-Language SupportFor more information about cross-language support and considerations for installing SQL Server in localized languages, see Local Language Versions in SQL Server.
![clip_image001[19]](http://gunnalag.files.wordpress.com/2012/05/clip_image00119.gif "clip_image001[19]"){kind=small}
Extended System SupportSQL Server 2012 64-bit versions include support for extended systems, also known as Windows 32-bit on Windows 64-bit (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 64-bit.
![clip_image001[20]](http://gunnalag.files.wordpress.com/2012/05/clip_image00120.gif "clip_image001[20]"){kind=small}
Hard Disk Space Requirements (32-Bit and 64 Bi
t)
During installation of SQL Server 2012, 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 6.0 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. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2012.The following table provides disk space requirements for SQL Server 2012 components.
|
Feature |
Disk space requirement |
|
Database Engine and data files, Replication, Full-Text Search, and Data Quality Services |
811 MB |
|
Analysis Services and data files |
345 MB |
|
Reporting Services and Report Manager |
304 MB |
|
Integration Services |
591 MB |
|
Master Data Services |
243 MB |
|
Client Components (other than SQL Server Books Online components and Integration Services tools) |
1823 MB |
|
SQL Server Books Online Components to view and manage help content1 |
375 KB |
1The disk space requirement for downloaded BOL content is 200 MB.
![clip_image001[21]](http://gunnalag.files.wordpress.com/2012/05/clip_image001211.gif "clip_image001[21]"){kind=small}
Storage Types for Data FilesThe supported storage types for data files are:
- Local Disk
- Shared Storage
- SMB File Share
![clip_image003[1]](http://gunnalag.files.wordpress.com/2012/05/clip_image0031.gif "clip_image003[1]"){kind=small} Important |
|
SMB storage can be hosted by a Windows File Server or a third party SMB storage device. If Windows File Server is used, the Windows File Server version should be 2008 or later. For more information about installing SQL Server using SMB file share as a storage option, see Install SQL Server with SMB fileshare as a storage option. |
|
|
|
SQL Server failover cluster installation supports Local Disk only for installing the tempdb files. Ensure that the path specified for the tempdb data and log files is valid on all the cluster nodes. During failover, if the tempdb directories are not available on the failover target node, the SQL Server resource will fail to come online. |
![clip_image003[2]](http://gunnalag.files.wordpress.com/2012/05/clip_image0032.gif "clip_image003[2]"){kind=small}
![clip_image001[22]](http://gunnalag.files.wordpress.com/2012/05/clip_image00122.gif "clip_image001[22]"){kind=small}
Installing SQL Server on a Domain Controller
For security reasons, we recommend that you do not install SQL Server 2012 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:
- You cannot run SQL Server services on a domain controller under a local 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.
![clip_image001[23]](http://gunnalag.files.wordpress.com/2012/05/clip_image00123.gif "clip_image001[23]"){kind=small}
See AlsoConcepts
Planning a SQL Server Installation
Security Considerations for a SQL Server Installation
Other Resources
Product Specifications for SQL Server 2012
Top of Form
<
p>Source: Hardware and Software Requirements for Installing SQL Server 2012
