SQL Server is among the most used relational database management systems out there, but sometimes when trying to use SQL Server you might get Your operating system is not supported by SQL Server error.
This can be a big problem, and in today’s article, we’ll show you how to fix it.
What to do if your operating system is not supported by SQL Server?
1. Run in Compatibility mode
- Open the folder containing the files for SQL Server.
- Right click on the setup file and select Properties.
- In the Setup Properties windows, select the Compatibility tab.
- Select the checkbox for Run the program in compatibility mode for
- From the drop-down box just below it, select the Windows version where you know SQL Server runs smoothly. As a safe bet, select Windows Vista Service Pack 2.
- Click on Apply, OK.
- Double click on the Set-up file to let the installation process to begin.
- In the SQL Server Installation Center window that opens, select the first option, that of – New SQL Server stand-alone installation or add features to an existing installation.
- Follow on-screen instructions that show up.
2. Make sure that the SQL Server is compatible with your version of Windows
- Windows 10 – the most widely used version of Windows, SQL Server 2008 and SQL Server 2008 R2 is not supported.
- For SQL Server 2012, you will need to install at least SQL Server 2012 Service Pack 2 for the installation to be complete.
- Similarly, for SQL Server 2014, the minimum requirement is SQL Server 2014 Service Pack 1 for a successful installation.
- SQL Server 2016, SQL Server 2017 and SQL Server 2019 are compatible with Windows 10.
While the above deals with compatibility of SQL Server with Windows version, here are some related resources that you might want to browse.
- SQL Server query execution failed for dataset [EXPERT FIX]
- Here’s how to fix high CPU usage by SQL server
- 8 best Windows hosting with SQL Server for 2019