SQL Server

SQL Server 2017 Windows System Requirements & Software Prerequisite

SQL Server 2017 Windows System Requirements

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.

Conclusion

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:

Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.

What's your reaction?

Excited
0
Happy
0
In Love
0
Not Sure
0
Silly
0

You may also like

Comments are closed.

More in:SQL Server