Forum Discussion

Deepak_Sharma's avatar
Deepak_Sharma
4 years ago

LogicMonitor user in MS SQL Server Error

We are getting frequent error as stating below Microsoft SQL Server on DEVSHLSQLAPP01.corp.ords.com.au has a configuration problem or has a logon error placing the device into error level. ...
Mike_Moniz's avatar
Mike_Moniz
Icon for Professor rankProfessor
4 years ago

I'm not sure about this exact issue but looking at the Microsoft_SQLServer_Troubleshooter DataSource code, LM checks for sysadmin access by using the below SQL statement and checking if userstatus = 1 (basically). Perhaps logicmonitor.svc is part of a group that is sysadmin?

SELECT IS_SRVROLEMEMBER('sysadmin', SYSTEM_USER) as userstatus