Neophyte
NeophyteJosiahBenoitI need SQL Server Services (Browser, Agent,...) monitoring for non-admin service account. Logic Monitor documentation doesn't have info about Logic Monitor's Active Discovery related to this specific issue. I set up permissions but Logic Monitor still doesn't pick anything up from server after running active discovery.
NeophyteHi Lucjad, Just as a clarifying question in the datasource when you test Active Discovery does the resource you are attempting to monitor appear in the list?
NeophyteYes, but the DataSource I am looking for these services is SQLServer Services not the Microsoft Windows Services.
I am trying to set it up for non-admin service account. Changed SDDL permissions to have the same access as the local admin service account but Logic Monitor’s Active Discovery doesn’t seem to be picking anything up.
after adding permissions I performed WBEM test and non admin account reads all the sql services from admin account but Logic Monitor’s active discovery doesn’t work on this.
NeophyteWhat "AppliesTo" statement is on your datasource? The reason I have asked is that I have had to manual add resources in the past. My example would be I have a single "Postgres" Database and that took some work to add to LogicMonitor.
NeophyteApplies to: hasCategory(“MSSQL”) && !hasCategory(“WSFC_VNN”)
but for non-admin service account other devices don’t pick any information in Logic Monitor about SQL Server Services.
I am looking for not doing it manually because I have about 200ish servers to do it for. After setting things right for non-admin service account I should be able to run active discovery and get the monitoring for this datasource. It works for collector because it has local admin service account but it doesn’t work for non-admin account. Logic Monitor has documentation but I guess it’s not complete.
Professorbut the DataSource I am looking for these services is SQLServer Services not the Microsoft Windows Services.
What do you mean by this? Is the SQLServer services you want not listed when you look at Services in Computer Management? SQLServer services is a type of windows service if I understand your situation.
Yes...
So when you run an Autodiscover test it DOES shows the MSSQL Services but it does not show as an instance in the Resources page?
NeophyteI see the services on the server itself. Auto discovery in Logic Monitor doesn’t recognize these services from the server. The datasource is not even listed under the server in Logic Monitor.
