Windows – Installing SQL Server 2008 R2 on Windows 10 64-bit

installationsql-server-2008-r2windows 10

I am trying to install SQL Server 2008 R2 on a Windows 10 64-bit machine.

I get a message telling me that

This app might not be work correctly. 
Microsoft Sql Server (2008 and 2008 R2) isn't incompatible with this version of Windows.

How can this be solved?

Best Answer

See this answer:

SQL Server 2008 R2 is not supported on Windows 10. This means the SQL Server team will not be releasing any security updates or patches if they find any specific issues related to SQL Server 2008 R2 code. There is no way to get updates automatically as none would be released related to Windows 10.

Having said that, SQL Server 2008 R2 installation is not blocked when you try to install it on Windows 10. Of course, it is always better and advisable to install the latest Service Pack (Service Pack 3 is the final SP for 2008 R2).

Related Question