Pre-Requisites for Different Version of Microsoft SQL Server on Single Page

This article will give you a complete idea on the prerequisites to install Microsoft SQL Server. 

This will cover different versions of SQL Server starting from 2012 to 2022. 

It will give you knowledge of the minimum hardware & software requirements to install MS SQL Server.

The hardware requirement is given below for all major SQL Server versions:

Hardware Requirements

 

Hard Disk

Min. Memory
Express Edition

Min. Memory
All Other Editions

SQL Server 2012

Around 4 GB

512 MB

1 GB

SQL Ser. 2012 R2

Around 4 GB

512 MB

1 GB

SQL Server 2014

Around 4 GB

512 MB

1 GB

SQL Server 2016

Around 6 GB

512 MB

1 GB

SQL Server 2017

Around 6 GB

512 MB

1 GB

SQL Server 2019

Around 6 GB

512 MB

1 GB

SQL Server 2022

Around 6 GB

512 MB

1 GB

Hardware Requirement Table-1

Hardware Requirements

 

Memory Recommended
Express Edition

Memory Recommended
All Other Editions

SQL Server 2012

1 GB

At least 4 GB

SQL Ser. 2012 R2

1 GB

At least 4 GB

SQL Server 2014

1 GB

At least 4 GB

SQL Server 2016

1 GB

At least 4 GB

SQL Server 2017

1 GB

At least 4 GB

SQL Server 2019

1 GB

At least 4 GB

SQL Server 2022

1 GB

At least 4 GB

Hardware Requirement Table-2

Hardware Requirements

 

Minimum - Processor Speed

Recommended - Processor Speed

SQL Server 2012

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Ser. 2012 R2

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Server 2014

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Server 2016

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2017

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2019

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2022

1.4 GHz-64 bit

2.0 GHz or Faster

Hardware Requirement Table-3

Software requirement is given below for all major SQL Server versions:

Software Requirements

 

OS-Personal

OS-Server

SQL Server 2012

Windows 7 SP1

Windows Server 2008 R2 SP1

SQL Ser. 2012 R2

Windows 7 SP1

Windows Server 2008 R2 SP1

SQL Server 2014

Windows 7 Vista

Windows Server 2008 R2 SP1

SQL Server 2016

Windows 10

Windows Server 2012

SQL Server 2017

Windows 10

Windows Server 2012

SQL Server 2019

Windows 10 TH1 1507 or higher

Windows Server 2016 or higher

SQL Server 2022

Windows 10 TH1 1507 or higher

Windows Server 2016 or higher

Software Requirement Table-1

Software Requirements

 

.Net Framework

Windows Installer

Powershell 2.0 or Later

SQL Server 2012

.Net 3.5 SP1

Yes

Yes

SQL Ser. 2012 R2

.Net 3.5 SP1

Yes

Yes

SQL Server 2014

.Net 3.5 SP1

Yes

Yes

SQL Server 2016

.Net 4.6 SP1

Yes

Yes

SQL Server 2017

.Net 4.6 SP1

Yes

Yes

SQL Server 2019

OS Includes min. .NET Framework

Yes

Yes

SQL Server 2022

OS Includes min. .NET Framework

Yes

Yes

Software Requirement Table-2