Execute permission was denied on the object xp_instance_regread database mssqlsystemresource schema
Expert User
Verified
This issue occurs when there is no access on xp_instance_regread either to anyuser or public role
USE master GO GRANT EXECUTE ON [sys].[xp_instance_regread] to public Grant Execute ON [sys].[xp_instance_regread] TO [DOMAIN\USER];
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];
Comments
Leave a Comment