Execute permission was denied on the object xp-msver database mssqlsystemresource
Expert User
Verified
This issue occurs when there is no access on xp_msver either to anyuser or public role
USE master GO GRANT EXECUTE ON [sys].[xp_msver] to public GRANT EXECUTE ON [sys].[xp_msver] to [your user name]
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_msver] to public
GRANT EXECUTE ON [sys].[xp_msver] to [your user name]
Comments
Leave a Comment