Saturday, May 28, 2016

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


SQL Server 2016 - Operating System Requirements
SQL Server 2016 Enterprise Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
SQL Server 2016 Standard Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows 8.1
Windows 8.1 Pro
Windows 8.1 Enterprise
Windows 8
Windows 8 Pro
Windows 8 Enterprise
SQL Server 2016 Web Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
SQL Server 2016 Developer Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows 8.1
Windows 8.1 Pro
Windows 8.1 Enterprise
Windows 8
Windows 8 Pro
Windows 8 Enterprise
SQL Server 2016 Express Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
 Windows 8.1
 Windows 8.1 Pro
 Windows 8.1 Enterprise
 Windows 8
 Windows 8 Pro
 Windows 8 Enterprise



SQL Server 2014 - Operating System Requirements
SQL Server 2014 Enteprise Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essential
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Web
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Web
SQL Server 2014 Business Intelligence Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Web
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Web
SQL Server 2014 Standard Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Foundation
Windows Server 2008 R2 SP1 Web
Windows 8.1
Windows 8.1 Pro
Windows 8.1 Enterprise
Windows 8
Windows 8 Pro
Windows 8 Enterprise
Windows 7 SP1 Ultimate
Windows 7 SP1 Enterprise
Windows 7 SP1 Professional
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Foundation
Windows Server 2008 SP2 Web
SQL Server 2014 Web Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Web
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Web
SQL Server 2014 Developer Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Web
Windows 8.1
Windows 8.1 Pro
Windows 8.1 Enterprise
Windows 8
Windows 8 Pro
Windows 8 Enterprise
Windows 7 SP1 Ultimate
Windows 7 SP1 Enterprise
Windows 7 SP1 Professional
Windows 7 SP1 Home Premium
Windows 7 SP1 Home Basic
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Web
SQL Server 2014 Express Windows 10 Home
Windows 10 Professional
Windows 10 Enterprise
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2008 R2 SP1 Datacenter
Windows Server 2008 R2 SP1 Enterprise
Windows Server 2008 R2 SP1 Standard
Windows Server 2008 R2 SP1 Foundation
Windows Server 2008 R2 SP1 Web
Windows 8.1
Windows 8.1 Pro
Windows 8.1 Enterprise
Windows 8
Windows 8 Pro
Windows 8 Enterprise
Windows 7 SP1 Ultimate
Windows 7 SP1 Enterprise
Windows 7 SP1 Professional
Windows 7 SP1 Home Premium
Windows 7 SP1 Home Basic
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Foundation
Windows Server 2008 SP2 Web



SQL Server 2008 R2 - Operating System Requirements
SQL Server 2008 R2 Datacenter
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows Server 2008 for Windows Essential Server Solutions
Windows 2008 R2 Datacenter
Windows 2008 R2 Enterprise
Windows 2008 R2 Standard
Windows 2008 R2 Web
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
SQL Server 2008 R2 Enterprise
Windows Server 2003 SP2 Datacenter
Windows Server 2003  SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows 2008 R2 Datacenter
Windows 2008 R2 Enterprise
Windows 2008 R2 Standard
Windows 2008 R2 Web
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
SQL Server 2008 R2 Standard

Windows XP Professional SP2
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Vista SP2 Ultimate
Windows Vista SP2 Enterprise
Windows Vista SP2 Business
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows Server 2008 SP2 for Windows Essential Server Solutions
Windows Server 2008 SP2 Foundation Server
Windows 7 Ultimate
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 Datacenter
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Web
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2008 R2 Foundation Server
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8
Windows 8 Professional
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 R2 Developer

Windows XP SP2 Professional
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 SP2 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows 7 Ultimate
Windows 7 Home Premium
Windows 7 Home Basic
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 DataCenter
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Web
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8
Windows 8 Professional
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 R2 Workgroup

Windows XP SP2 Professional
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Vista SP2 Ultimate
Windows Vista SP2 Enterprise
Windows Vista SP2 Business
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2008 SP2 Foundation Server
Windows 7 Ultimate
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 Datacenter
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Web
Windows Server 2008 R2 Foundation Server
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8
Windows 8 Professional
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 R2 Web

Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Web
Windows Server 2008 R2 Datacenter
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
SQL Server 2008 R2 Express 

Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 R2 SP2 Datacenter
Windows Server 2003 R2 SP2 Enterprise
Windows Server 2003 R2 SP2 Standard
Windows Vista SP2 Ultimate
Windows Vista SP2 Home Premium
Windows Vista SP2 Home Basic
Windows Vista SP2 Enterprise
Windows Vista SP2 Business
Windows Server 2008 SP2 Datacenter
Windows Server 2008 SP2 Datacenter without Hyper-V
Windows Server 2008 SP2 Enterprise
Windows Server 2008 SP2 Enterprise without Hyper-V
Windows Server 2008 SP2 Standard
Windows Server 2008 SP2 Standard without Hyper-V
Windows Server 2008 SP2 Web
Windows Server 2008 SP2 Foundation Server
Windows 7 Ultimate
Windows 7 Home Premium
Windows 7 Home Basic
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 Datacenter
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Web
Windows Server 2008 R2 for Windows Essential Server Solutions
Windows Server 2008 R2 Foundation Server
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8
Windows 8 Professional
Windows 8.1
Windows 8.1 Professional



SQL Server 2008 - Operating System Requirements
SQL Server 2008 Enterprise
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Server 2008 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Server 2008 R2 Web
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
SQL Server 2008 Standard 
Windows XP Professional
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Vista Ultimate
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 Web
Windows Server 2008 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Small Business Server 2008
Windows Server 2008 for Windows Essential Server Solutions
Windows Server 2008 without Hyper-V for Windows Essential Server Solutions
Windows 7 Ultimate
Windows 7 Enterprise
Windows 7 Professional
Windows 2008 R2 Web
Windows 2008 R2 Foundation Server
Windows 2008 R2 Standard
Windows 2008 R2 Enterprise
Windows 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 8
Windows 8 Professional
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 Developer 
Windows XP Professional
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Server 2008 Web
Windows 7 Web
Windows 7 Home Basic
Windows 7 Home Premium
Windows 7 Enterprise
Windows 7 Ultimate
Windows 7 Professional
Windows 2008 R2 Web
Windows 2008 R2 Standard
Windows 2008 R2 Enterprise
Windows 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 8
Windows 8 Professional
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 Workgroup
Windows XP Professional
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 Web
Windows Server 2008 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows 7 Ultimate
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 Web
Windows Server 2008 R2 Foundation Server
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 8
Windows 8 Professional
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8.1
Windows 8.1 Professional
SQL Server 2008 Web
Windows XP Professional
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacenter
Windows Server 2003 SP2 Enterprise
Windows Vista Ultimate
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 Web
Windows Server 2008 Standard Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Server 2008 R2 Web
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
SQL Server 2008 Express
Windows Server 2003
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Datacente
Windows Server 2003 SP2 Enterprise
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Server 2008 Web1
Windows Server 2008 Standard
Windows Server 2008 Standard without Hyper-V
Windows Server 2008 Datacenter
Windows Server 2008 Datacenter without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows 7 Ultimate
Windows 7 Home Basic
Windows 7 Home Premium
Windows 7 Enterprise
Windows 7 Professional
Windows Server 2008 R2 Web
Windows Server 2008 R2 Foundation Server1
Windows Server 2008 R2 Standard
Windows Server 2008 R2 Enterprise
Windows Server 2008 R2 Datacenter
Windows Server 2012 Datacenter
Windows Server 2012 Standard
Windows Server 2012 Essentials
Windows Server 2012 Foundation
Windows 8
Windows 8 Professional
Windows Server 2012 R2 Datacenter
Windows Server 2012 R2 Standard
Windows Server 2012 R2 Essentials
Windows Server 2012 R2 Foundation
Windows 8.1
Windows 8.1 Professional
Note: SQL Server 2008 support on Windows Server 2003 R2 is the same as support on Windows Server 2003 SP2.



SQL Server 2005 - Operating System Requirements
SQL Server 2005 Enterprise Edition
Windows 2000 Server SP4
Windows 2000 Advanced Server SP4
Windows 2000 Datacenter Edition SP4
Windows Server 2003 Server SP1
Windows Server 2003 Standard Edition SP1
Windows Server 2003 Enterprise Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Small Business Server 2003 Standard Edition SP1
Windows Small Business Server 2003 Premium Edition SP1
Windows Server 2008
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web Edition
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web
SQL Server 2005 Developer Edition
Windows 2000 Professional Edition SP4
Windows 2000 Server SP4
Windows 2000 Advanced Server SP4
Windows 2000 Datacenter Edition SP4
Windows XP Home Edition SP2
Windows XP Professional Edition SP2
Windows XP Media Edition SP2
Windows XP Tablet Edition SP2
Windows Server 2003 Server SP1
Windows Server 2003 Enterprise Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Small Business Server 2003 Standard Edition SP1
Windows Small Business Server 2003 Premium Edition SP1
Windows Vista Home Basic Edition
Windows Vista Home Premium Edition
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2003 Standard Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Server 2003 Enterprise Edition SP1
Windows XP Professional 2003
Windows Vista Home Basic Edition
Windows Vista Home Premium Edition
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2008
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web Edition
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web
SQL Server 2005 Standard Edition
Windows 2000 Professional Edition SP4
Windows 2000 Server SP4
Windows 2000 Advanced Server SP4
Windows 2000 Datacenter Edition SP4
Windows XP Professional Edition SP2
Windows XP Media Edition SP2
Windows XP Tablet Edition SP2
Windows Server 2003 Server SP1
Windows Server 2003 Enterprise Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Small Business Server 2003 Standard Edition SP1
Windows Small Business Server 2003 Premium Edition SP1
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2003 Standard Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Server 2003 Enterprise Edition SP1
Windows XP Professional 2003
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2008
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web Edition
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web
SQL Server 2005 Workgroup Edition
Windows 2000 Professional Edition SP4
Windows 2000 Server SP4
Windows 2000 Advanced Server SP4
Windows 2000 Datacenter Edition SP4
Windows XP Professional Edition SP2
Windows XP Media Edition SP2
Windows XP Tablet Edition SP2
Windows Server 2003 Server SP1
Windows Server 2003 Enterprise Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Small Business Server 2003 Standard Edition SP1
Windows Small Business Server 2003 Premium Edition SP1
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2003 Standard Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Server 2003 Enterprise Edition SP1
Windows XP Professional 2003
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2008
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web Edition
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web
SQL Server 2005 Express Edition
Windows 2000 Professional Edition SP4
Windows 2000 Server SP4
Windows 2000 Advanced Server SP4
Windows 2000 Datacenter Edition SP4
Windows XP Embedded SP2 Feature pack 2007
Windows Embedded for Point of Service
Windows XP Home Edition SP2
Windows XP Professional Edition SP2
Windows XP Media Edition SP2
Windows XP Tablet Edition SP2
Windows Server 2003 Server SP1
Windows Server 2003 Enterprise Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Server 2003 Web Edition SP1
Windows Small Business Server 2003 Standard Edition SP1
Windows Small Business Server 2003 Premium Edition SP1
Windows Vista Home Basic Edition
Windows Vista Home Premium Edition
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2003 Standard Edition SP1
Windows Server 2003 Datacenter Edition SP1
Windows Server 2003 Enterprise Edition SP1
Windows XP Professional 2003
Windows Vista Home Basic Edition
Windows Vista Home Premium Edition
Windows Vista Ultimate Edition
Windows Vista Business Edition
Windows Vista Enterprise Edition
Windows Server 2008
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web Edition
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Data Center
Windows Server 2008 Web
Note: SQL Server 2005 support on Windows Server 2003 R2 is the same as support on Windows Server 2003 SP1.

For more info please visit: https://technet.microsoft.com/en-us/library/ms143506(v=sql.90).aspx



Reference: The SQL Server and .NET Hub (http://www.sqlnethub.com)


[Ad]
Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (http://www.sqlnethub.com)

0 comments: