Take the 2-minute tour ×
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.

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 "172.18.4.179\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 –  yogirk Sep 16 '12 at 15:11
    
Here is a kb article –  yogirk 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

 
discard

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

Browse other questions tagged or ask your own question.