hardware-and-software-requirements-for-installing-sql-server.md

title	SQL Server 2014: Hardware & Software Requirements
ms.custom
ms.date	07/10/2018
ms.prod	sql-server-2014
ms.reviewer
ms.technology	install
ms.topic	conceptual
helpviewer_keywords	Setup [SQL Server], software software [SQL Server] installing SQL Server, software operating systems [SQL Server], SQL Server requirements Setup [SQL Server], cross-language support operating systems [SQL Server], cross-language support network connections [SQL Server], requirements disk space [SQL Server], SQL Server installations WOW [SQL Server] Setup [SQL Server], hardware dependencies [SQL Server], SQL Server installations cluster hardware requirements [SQL Server] endpoints [SQL Server], SQL Server installations Internet [SQL Server], SQL Server installations hardware [SQL Server] Windows on Windows [SQL Server] installing SQL Server, hardware Setup Configuration Checker SCC [SQL Server] operating systems [SQL Server] space [SQL Server], SQL Server installations system configuration checker installing SQL Server, cross-language support Internet [SQL Server] space [SQL Server] extended system support [SQL Server] 64-bit edition [SQL Server] failover clustering [SQL Server] failover clustering [SQL Server], hardware requirements 32-bit edition [SQL Server] locales [SQL Server], SQL Server installations cross-language support disk space [SQL Server] localized SQL Server versions
ms.assetid	09bcf20b-0a40-4131-907f-b61479d5e4d8
author	MashaMSFT
ms.author	mathoma
manager	craigg

SQL Server 2014: Hardware and Software Requirements

• Try SQL Server 2016 by installing the Free Developer edition!

Considerations

• We recommend running [!INCLUDEssCurrent] on computers with the NTFS file format. FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.

• You cannot install on read-only, mapped, or compressed drives.

• To allow the Visual Studio component to install correctly, [!INCLUDEssNoVersion] requires you to install an update. [!INCLUDEssNoVersion] Setup checks for the presence of this update then requires you to download and install that update before you can continue with the [!INCLUDEssNoVersion] installation. To avoid the interruption during [!INCLUDEssNoVersion] Setup, download and install the update before running [!INCLUDEssNoVersion] Setup as described below (or install all the updates for .NET 3.5 SP1 available on Windows Update):

  • For [!INCLUDEfirstref_longhorn] SP2, get the required update here.

  • For any other supported operating system, this update is included.

• Launching [!INCLUDEssNoVersion] Setup through Terminal Services Client is not supported. Installation fails if you launch setup through Terminal Services Client.

• [!INCLUDEssNoVersion] Setup installs the following software components required by the product:

  • [!INCLUDEssNoVersion] Native Client

  • [!INCLUDEssNoVersion] Setup support files

