Using SQL Server in Windows 8 and later versions of Windows operating system

Using SQL Server in Windows 8 and later versions of Windows operating system
在Windows 8與更新版的Windows作業系統使用SQL Server


雖然KB2681562文件說明Windows 10不支援SQL 2008 R2

但經過測試在Windows 10安裝SQL 2008 R2只會跳出警告,最後還是可以安裝成功 ,但此種搭配微軟並不支援,將來也不會有hotfix

Using SQL Server in Windows 8 and later versions of Windows operating system
https://support.microsoft.com/en-us/kb/2681562

OS version SQL version Minimum SQL Server version requirements
Windows 10 SQL 2014 Support SQL Server 2014 Service Pack 1 or a later update
SQL 2012 Support SQL Server 2012 Service Pack 2 or a later update
SQL 2008 R2 Not Support SQL Server 2008 R2 is not supported on Windows 10
SQL 2008 Not Support SQL Server 2008 is not supported on Windows 10
Windows Server 2012 R2 or Windows 8.1 SQL 2014 Support SQL Server 2014 RTM or a later version
SQL 2012 Support SQL Server 2012 Service Pack 1 or a later update
SQL 2008 R2 Support SQL Server 2008 R2 Service Pack 2 or a later update
Support SQL Server 2008 Service Pack 3 or a later update
Windows Server 2012 or Windows 8 SQL 2014 Support SQL Server 2014 RTM or a later version
SQL 2012 Support SQL Server 2012 RTM or a later update
SQL 2008 R2 Support SQL Server 2008 R2 Service Pack 1 or a later update
Support SQL Server 2008 Service Pack 3 or a later update