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; …