This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Spotlight: Could not see any data under 'SQL Agent Jobs' after providing least privileges for monitoring account.

We are using below versions of spotlight.

Version: 12.3.0.9776

Diagnostic Server Scripts version: 30.0.0.9776

Recently we changed the privileges for our service account which getting used for the monitoring. 

http://help.spotlightessentials.com/sqlserver_connect_accountgrantpermissions.html#known-issues-with-this-script

http://help.spotlightessentials.com/windows_connect_wmiminimumpermissions.html

As per above article we have provided least privileges for monitoring account on both SQL and Windows level.

After these changes we observer that we could not see any data under 'SQL Agent Jobs' 

As per the KB we have provided required permissions on MSDB. 

SQL agent job monitoring did not work even after reverting the permissions ( providing sysadmin on SQL).

Need your help to fix this issue. Because I did see any error around this.

Parents Reply Children
No Data