Hello!
Upgrading from SCOM 2019 to SCOM 2022 can indeed be tricky, especially with SQL Server compatibility issues. Here are some steps and considerations to help you navigate this process:
- SQL Server and OS Compatibility:
- SCOM 2022 requires SQL Server 2017 or SQL Server 2019 CU8 or later.
- Operating System: SCOM 2022 supports Windows Server 2019 and Windows Server 2022.
- Upgrade Path:
- In-Place OS Upgrade: You can perform an in-place upgrade of your existing SQL Server's OS from Windows Server 2016 to Windows Server 2019. This will resolve the compatibility issue and allow you to proceed with the SCOM 2022 upgrade.
- Alternative Approach: Another option is to set up a new SQL Server instance on Windows Server 2019 or 2022, migrate your databases to this new instance, and then proceed with the SCOM 2022 upgrade.