• 0

LogicMonitor user in MS SQL Server Error


Deepak Sharma
 Share

Question

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
 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share