Forum Discussion
Mike_Moniz
Professor
3 years agoI'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
Related Content
- 4 months ago
- 5 months ago
- 2 years ago
- 2 years ago
- 7 months ago