SQL 2008, Linked Server Error: "The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource', schema 'sys'"

You setup a linked server in SQL Server Management Studio, on a SQL 2008 server and it works as expected. Another person or user logs into SQL Server Management Studio and tries to view the linked server databases (under  Server Objects > Linked Servers > LinkedServerName > Catalogs) and gets the error:

TITLE: Microsoft SQL Server Management Studio ------------------------------  Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476  ------------------------------ ADDITIONAL INFORMATION:  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)  ------------------------------  The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476  ------------------------------ BUTTONS:  OK ------------------------------

I have encountered this issue and the fix is to run this:

GRANT EXECUTE ON sys.xp_prop_oledb_provider TO [UserDomain\Account Name];

ex. GRANT EXECUTE ON sys.xp_prop_oledb_provider TO [AD\MyLogin]