SQL Server SQL Server 2017 Windows System Requirements & Software Prerequisite October 23, 20172983 views0 Share By IG Share 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 Table of Contents Toggle SQL Server 2017 Windows System Requirements – HardwareSQL Server 2017 Windows System Requirements – SoftwareConclusion 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: Hardware & Software Requirements for Setting up SQL Server Using SQL Server in Windows 8 Disclaimer: The Questions and Answers provided on https://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. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
SQL Server What is the SQL Server SA (Sys Admin) Password Policy & Default Password If you are searching for the SQL Server SA (Sys Admin) Password and Policy enforcement, ...
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server Even though it’s flashy and glamorous being a Data Engineer these days, it comes with ...
SQL Server How to do SQL Server Hybrid Backup to URL on Azure Storage in 2019 The SQL Server hybrid backup to URL feature offers flexibility to customers. It provides an ...
Azure Azure SQL Connection Pooling Best Practices Pool Size & Exhaustion In this blog post, we will be sharing the Azure SQL Connection Pooling best practices. ...