Hardware and Software Requirements for Installing SQL Server 2014
Hardware and Software Requirements for Installing SQL Server 2014:
The following sections list the minimum hardware and software requirements to install and run SQL Server 2014.
For both 32-bit and 64-bit editions of SQL Server 2014, the following considerations apply:
- We recommend that you run SQL Server 2014 on computers with the NTFS file format. Installing SQL Server 2014 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.
- 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 2014 on Windows Server 2008 SP2, you can get the required update from Microsoft website.
- If you install SQL Server 2014 on a computer with any other supported operating system, this update is included.
- The installation of SQL Server 2014 fails if you launch the setup through Terminal Services Client. Launching SQL Server Setup through Terminal Services Client is not supported.
- SQL Server Setup installs the following software components required by the product:
- SQL Server Native Client
- SQL Server Setup support files
The following requirements apply to all SQL Server 2014 installations:
Component
Requirement
.NET Framework
.NET 3.5 SP1 is a requirement for SQL Server 2014 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
- If you run Setup and you do not have .NET 3.5 SP1, SQL Server Setup requires you to download and install .NET 3.5 SP1 before you can continue with the SQL Server installation. 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 SQL Server Setup, you can download and install .NET 3.5 SP1 before you run SQL Server Setup.
- If you run Setup on a computer with Windows Server 2008 R2 SP1 or Windows 8, you must enable .NET Framework 3.5 SP1 before you install SQL Server 2014.
- 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.
.NET 4.0 is a requirement for SQL Server 2014. SQL Server installs .NET 4.0 during the feature installation step.
- If 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 Express does not install .NET 4.0 on the Server Core mode of Windows Server 2008 R2 SP1 or Windows Server 2012. You must install .NET 4.0 before you install SQL Server Express on a Server Core installation of Windows Server 2008 R2 SP1 or Windows Server 2012.
Windows PowerShell
SQL Server 2014 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.
Network Software
Supported operating systems for SQL Server 2014 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
- Shared memory and VIA are not supported on failover clusters.
- 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 2014 is supported in virtual machine environments running on the Hyper-V role in:
- Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions
- Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions.
- Windows Server 2012 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 SQL Server 2014 instance. Requirements are listed later in this topic.1
Within the Hyper-V role on Windows Server 2008 SP2 or Windows Server 2008 R2 SP1, a maximum of 4 (four) virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit/64-bit or Windows Server 2008 R2 SP1 64-bit or Windows Server 2012 64-bit editions.
Within the Hyper-V role on Windows Server 2012,
- A maximum of 8 (eight) virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit/64-bit.
- A maximum of 64 (sixty-four) virtual processors can be allocated to virtual machines running Windows Server 2008 R2 SP1 64-bit or Windows Server 2012 64-bit editions.
Notes:
Important
- Guest failover clustering is supported in SQL Server 2014.
Hard Disk
SQL Server 2014 requires a minimum of 6 GB of available hard-disk space.
Disk space requirements will vary with the SQL Server 2014 components you install.
Drive
A DVD drive, as appropriate, is required for installation from disc.
Monitor
SQL Server 2014 requires Super-VGA (800×600) or higher resolution monitor.
Internet
Internet functionality requires Internet access (fees may apply).
Running SQL Server 2014 on a virtual machine will be slower than running natively because of the overhead of virtualization.
The following memory and processor requirements apply to all editions of SQL Server 2014:
Component
Requirement
Memory
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
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 2014 minimum memory requirement.
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 2014 from the sections below.
Server Core Support:
SQL Server 2014 is now supported on a Server Core installation of Windows Server 2008 R2, Windows Server 2012, and Windows Server 2012 R2.
Installing SQL Server 2014 is supported on the Server Core mode of the following editions of Windows Server:
- Windows Server 2012 R2 Datacenter 64-bit
- Windows Server 2012 R2 Standard 64-bit
- Windows Server 2012 Datacenter 64-bit
- Windows Server 2012 Standard 64-bit
- Windows Server 2008 R2 SP1 Datacenter 64-bit
- Windows Server 2008 R2 SP1 Enterprise 64-bit
- Windows Server 2008 R2 SP1 Standard 64-bit
- Windows Server 2008 R2 SP1 Web 64-bit
Note
SQL Server editions that are supported on Windows Server 2008 R2 64-bit x64 Standard edition are also supported on Windows Small Business Server 64-bit x64.
Operating System Support:
The SQL Server 2014 editions are classified into the following:
- Principal Editions of SQL Server 2014
- Specialized Editions of SQL Server 2014
- Breadth Editions of SQL Server 2014
During installation of SQL Server 2014, 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.
The following table provides disk space requirements for SQL Server 2014 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 content
375 KB
