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)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

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

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request or Create a KB Article »

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

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)

Title

Description

Resolution

Defect ID

Attachments

Leave a Comment