Add to collection
Expert User

Expert User

Verified

Execute permission was denied on the object xp_instance_regread database mssqlsystemresource schema

This issue occurs when there is no access on xp_instance_regread either to anyuser or public role

For eliminating this issue, please provide the access to the particular user or public role for all users

USE master

GO

GRANT EXECUTE ON [sys].[xp_instance_regread] to public

Grant Execute ON [sys].[xp_instance_regread] TO [DOMAIN\USER];

USE master
GO
GRANT EXECUTE ON [sys].[xp_instance_regread] to public
Grant Execute ON [sys].[xp_instance_regread] TO [DOMAIN\USER];

Comments 0

  • Sorry!! No comment posted yet. Become the first user to give comment.
Add a comment

Would you like to write for w3 sniff?

Become part of an amazing group of contributors and authors and start writing for us

Join Now
USE master
GO
GRANT EXECUTE ON [sys].[xp_instance_regread] to public
Grant Execute ON [sys].[xp_instance_regread] TO [DOMAIN\USER];
Feedback submitted successfully.