Error when using MS SQL Database 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.