Forum Discussion
Hi LucJad, I just went through this with my DBA's. LogicMonitor seems to work better with the wmi.user and wmi.pass on the WinSqlServer- module. What I had to do is add the wmi user and pass on the devices. The issue is that after I did that, my DBA's were seeing Logon errors which pointed to my service account. to resolve that they had to give LogicMonitor permissions to access SQL. By the way WinSqlServer was superseded by Microsoft_SqlServer_GlobalPerformancehttps://www.logicmonitor.com/support/monitoring/applications-databases/microsoft-sql-server
I hope this helps let us know how it turned out
Sorry I missed this on the databases have the DBA to set the account access to db_datareader that seems to have solved the issue with the login failures.