When you create a Linked Server on SQL Server, some users may get this error:
EXECUTE denied on object ‘xp_prop_oledb_provider’, database ‘mssqlsystemresource’, schema ‘sys’.
So, the only thing you need (if you have set up your permissions correctly on Linked Server) is to run the following code:
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN;
If you use domain user, change login to [DOMAIN\username]
And this should solve your problem.