• For minimum version requirements to install [!INCLUDEssNoVersion] on [!INCLUDEwin8srv] or [!INCLUDEwin8], see Installing SQL Server on Windows Server 2012 or Windows 8 (https://support.microsoft.com/kb/2681562).

This topic contains the following sections:

• Hardware and Software Requirements

• Processor, Memory, and Operating System Requirements

• Cross-Language Support

• Extended System Support

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

• Storage Types for Data Files

• Installing SQL Server on a Domain Controller

Hardware and Software Requirements

The table in this section lists the minimum requirements for running SQL Server. There are also recommended configuration options for optimal performance.

The following software requirements apply to all installations:

Component	Requirement
.NET Framework	.NET 3.5 SP1 is a requirement for [!INCLUDEssCurrent] when you select [!INCLUDEssDE], [!INCLUDEssRSnoversion], [!INCLUDEssMDSshort], [!INCLUDEssDQSnoversion], Replication, or [!INCLUDEssManStudioFull], and it is no longer installed by [!INCLUDEssNoVersion] Setup. -If you run Setup and you do not have .NET 3.5 SP1, [!INCLUDEssNoVersion] Setup requires you to download and install .NET 3.5 SP1 before you can continue with the [!INCLUDEssNoVersion] installation. (Install .NET 3.5 SP1 from Microsoft .NET Framework 3.5 Service Pack 1.) The error message includes a link to the download center, or you can download .NET 3.5 SP1 from Windows Update. To avoid interruption during [!INCLUDEssNoVersion] Setup, you can download and install .NET 3.5 SP1 before you run [!INCLUDEssNoVersion] Setup. -If you run Setup on a computer with [!INCLUDEwinserver2008r2] SP1 or [!INCLUDEwin8], you must enable .NET Framework 3.5 SP1 before you install [!INCLUDEssCurrent]. -If there is no internet access, you must download and install .NET Framework 3.5 SP1 before you run Setup to install any of the above mentioned components. For more information about the recommendations and guidance on how to acquire and enable .NET Framework 3.5 on [!INCLUDEwin8] and [!INCLUDEwin8srv], see Microsoft .NET Framework 3.5 Deployment Considerations (https://msdn.microsoft.com/library/windows/hardware/hh975396). .NET 4.0 is a requirement for [!INCLUDEssCurrent]. [!INCLUDEssNoVersion] installs .NET 4.0 during the feature installation step. -If you are installing the [!INCLUDEssExpress] editions, ensure that an Internet connection is available on the computer. [!INCLUDEssNoVersion] Setup downloads and installs the .NET Framework 4 because it is not included in the [!INCLUDEssExpress] media. -[!INCLUDEssExpress] does not install .NET 4.0 on the Server Core mode of [!INCLUDEwinserver2008r2] SP1 or [!INCLUDEwin8srv]. You must install .NET 4.0 before you install [!INCLUDEssExpress] on a Server Core installation of [!INCLUDEwinserver2008r2] SP1 or [!INCLUDEwin8srv].
Windows PowerShell	[!INCLUDEssCurrent] does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for [!INCLUDEssDE] components and [!INCLUDEssManStudioFull]. 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 [!INCLUDEssCurrent] have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA. Note: VIA protocol is not supported on failover clusters. Clients or applications running on the same node of the failover cluster as the SQL Server instance, can use Shared Memory protocol to connect to SQL Server using its local pipe address. However this type of connection is not cluster-aware and will fail after an instance failover. It is therefore not recommended and should only be used in very specific scenarios. The VIA protocol is deprecated. [!INCLUDEssNoteDepFutureAvoid] For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.
Virtualization	[!INCLUDEssCurrent] is supported in virtual machine environments running on the Hyper-V role in: - [!INCLUDEnextref_longhorn] SP2 Standard, Enterprise and Datacenter editions -[!INCLUDEwinserver2008r2] SP1 Standard, Enterprise, and Datacenter editions. - [!INCLUDEwin8srv] Datacenter and Standard 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 [!INCLUDEssCurrent] instance. Requirements are listed later in this topic.* Within the Hyper-V role on [!INCLUDEnextref_longhorn] SP2 or [!INCLUDEwinserver2008r2] SP1, a maximum of 4 (four) virtual processors can be allocated to virtual machines running [!INCLUDEnextref_longhorn] SP2 32-bit/64-bit or [!INCLUDEwinserver2008r2] SP1 64-bit or [!INCLUDEwin8srv] 64-bit editions. Within the Hyper-V role on [!INCLUDEwin8srv]: A maximum of 8 (eight) virtual processors can be allocated to virtual machines running [!INCLUDEnextref_longhorn] SP2 32-bit/64-bit. A maximum of 64 (sixty-four) virtual processors can be allocated to virtual machines running [!INCLUDEwinserver2008r2] SP1 64-bit or [!INCLUDEwin8srv] 64-bit editions. For more information on compute capacity limits for different editions of [!INCLUDEssCurrent] and how they differ in physical and virtualized environments with hyperthreaded processors, see Compute Capacity Limits by Edition of SQL Server. For more information about the Hyper-V role, see the Windows Server 2008 Web site. ** Important ** Guest failover clustering is supported in [!INCLUDEssCurrent]. For more information about the supported versions of [!INCLUDEssNoVersion] 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.
Hard Disk	[!INCLUDEssCurrent] requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the [!INCLUDEssCurrent] 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	[!INCLUDEssCurrent] requires Super-VGA (800x600) or higher resolution monitor.
Internet	Internet functionality requires Internet access (fees may apply).

*Running [!INCLUDEssCurrent] on a virtual machine will be slower than running natively because of the overhead of virtualization.

Processor, Memory, and Operating System Requirements

The following memory and processor requirements apply to all editions of [!INCLUDEssCurrent]:

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: x86 Processor: 1.0 GHz x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster
Processor Type	x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support x86 Processor: Pentium III-compatible processor or faster

^[1]The minimum memory required for installing the [!INCLUDEssDQSServer] component in [!INCLUDEssDQSnoversion] (DQS) is 2 GB of RAM, which is different from the [!INCLUDEssCurrent] 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, [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion]. WOW64 is not supported for [!INCLUDEssNoVersion] failover cluster installations.

• For [!INCLUDEssNoVersion] 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 [!INCLUDEssCurrent] from the sections below.

Server Core Support:

[!INCLUDEssCurrent] is now supported on a Server Core installation of Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, and Windows Server 2019.

Installing [!INCLUDEssCurrent] on Server Core mode is supported by the following editions of Windows Server:

Windows Server 2019 Standard	Windows Server 2019 Datacenter
Windows Server 2016 Standard	Windows Server 2016 Datacenter
Windows Server 2012 R2 Standard	Windows Server 2012 R2 Datacenter
Windows Server 2012 Standard	Windows Server 2012 Datacenter
Windows Server 2008 R2 SP1 Standard	Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise	Windows Server 2008 R2 SP1 Web

For more information on installing [!INCLUDEssCurrent] on Server Core, see Install SQL Server 2014 on Server Core.

Note

[!INCLUDEssNoVersion] editions that are supported on [!INCLUDEwinserver2008r2] 64-bit x64 Standard edition are also supported on [!INCLUDEsbs_2] 64-bit x64.

Operating System Support:

The [!INCLUDEssCurrent] editions are classified into the following:

• Principal Editions of SQL Server 2014

• Specialized Editions of SQL Server 2014

• Breadth Editions of SQL Server 2014

Principal Editions Operating Systems requirements

The following table shows the operating system requirements for the principal editions of [!INCLUDEssCurrent]:

[!INCLUDEssNoVersion] Edition	32-bit	64-bit
[!INCLUDEssEnterprise]	[!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	[!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit
[!INCLUDEssNoVersion] Business Intelligence	[!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	[!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit
[!INCLUDEssStandard]	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit Windows 10 Home 32-bit Windows 10 Professional 32-bit Windows 10 Enterprise 32-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 32-bit [!INCLUDEwinblue_client_pro_2] 32-bit [!INCLUDEwinblue_client_ent_2] 32-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 32-bit [!INCLUDEwin8_client_pro_2] 32-bit [!INCLUDEwin8_client_ent_2] 32-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEwin7] SP1 Ultimate 32-bit [!INCLUDEwin7] SP1 Enterprise 32-bit [!INCLUDEwin7] SP1 Professional 32-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Foundation 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Foundation 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit

Specialized Editions Operating System requirements

The following table shows the operating system requirements for the specialized editions of [!INCLUDEssCurrent]:

[!INCLUDEssNoVersion] Edition	32-bit	64-bit
[!INCLUDEssWeb]	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit Windows 10 Home 32-bit Windows 10 Professional 32-bit Windows 10 Enterprise 32-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit

Breadth Editions Operating System requirements

The following table shows the operating system requirements for the breadth editions of [!INCLUDEssCurrent]:

[!INCLUDEssNoVersion] Edition	32-bit	64-bit
[!INCLUDEssDeveloper]	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit Windows 10 Home 32-bit Windows 10 Professional 32-bit Windows 10 Enterprise 32-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 32-bit [!INCLUDEwinblue_client_pro_2] 32-bit [!INCLUDEwinblue_client_ent_2] 32-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 32-bit [!INCLUDEwin8_client_pro_2] 32-bit [!INCLUDEwin8_client_ent_2] 32-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEwin7] SP1 Home Premium 64-bit [!INCLUDEwin7] SP1 Home Basic 64-bit [!INCLUDEwin7] SP1 Ultimate 32-bit [!INCLUDEwin7] SP1 Enterprise 32-bit [!INCLUDEwin7] SP1 Professional 32-bit [!INCLUDEwin7] SP1 Home Premium 32-bit [!INCLUDEwin7] SP1 Home Basic 32-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEwin7] SP1 Home Premium 64-bit [!INCLUDEwin7] SP1 Home Basic 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit
[!INCLUDEssExpress]	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit Windows 10 Home 32-bit Windows 10 Professional 32-bit Windows 10 Enterprise 32-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 32-bit [!INCLUDEwinblue_client_pro_2] 32-bit [!INCLUDEwinblue_client_ent_2] 32-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 32-bit [!INCLUDEwin8_client_pro_2] 32-bit [!INCLUDEwin8_client_ent_2] 32-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEwin7] SP1 Home Premium 64-bit [!INCLUDEwin7] SP1 Home Basic 64-bit [!INCLUDEwin7] SP1 Ultimate 32-bit [!INCLUDEwin7] SP1 Enterprise 32-bit [!INCLUDEwin7] SP1 Professional 32-bit [!INCLUDEwin7] SP1 Home Premium 32-bit [!INCLUDEwin7] SP1 Home Basic 32-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Foundation 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 32-bit [!INCLUDEnextref_longhorn] SP2 Standard 32-bit [!INCLUDEnextref_longhorn] SP2 Web 32-bit	Windows 10 Home 64-bit Windows 10 Professional 64-bit Windows 10 Enterprise 64-bit [!INCLUDEwinserver2019_datacenter_md] [!INCLUDEwinserver2019_standard_md] [!INCLUDEwinserver2016_datacenter_md] [!INCLUDEwinserver2016_standard_md] [!INCLUDEwin8srv] R2 Datacenter 64-bit [!INCLUDEwin8srv] R2 Standard 64-bit [!INCLUDEwin8srv] R2 Essentials 64-bit [!INCLUDEwin8srv] R2 Foundation 64-bit [!INCLUDEwin8srv] Datacenter 64-bit [!INCLUDEwin8srv] Standard 64-bit [!INCLUDEwin8srv] Essentials 64-bit [!INCLUDEwin8srv] Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Datacenter 64-bit [!INCLUDEwinserver2008r2] SP1 Enterprise 64-bit [!INCLUDEwinserver2008r2] SP1 Standard 64-bit [!INCLUDEwinserver2008r2] SP1 Foundation 64-bit [!INCLUDEwinserver2008r2] SP1 Web 64-bit [!INCLUDEwinblue_client_2] 64-bit [!INCLUDEwinblue_client_pro_2] 64-bit [!INCLUDEwinblue_client_ent_2] 64-bit [!INCLUDEwin8] 64-bit [!INCLUDEwin8_client_pro_2] 64-bit [!INCLUDEwin8_client_ent_2] 64-bit [!INCLUDEwin7] SP1 Ultimate 64-bit [!INCLUDEwin7] SP1 Enterprise 64-bit [!INCLUDEwin7] SP1 Professional 64-bit [!INCLUDEwin7] SP1 Home Premium 64-bit [!INCLUDEwin7] SP1 Home Basic 64-bit [!INCLUDEnextref_longhorn] SP2 Datacenter 64-bit [!INCLUDEnextref_longhorn] SP2 Enterprise 64-bit [!INCLUDEnextref_longhorn] SP2 Standard 64-bit [!INCLUDEnextref_longhorn] SP2 Foundation 64-bit [!INCLUDEnextref_longhorn] SP2 Web 64-bit

Minimum SQL Server version requirements for Windows 10

Before you install SQL Server on a computer that is running Windows 10, you must make sure that you fulfill the following minimum requirements:

• For SQL Server 2014, you must apply SQL Server 2014 Service Pack 1 or a later update. For more information, see How to obtain the latest service pack for SQL Server 2014.

• For SQL Server 2012, you must apply SQL Server 2012 Service Pack 2 or a later update. For more information, see How to obtain the latest service pack for SQL Server 2012.

• SQL Server 2008 R2
  and SQL Server 2008 is not supported on Windows 10.

Cross-Language Support

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

Extended System Support

[!INCLUDEssCurrent] 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.

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

During installation Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade [!INCLUDEssNoVersion], 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 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 supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2014. The following table provides disk space requirements for [!INCLUDEssCurrent] components.

Feature	Disk space requirement
[!INCLUDEssDE] and data files, Replication, Full-Text Search, and Data Quality Services	811 MB
[!INCLUDEssASnoversion] and data files	345 MB
[!INCLUDEssRSnoversion] and Report Manager	304 MB
[!INCLUDEssISnoversion]	591 MB
[!INCLUDEssMDSshort]	243 MB
Client Components (other than [!INCLUDEssNoVersion] Books Online components and Integration Services tools)	1823 MB
[!INCLUDEssNoVersion] Books Online Components to view and manage help content1	375 KB

¹The disk space requirement for downloaded Books Online content is 200 MB.

Storage Types for Data Files

The supported storage types for data files are:

• Local Disk

• Shared Storage

• SMB File Share

  NOTE: SMB storage is not supported for [!INCLUDEssASnoversion] data files for either standalone or clustered installations. Use direct attached storage or a storage area network instead.

  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 [!INCLUDEssNoVersion] using SMB file share as a storage option, see Install SQL Server with SMB Fileshare as a Storage Option.

  WARNING!!!! [!INCLUDEssNoVersion] 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 of the cluster nodes. During failover, if the tempdb directories are not available on the failover target node, the [!INCLUDEssNoVersion] resource will fail to come online.

Installing [!INCLUDEssNoVersion] on a Domain Controller - Limitations

For security reasons, we recommend that you do not install [!INCLUDEssCurrent] on a domain controller. [!INCLUDEssNoVersion] Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

• You cannot run [!INCLUDEssNoVersion] services on a domain controller under a local service account.

• After [!INCLUDEssNoVersion] is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall [!INCLUDEssNoVersion] before you change the host computer to a domain controller.

• After [!INCLUDEssNoVersion] is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall [!INCLUDEssNoVersion] before you change the host computer to a domain member.

• [!INCLUDEssNoVersion] failover cluster instances are not supported where cluster nodes are domain controllers.

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

See Also

Planning a SQL Server Installation
Security Considerations for a SQL Server Installation
Product Specifications for SQL Server 2014