Share via

Does SCOM 2019 run on SQL 2019?

Brian W 61 Reputation points
2022-09-06T18:42:07.153+00:00

I want to upgrade to SCOM 2022 from SCOM 2019, but do I need to upgrade my SQL first? SCOM 2022 only runs on SQL 2019 UR8 or later, where ase my current SQL is 2016 (13.0.5893.48). Can SCOM 2022 run on 13.0.5893.48 or can SCOM 2019 run on SQL 2019 UR8?

System Center Operations Manager
System Center Operations Manager

A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Cornelissen 401 Reputation points MVP
    2022-09-07T07:59:34.46+00:00

    I heard my name being mentioned :-)

    On your current config the SCOM 2022 upgrade should deny your upgrade due to having an older version of SQL.
    The process would be as the others indicated. To first upgrade your SQL to either SQL 2017 or SQL 2019 and immediately update the SQL to a latest Cumulative Update level (for 2019 that is CU8 or higher). From those two SQL versions, you should be fine to in-place upgrade SCOM 2019 to SCOM 2022. Assuming of course other things check out.

    SCOM 2019 will run on SQL 2019 CU8 or higher.
    Stoyan mentions a good trick. to stop management servers, while upgrading your SQL machine and do both SQL upgrade and SQL CUx upgrade one after the other and next enable SCOM management servers again. Will take them 10-20 minutes to calm down after that. Don't forget the SQL reporting services instance by the way for this whole SCOM upgrade process.

    Hope this answers your question.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. SChalakov 10,781 Reputation points MVP Volunteer Moderator
    2022-09-07T06:36:58.997+00:00

    Hi Brian (@Brian W ),

    this is a bit of grey area, since SCOM can be installed on SQL 2019 CU8 or later. The thing is that this is condition, which is checked by the installer during the initial setup process and if your SQL is missing CU8 the installer with throw an error and you cannot proceed further.
    The upgrade is a different story - during the upgrade of SQL your SCOM Management Servers should have their services stopped, so in theory SCOM will not know the SQL version untill it is CU8, which is the supported one.
    Me personally, I would have attempted this after making sure that I have a backup. On the technical side there is nothng wrong with this action plan.
    I would still get another confirmation from a Microsoft MVP, who iss let's say "the master of SCOM upgrades" - @Bob Cornelissen
    Let's see if he confirms this.

    Hope I could help out.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
    Regards
    Stoyan Chalakov

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Brian W 61 Reputation points
    2022-09-06T19:19:00.24+00:00

    I have no issues with upgrading to SQL 2019, but I need to know if my SCOM 2019 installation will run after upgrading SQL?

    Was this answer helpful?

    0 comments
  4. CyrAz 5,181 Reputation points
    2022-09-06T19:15:27.057+00:00

    Yes you do need to upgrade SQL first, and yes SCOM 2019 runs on SQL 2019 : https://learn.microsoft.com/fr-fr/system-center/scom/plan-sqlserver-design?view=sc-om-2019#sql-server-requirements
    Note that both SCOM 2019 and 2022 also run on SQL 2017, if for some reason you prefer avoiding SQL 2019.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.