none
SCOM 1807, SQL 2016 server and Windows 2016 Server RRS feed

  • Question

  • Hi,

    I have SCOM 1807 with SQL 2016 server and Windows 2016 Server. As I know the SCOM 1807 will not be continued.

    I want to upgrade to SCOM 2019, SQL 2017 and Windows 2019.

    What is the best way to do that?

    1) upgrade first from scom 1807 to scom 2019

    2) Then upgrade win 2016 server to win 2019

    3) upgrade SQL 2016 to SQL 2017

    Or:

    1) Upgrade first the OS win 2016 to win 2019

    2) upgrade SQL 2016 to SQL 2017

    3) last step, upgrade scom 1807 to scom 2019

    But as I know scom 1807 does not support win 2019

    BR,

    Nick

    Thursday, November 14, 2019 8:49 PM

Answers

  • I would suggest you create a new thread if you have any issue with your migration, so we don't mix up different topics.

    But from what I see in the picture, these are the default application pools in SCOM that should be there.


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by mpng2008 Sunday, November 17, 2019 12:54 PM
    Friday, November 15, 2019 2:18 PM

All replies

  • Hi Nick,

    You have a couple of options here just as you mentioned, I wanted to point out that you're not really in need of upgrading the operating system, actually doing so makes everything way more risky.

    In-place upgrades for Windows Server operating systems are supported, however not recommended, so if I were you I would avoid that if not really necessary.

    You don't have to upgrade the SQL Server either really, as SCOM 2019 supports SQL Server 2016 and 2017.

    If we're considering the operating system upgrades, then you only have one supported way of doing this:

    1. Upgrade SCOM 1807 to SCOM 2019.

    2. Upgrade SQL Server 2016 to SQL Server 2017.

    3. Upgrade Windows Server 2016 to Windows Server 2019.


    Why only the above method? Because SCOM 1807 doesn't officially support Windows Server 2019.

    -------------------------------------------------------------

    If we're not considering operating system upgrades, you have the following two options:

    Method 1

    1. Upgrade SQL Server 2016 to SQL Server 2017.

    2. Upgrade SCOM 1807 to SCOM 2019.

    Method 2

    1. Upgrade SCOM 1807 to SCOM 2019.

    2. Upgrade SQL Server 2016 to SQL Server 2017.

    -------------------------------------------------------------

    If we're not considering either operating system upgrades or SQL Server upgrades, it leaves you with one simple upgrade:

    1. Upgrade SCOM 1807 to SCOM 2019.

    -------------------------------------------------------------

    The more upgrades you do, the more steps you will have, and the more chances of things that can fail.
    While every method above is supported, it doesn't necessarily mean that things will work flawlessly afterwards, because every environment is different.

    I don't want to scare you by saying that upgrades are bad, they do work and I have done plenty myself.
    My message here is mainly: "Only upgrade IF necessary".

    It is indeed nice to have newest operating system and SQL Server, but that's a decision you or your organization will have to take, if there is any value of upgrading to Windows Server 2019 & SQL Server 2017, then of course you can consider upgrading.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, November 14, 2019 9:42 PM
  • Hi Leon,

    Thanks for replay. I think the following method is the best way.

    1. Upgrade SCOM 1807 to SCOM 2019.

    2. Upgrade SQL Server 2016 to SQL Server 2017.

    3. Upgrade Windows Server 2016 to Windows Server 2019.

    Do you know any link for upgrading for all 3 steps?

    Thanks

    Nick

    Thursday, November 14, 2019 10:09 PM
  • I have written a guide on my blog post about upgrading to SCOM 2019, I have also put it on the TechNet Wiki:

    SCOM 2019 Step-By-Step: Upgrading
    https://social.technet.microsoft.com/wiki/contents/articles/52642.scom-2019-step-by-step-upgrading.aspx

    Here's also the official documentation:
    Upgrading System Center Operations Manager
    https://docs.microsoft.com/en-us/system-center/scom/deploy-upgrade-overview?view=sc-om-2019

    In the above guide I'm not upgrading the SQL Server or Windows Server operating system though, but I have also written a guide on how to upgrade SQL Server 2016 to SQL Server 2017:

    SCOM 1807 Step-By-Step: Upgrade database to SQL Server 2017
    https://social.technet.microsoft.com/wiki/contents/articles/53279.scom-1807-step-by-step-upgrade-database-to-sql-server-2017.aspx

    Here's also the official documentation:
    How to upgrade Operations Manager 1807 databases to SQL Server 2017
    https://docs.microsoft.com/en-us/system-center/scom/upgrade-sqlserver-2017-opsmgr-1807?view=sc-om-1807

    For upgrading Windows Server 2016 to Windows Server 2019, here's the official documentation guide:
    Upgrade Windows Server 2016 to Windows Server 2019
    https://docs.microsoft.com/en-us/windows-server/upgrade/upgrade-2016-to-2019

    And before doing anything, please make sure you back everything up!


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by mpng2008 Thursday, November 14, 2019 10:23 PM
    • Unmarked as answer by mpng2008 Friday, November 15, 2019 9:13 AM
    Thursday, November 14, 2019 10:21 PM
  • Hi Leon,

    I have upgraded the scom 1807 to scom 2019 without any error. 

    And I have only these two App Pools

    Any Idea?

    Regards

    Nick

    • Edited by mpng2008 Friday, November 15, 2019 1:38 PM
    Friday, November 15, 2019 9:16 AM
  • I would suggest you create a new thread if you have any issue with your migration, so we don't mix up different topics.

    But from what I see in the picture, these are the default application pools in SCOM that should be there.


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by mpng2008 Sunday, November 17, 2019 12:54 PM
    Friday, November 15, 2019 2:18 PM