Skip to main content
Hardware and Software Requirements for Installing SQL Server 2016

Want to try SQL Server 2016 CTP2 in the cloud? Click herehttp://azure.microsoft.com/en-us/marketplace/partners/microsoft/sqlserver2016ctp2evaluationwindowsserver2012r2/ to try a pre-configured image of SQL Server 2016 Evaluation Edition that gets you up and running in few minutes.

The following sections list the minimum hardware and software requirements to install and run SQL Server 2016.

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

  • We recommend that you run SQL Server 2016 on computers with the NTFS file format. Installing SQL Server 2016 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.

  • The installation of SQL Server 2016 fails if you launch the setup through Terminal Services Client. Launching SQL Server Setup through Terminal Services Client is not supported.

  • SQL Server Management Studio installation requires installing  .NET 4.6 as a pre-requisite. .NET 4.6 will be automatically installed by setup when SQL Server Management Studiois selected as an installation choice.  

  • SQL Server Setup installs the following software components required by the product:

    • SQL Server Native Client

    • SQL Server Setup support files

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

This topic contains the following sections:

Hardware and Software Requirements

The following requirements apply to all SQL Server 2016 installations:

Component

Requirement

.NET Framework

.NET 3.5 SP1 is a requirement for SQL Server 2016 when you select Database Engine, Master Data Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.

Network Software

Supported operating systems for SQL Server 2016 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.

NoteNote
  • 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.

For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.

Hard Disk

SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.

Disk space requirements will vary with the SQL Server 2016 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 2016 requires Super-VGA (800x600) or higher resolution monitor.

Internet

Internet functionality requires Internet access (fees may apply).

1Running SQL Server 2016 on a virtual machine will be slower than running natively because of the overhead of virtualization.

There are additional hardware and software requirements for the PolyBase feature. For more information, see Getting started with PolyBase.

Processor, Memory, and Operating System Requirements

The following memory and processor requirements apply to all editions of SQL Server 2016:

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 Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server 2016 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 2016 from the sections below.

Operating System Support:

The SQL Server 2016 editions are classified into the following:

NoteNote

Exceptions to the operating system support noted in this section are the following Business Intelligence features, which can be installed on Windows Server 2008 R2 SP1 or later:

  • Reporting Services - SharePoint

  • Reporting Services Add-in for SharePoint products

Principal Editions of SQL Server 2016

The following table shows the operating system requirements for the principal editions of SQL Server 2016:

SQL Server Edition

32-bit

64-bit

SQL Server Enterprise

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

SQL Server Business Intelligence

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

SQL Server Standard

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 32-bit

Windows 8.1 Pro 32-bit

Windows 8.1 Enterprise 32-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 32-bit

Windows 8 Pro 32-bit

Windows 8 Enterprise 32-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

Specialized Editions of SQL Server 2016

The following table shows the operating system requirements for the specialized editions of SQL Server 2016:

SQL Server Edition

32-bit

64-bit

SQL Server Web

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Breadth Editions of SQL Server 2016

The following table shows the operating system requirements for the breadth editions of SQL Server 2016:

SQL Server Edition

32-bit

64-bit

SQL Server Developer

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 32-bit

Windows 8.1 Pro 32-bit

Windows 8.1 Enterprise 32-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 32-bit

Windows 8 Pro 32-bit

Windows 8 Enterprise 32-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

SQL Server Express

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 32-bit

Windows 8.1 Pro 32-bit

Windows 8.1 Enterprise 32-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 32-bit

Windows 8 Pro 32-bit

Windows 8 Enterprise 32-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

Windows Server 2012 R2 Datacenter 64-bit

Windows Server 2012 R2 Standard 64-bit

Windows Server 2012 R2 Essentials 64-bit

Windows Server 2012 R2 Foundation 64-bit

Windows Server 2012 Datacenter 64-bit

Windows Server 2012 Standard 64-bit

Windows Server 2012 Essentials 64-bit

Windows Server 2012 Foundation 64-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 64-bit

Windows 8 Pro 64-bit

Windows 8 Enterprise 64-bit

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 2016 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 of SQL Server 2016, 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 Hardware and Software Requirements for Installing SQL Server 2016. The following table provides disk space requirements for SQL Server 2016 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 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

    NoteNote

    SMB storage is not supported for Analysis Services data files for either standalone or clustered installations. Use direct attached storage or a storage area network instead.

    Important noteImportant

    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.

    Caution noteCaution

    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.

Installing SQL Server on a Domain Controller

For security reasons, we recommend that you do not install SQL Server 2016 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.