from my MSDN blog - August 28, 2016
在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 |
沒有留言:
張貼留言