Monday, July 7, 2014

The EXECUTE permission was denied on the object ‘xp_prop_oledb_provider’, database ‘mssqlsystemresource’

How to Fix this?
1.Map the User to MASTER Database( By Def. It will be added to Public Role)
2.USE MASTER
GO
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN
 
Reference:
 
 

No comments:

Post a Comment