Saturday, 18 December 2010

Error when using Link Server

The execute permission was denied on the object ‘xp_prop_oledb_provider’

Fix::
GRANT EXECUTE ON xp_prop_oledb_provider TO [UserDomain\Account Name];

setupadmin and sysadmin should have in server role for the UserDomain\Account Name user.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)