Error monitoring 2012/2014 instances using non-SA account: "The SQL Server Agent service status cannot be determined because a registry key cannot be read due to lack of permission." (148695)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Error monitoring 2012/2014 instances using non-SA account: "The SQL Server Agent service status cannot be determined because a registry key cannot be read due to lack of permission."
Description

Monitoring SQL Server 2012/2014 instances with non-SA account gives below error message. User has executed permissions script in Deployment Guide for non-SA users. User is also local admin on monitored server.
"SQL Agent - Status: The SQL Server Agent service status cannot be determined because a registry key cannot be read due to lack of permission."
Resolution

Non-sysadmin users can use Spotlight but with some limitation. Spotlight Deployment Guide states this limitation. Refer to ‘How to grant SQL Server account permissions to a trusted user’ section on page 50.
This error should only appear in certain drilldowns.
Defect ID

SOSSE-4142
Attachments

QS_Services