For past few months, we are getting these kind of alert in SCOM stating SQL Server cannot authenticate using Kerberos. One thing to note here is that this alert is coming from only one server not other server which were built at the same time.
Also I ran this query as per suggested by MS:
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
The result is NTLM.
Still I don't get why kerberos alert is coming only for this server. My question here is when does SCOM generates this kind of alert? By searching this forum, I have found various resolutions but wasn't able to find as to why SCOM is generating this. Is there some event that triggers this?
We are using SCOM 2012 R2 and SQL MP 6.4.1.0