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.

Please review the instance name and take appropriate action:
SQL2016SSRS user ORDS\logicmonitor.svc is sysadmin. This is not recommended

Checked the SQL Server and we have not given sysadmin rights to LogicMonitor user

Your timely help will greatly appreciated.

Regards,

Deepak
 

  • 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