PENDING Component Status - SMS_SITE_SYSTEM_STATUS_SUMMARIZER

[rhinotechie]

I have been banging my head on my desk for the past few days and yes I have a concussion now lol.
The SMS_SITE_SYSTEM_STATUS_SUMMARIZER is showing critical and when I look at the logs it is Message ID 620
Severity Type Site code Date / Time System Component Message ID Description
Error Milestone MIS 5/15/2018 7:13:57 AM Site Server info removed SMS_SITE_SYSTEM_STATUS_SUMMARIZER 620 Microsoft SQL Server reported SQL message 297, severity 16: [42000][297][Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action. Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

Any help would be greatly appreciated.

Christopher

 

[Prajwal Desai]

May i ask what's the SCCM version and SQL version installed ?. Were there any changes done to DB before you started seeing those messages ?.

 

[rhinotechie]

Hello Prajwal,

ConfigMgr version 1802 (site version 5.0.8634.1000)
SQL Server 2012 (11.0.5058)
I have not made any changes to DB

 

[rhinotechie]

Just to note I have been doing updates to ConfigMgr the past few months when they come out.

 

[rhinotechie]

Checking out the Matrix for SQL versions to what versions of ConfigMgr and going to bump up to SQL 2016.
The server is running Windows Server 2012 R2 Datacenter

 

[Prajwal Desai]

My suggestion before you install any update, ensure you have latest SQL version. I doubt whether SQL Server 2012 (11.0.5058) is supported for 1802.

 

[rhinotechie]

Hello Prajwal,
I did a prereqchk.exe from the Bin/x64 folder and ran it via cmd and showed some the prereq issues and one of them was the site summarizer. It is enabled and is not compatible with the license we have and also we are not doing inventory on software just hardware.
In Administration - Site than status summarizers I un-ticked the enable status summarizer and it is now gone out of the list of component status.