Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I made a linked server between two sql server instances. The remote one I have very little control over. When I try a query I get this:

Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "\JOURNYX". The provider supports the interface, but returns a failure code when it is used.

Is there any good way around this without having to do admin-level actions on the remote system?

share|improve this question
Please include the versions of SQL Server on each side, the version of SQLNCLI installed, and the security mechanism being used (e.g. what user is the linked server connecting as, and what rights does that user have on the other end). – Aaron Bertrand Sep 16 '12 at 13:48
There is a microsoft connect item for a similar issue here with some workarounds – RK Kuppala Sep 16 '12 at 15:11
Here is a kb article – RK Kuppala Sep 16 '12 at 15:22
OK, thanks. I was hoping there would be a solution that would not require acting on the remote database. – Daniel Williams Sep 16 '12 at 19:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.