How can I create linked server from 2012 to 2000?

Question

Post reply

How can I create linked server from 2012 to 2000?

fcaglayan

SSC Veteran

Points: 284
More actions
December 20, 2012 at 7:52 am

#271844

I want to schedule a job on SQL 2000. Actually it doesn't matter where the job work on but the data is on sql 2000 but the table is at sql 2012. How can I connect from 2012 to 2000. I can not use native client 11 because it doesn't support sql 2000 and native client 10 is not installed on 2012.
Is there an easy solution?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

No, not using SNAC 11.

http://www.sqlservercentral.com/Forums/Topic1317581-2799-1.aspx

You could try using SNAC 10 but may run into problems with DTC. See workarounds:

http://connect.microsoft.com/SQLServer/feedback/details/731869/using-sqlncli10-to-create-a-linked-server-to-sql-server-2000-causes-a-fault#

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

fcaglayan SSC Veteran Points: 284 More actions · Answer 2

That is only working if you upgraded your sql 2008 Server to 2012. But not working if you have installed sql 2012 directly because there is no SQLNCLI10 driver. So is there an easy way to install SQLNCLI10 driver?

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 3

I am not sure if it will install since you have SNAC 11 but you can find it on the SQL 2008 or SQL 2008 R2 media. There is a downloadable on Microsoft's site as well:

Microsoft® SQL Server® 2008 R2 SP1 Feature Pack > x86 or x64 sqlncli.msi

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

fcaglayan SSC Veteran Points: 284 More actions · Answer 4

Thanks for that download link. Yes I have installed Native client 10. Now I can see it in the list but still I am getting errors and the strange thing is that it doesn't matter to choose 10 , it still gives 11 connection erros.

Then I try to connect with odbc. I have described DNS at odbc and test the connection. It seems ok but when I try to add linked server for odbc again not working.

Is there any other sugestions or solutions?

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 5

Are you following the steps shown in the Workarounds area of the connect itew I linked to above? There are some restrictions depending on how you set it up.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato