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 |
|
For more info please visit: https://msdn.microsoft.com/en-us/library/ms143506.aspx
|
|
|
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 |
|
For more info please visit: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx
|
|
|
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 |
|
For more info please visit: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx
|
|
|
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. | |
|
For more info please visit: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspx
|
|
|
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
 |
|
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).
