I am new to Operations Manager and have started playing around with it for work. I have been through a couple of install/configuration iterations my first was with SCOM 2016 on a 2016 SQL server, and I was able to get some pretty detailed info out of my 2016 SQL Server but nothing higher. We run several environments with SQL 2019 so I tried to import the SQL Server Agnostic MP and still didn't detect the servers I was looking for just anything 2016 and under. So after a hardware failure I decided to give SCOM 2019 try to see if maybe I just needed the newer version to see my 2019 SQL servers and after a mishap with installing SQL 2019 as my SCOM DB server I fell back to SQL 2017. I installed the SQL Server Agnostic MP and I had info show up for a couple of 2012 SQL Servers and my SCOM 2017 SQL Server but still nothing for my 2019 SQL Servers.
I went to the Override Properties of MSSQL on Windows: Discover SQL Server Database Engines (Local) and there are no exclusions listed.
I noticed in Discovered Inventory under State Actions>Change Target Type I do not have and Lightweight SQL Server 2019 entries just 2012-2017.
So I need help, can someone tell me what I am doing wrong?
Thanks,
Jonathan



