January 13, 2014 at 2:20 am
Hi,
can someone help me with a problem that I am having setting up a linked server from SQL 2008 to a SQL 2000 instance?
I can set up the server, it connects, and the test connection is successful.
When I open up the Linked Server tree node in SSMS (2008), I can expand the linked server all of the way down to the individual objects (on the SQL 2000) machine.
However, if I expand the tables node and right click to select the top 1000 rows, then this option is not available.
If I write a SQL command to select data from the SQL 2000 linked server, then I get the following error:
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "SQL_2000_Linked_Server". The provider supports the interface, but returns a failure code when it is used.
Has anyone had any experience in this area?
Thanks in advance.
Neil Bryan
January 13, 2014 at 3:06 am
Probably it's just a permissions issue.
Take a look at this article http://www.sqlservercentral.com/articles/Linked+Servers/73794/
It's about setting up linked server with an out-of-process OLEDB provider, but it also contains a lot of information on how to set up security on DTC, providers etc...
Hope this helps
Gianluca
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply