Sql 2008: can't see tables in linked server.....


  • We successfully setup a linked server (sql 2008 to non-sql platform). As an "sa' I can see all the tables in the Linked server. (Under Management Studio:  Server Objects > Linked Servers > "Catalog". Drilling into catalog shows the tables on the linked server)

    On the other hand when our developers click on Catalog they get this error message:

           The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)


    1. I read in a blog that we need to run

        GRANT EXECUTE ON sys.xp_prop_oledb_provider TO [USER]

        Is that the proper soluton to the issue? (I thought that the resource database was a read only database used for sql version upgrades.)


    2. If so, what is the proper "USE" clause?  (master?)




    Friday, December 10, 2010 2:02 AM


All replies