SQL2000 to SQL2012 linked server connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

SQL2000 to SQL2012 linked server connection

Author

Topic

lb700
Starting Member

3 Posts

Posted - 2013-10-16 : 20:12:46

Can anyone tell me if it is possible to set up a linked server on a SQL2000 server that links to a SQL2012 server? I know it is possible the other way around.

LB700

lb700
Starting Member

3 Posts

Posted - 2013-10-16 : 20:35:38

It is SQL2000 running on Windows server 2003

LB700

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-17 : 04:34:34

you can do inverse with slight workaround

http://www.winadmins.com/2012/05/kbcreate-sql-2000-linked-server-at-sql.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

lb700
Starting Member

3 Posts

Posted - 2013-10-17 : 20:07:04

thanks, but I need a linked server on a SQL2000 server that links to a SQL2012 server, not the other way around.

LB700

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-18 : 02:00:40

I dont think thats possible as provider in 2000 will not support 2012 connection

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources