MS SQL Server |
Save Like Follow

Execute permission was denied on the object xp_instance_regread database mssqlsystemresource schema

Expert User
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];

Tags

Execute permission was denied on the object xp_instance_regread database mssqlsystemresource schema

Comments

Leave a Comment