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 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

 

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).

Enroll Now with Discount!

 

Featured Online Courses:

 

Related SQL Server Administration Articles:

 

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

Loading...

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

© SQLNetHub