For those still struggling to install MS SQL 2019 on Windows 11 I've found a way with a combinationa of things posted on this forum.
Steps:
1. Obtain Windows 10 build 21354 following instructions on this link (thanks MarcosH2)
https://www.reddit.com/r/windowsins...dows_10_arm_insider_preview_vhdx_file_solved/
This step is very important as no other builds worked for me.
2. Install Windows 10.
Important - select to configure VM before installing and remove 'TPM Chip' from Hardware as it's not compatible with Windows 10.
3. Follow instructions on installing and updating SQL 2019 from the very first post on this thread (thanks Mundford) - I first installed SQL 2019 developers edition (free) which failed as usual, then updated with both links provided, then installed SQL 2019 again and it worked!
4. Update to Windows 11. Windows updates didn't work for me, so I first updated to latest Windows 10 build available (21390) using ISO image.
Important - you have to add TPM Chip back or Windows 11 won't install. Again I couldn't update to Windows 11 from updates, so I got Windows 11 build 22000 ISO and updated without problems.
5. After upgrading to Windows 11 updates are working fine again so updating to very latest build right now. SQL Management Studio still works no issues.
Hopefully this will help someone as well.
Click to expand...