Operating System Requirements for all SQL Server Versions and Editions

SQL Server is the world’s most powerful data platform and it is constantly evolving. From release to release significant new features are added. Besides the features and functionality, one of the typical question DBAs have is which are the Operating System requirements for each version and edition of SQL Server.
In this post you can find this information for all versions and editions gathered from different MSDN Library articles. In the end of each table there is a reference to the source document on MSDN in case you need to find more information (i.e. 32-bit vs. 64 bit, etc.).

 

Operating System Requirements for SQL Server:

SQL Server 2022 – Operating System Requirements
SQL Server 2022 Enterprise Windows 10 TH1 1507 or greater

Windows Server 2016 or greater

SQL Server 2022 Standard Windows 10 TH1 1507 or greater

Windows Server 2016 or greater

SQL Server 2022 Web Windows 10 TH1 1507 or greater

Windows Server 2016 or greater

SQL Server 2022 Developer Windows 10 TH1 1507 or greater

Windows Server 2016 or greater

SQL Server 2022 Express Windows 10 TH1 1507 or greater

Windows Server 2016 or greater

SQL Server 2019 – Operating System Requirements
SQL Server 2019 Enterprise Windows Server 2016/2019
SQL Server 2019 Standard Windows Server 2016/2019

Windows 10

SQL Server 2019 Web Windows Server 2016/2019
SQL Server 2019 Developer Windows Server 2016/2019

Windows 10

SQL Server 2019 Express Windows Server 2016/2019

Windows 10

SQL Server 2016 & 2017  – Operating System Requirements
SQL Server 2016/2017 Enterprise Windows Server 2012/2016/2019
SQL Server 2016/2017 Standard Windows Server 2012/2016/2019

Windows 8/8.1/10

SQL Server 2016/2017 Web Windows Server 2012/2016/2019
SQL Server 2016/2017 Developer Windows Server 2012/2016/2019

Windows 8/8.1/10

SQL Server 2016 Express Windows Server 2012/2016/2019

Windows 8/8.1/10

 

SQL Server 2014 – Operating System Requirements
SQL Server 2014 Enterprise Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2014 Business Intelligence Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2014 Standard Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1/10

SQL Server 2014 Web Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2014 Developer Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1/10

SQL Server 2014 Express Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1/10

 

SQL Server 2012 – Operating System Requirements
SQL Server 2012 Enterprise Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2012 Business Intelligence Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2012 Standard Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1

SQL Server 2012 Web Windows Server 2008/2008 R2/2012/2012 R2
SQL Server 2012 Developer Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1

SQL Server 2014 Express Windows Server 2008/2008 R2/2012/2012 R2

Windows 7 SP1/8/8.1

 

SQL Server 2008/2008 R2 – Operating System Requirements
SQL Server 2008 R2 Datacenter Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2
SQL Server 2008/2008 R2 Enterprise Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2
SQL Server 2008 R2 Business Intelligence Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2
SQL Server 2008/2008 R2 Standard Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2

Windows XP SP2/Vista/7 SP1/8/8.1

SQL Server 2008/2008 R2 Web Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2
SQL Server 2008/2008 R2 Developer Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2

Windows XP SP2/Vista/7 SP1/8/8.1

SQL Server 2008/2008 R2 Express Windows Server 2003/2003 R2/2008/2008 R2/2012/2012 R2

Windows XP SP2/Vista/7 SP1/8/8.1

 

 

Learn More About What’s New in SQL Server 2022 – Enroll to the Course!

Feel free to check our course on Udemy, titled “SQL Server 2022: What’s New – New and Enhanced Features“.

Via the course, you will learn all about the new features and enhancements in SQL Server 2022, via a rich set of high-quality lectures, infographics and step-by-step live demonstrations.

SQL Server 2022: What's New - New and Enhanced Features (Online Course)
(Lifetime access, live demos, downloadable resources, quizzes)

Learn More on Udemy

 

 

Enroll to our Master Class “Essential SQL Server Administration Tips”

If you really want to learn sophisticated SQL Server administration techniques, then you should check our on-demand online course titled “Essential SQL Server Administration Tips” (special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
SQL Server Administration Tips (lifetime access – learn more).

Learn More

 

Featured Online Courses:

 

Related SQL Server Administration Articles:

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub