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

    Question

  • 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?)

     

    TIA,
    Barkingdog

     

    Friday, December 10, 2010 2:02 AM

Answers

All replies