A customer recently reported an issue to us where in their SCOM system they were receiving the following warning alert “MSSQL 2016: Service Pack Compliance” in their Operations Manager Console.
It turns out that this alert was only reporting for SQL Servers that were 2016 SP1 , after a bit of research into the SQL 2016 MP and online it turns out that when updating to SQL 2016 SP1 the following registry key was not updated to a value of 1 “HKLM:\Software\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER\Setup\SP” and this is what SCOM checks for Service Pack compliance.
To check if you have the same issue please run the below in PowerShell
Get-ItemProperty -path “HKLM:\Software\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER\Setup” | ft SP
If the above does not return a value of 1 you will need to set the key SP to 1 to resolve , to do this simply run the below command in PowerShell
Set-ItemProperty -path “HKLM:\Software\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER\Setup” -name “SP” -value 1
If you then reset the monitor in SCOM the alert should not return!
