SCOM 2016 with SQL 2019

dor 1 Reputation point
2021-02-07T09:59:41.157+00:00

Hello,
Can I use SQL 2019 for SCOM 2016?
I yes, What service pack?

Thanks

Operations Manager
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.
1,413 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,708 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. CyrAz 5,181 Reputation points
    2021-02-07T14:24:47.833+00:00

    Nope, not supported

    1 person found this answer helpful.
    0 comments No comments

  2. Erland Sommarskog 101K Reputation points MVP
    2021-02-07T11:08:36.497+00:00

    I like to point out that I know nothing about SCOM. However, I know how to use Google, and entered this search string: use sql server 2019 with SCOM 2016. On the top, I found a link to Microsoft documentation and inside this document I found: https://learn.microsoft.com/en-us/system-center/scom/plan-sqlserver-design?view=sc-om-2019#sql-server-requirements

    0 comments No comments

  3. dor 1 Reputation point
    2021-02-07T11:22:21.227+00:00

    I also know how to use Google. And this answer applies to SCOM 2019 and not SCOM 2016.
    If you choose SCOM 2016 at the top right, you will not find SQL 2019 as supported version.
    That is why I asked..


  4. AlexZhu-MSFT 5,551 Reputation points Microsoft Vendor
    2021-02-08T01:02:37.28+00:00

    Hi,

    As far as I know, this is not supported. To use sql2019, we need scom2019.

    Hope the above information helps.

    Alex Zhu
    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  5. System Center guy 686 Reputation points
    2021-02-22T03:44:08.557+00:00

    SQL 2019 is not on supported list of SCOM 2016
    SCOM supports following SQL server
    i) SQL Server 2016
    ii) SQL Server 2014
    iii) SQL Server 2012

    SQL 2019 only supports SCOM 2019.

    Roger

    0 comments No comments