Using MS SQL 2019 on Windows Server 2022 Essentials

Question

Is it possible to use MS SQL 2019 on Windows Server 2022 Essentials?

WS22 Essentials is not listed between the supported OS, but the same situation was with MS SQL 2016 and OS Essentials support appeared afterwards.

Answer 1

Hi @Jirka505 ,

Yes, Windows Server 2022 Essentials is not listed in supported OS. The Windows versions in supported list have been repeatedly tested by Microsoft. If you install SQL 2019 on Windows Server 2022 Essentials that is not in supported list, you may encounter many issues during SQL installation and using.

Refer to MS document SQL Server 2019: Hardware and software requirements.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

On the other hand: "With Windows Server 2022, the Essentials edition is available to purchase from OEMs only, however there is no specific installation media. Instead, an Essentials edition product key is used to activate the Standard edition of Windows Server 2022. You get all the same features." (https://learn.microsoft.com/en-us/windows-server-essentials/get-started/get-started)

Isn't it possible not to be listed because it is considered a Standard Version?

Has anyone tried installing SQL on Essentials 2022 so far?

Answer 3

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16