If you are ready to install SQL Server 2017, you will need to know the minimum requirements first. The SQL Server 2017 Windows system requirements are mostly unchanged when compared with its predecessor. However, we will still evaluate it objectively just to ensure not to miss any critical elements. Read along to know more.
Related Reading: SQL Server 2017 on Linux System Requirements
SQL Server 2017 Windows System Requirements – Hardware
Before we get into the software elements, let’s check out the system hardware requirements. You will have to remember that most of these conditions are essential and minimum. You will have to do a proper capacity planning to achieve the performance levels needed.
On a high-level, here are the minimum SQL Server 2017 Windows System Requirements:
|Feature-Type||Minimum SQL Server 2017 Windows System Requirements|
|Memory||512 MB for Express, 1 GB for Standard, Developer & Enterprise|
|File System||NTFS or ReFS (other file systems, such as FAT32, are unsupported)|
|Disk space||Minimum of 6 GB|
|Processor speed||Clockspeed of 2 GHz or more. 1.4 GHz minimum|
|Processor cores||2 cores (Virtual or Physical)|
|Processor type||64 bit x64-compatible AMD or Intel CPU only|
SQL Server 2017 Windows System Requirements – Software
Before installing SQL Server 2017 on Windows, you will need to ensure that the software prerequisites are met. Here are the high-level software requirements:
- A minimum of .NET 4.6.1 is required. The SQL Server 2017 setup will install the necessary files before the actual installation.
- SQL Server setup support files and the native client will be installed first.
- Client versions of Windows 10 or 8.1 and Windows Server 2016 or Windows Server 2012 R2 RTM are needed for SQL Server 2017. Windows Server Essentials and Foundation Editions are also supported. However, the SQL Server setup requires a GUI and will not work on Core editions.
- If you decide to install all the components, you will need hard disk space of 8030 MB.
- Storage type will either need to be local, shared, storage space (S2D). SMB is also supported with certain limitations.
- SQL Server has limitations when installing on a domain controller. Failover clustering is not supported on a DC.
- SQL Server Core engine is 64-bit only and does not support the 32-bit editions of Windows 8 or Windows 10. Barring a few 32-bit components like Client Tools, Data Quality Client, and others, all other parts will need native 64-bit support.
As you can see, SQL Server 2017 Windows System Requirements is very similar to SQL Server 2016 edition. All the earlier best practices are still applicable to SQL Server 2017 as well.
We highly recommend that you review the official Microsoft documentation before proceeding. See below: