MS SQL Server2014 link MS SQL Server 2000

Original: MS SQL Server2014 link MS SQL Server 2000

In development and enterprise applications, several versions of SQL Server are linked to each other. Distributed reading and storage requires implementation of sp_addlinkedserver. SQL Server, SQL Server 2012, and SQL Server 2014:



But today in the native MS SQL Server 2014, to add a link to SQL Server 2000, use the following method:
SQL Server creates some stored procedures and examples of linked servers http://www.cnblogs.com/insus/archive/2009/06/22/1508648.html This method is executed in SQL Server 2008, There is no problem, it can add a link to SQL Server 2000, but in SQL Server 2008 or later versions, such as version 2012 or 2014, it runs normally, but when you browse the linked Server, the following exception occurs:



When the program runs, the following exceptions occur:



Try to go online to see if there is a workaround. Results in an English site to see a netizen reply, said can specify the version, but he did not post any code examples. Below is insus.net according to
SQL server creates some stored procedures and examples of linked servers http://www.cnblogs.com/insus/archive/2009/06/22/1508648.html here:

EXECUTEsp_addlinkedserver@server='DB1',  @srvproduct = 'SQL Server',  @provider = 'Msdasql',  @datasrc = NULL,  @location = NULL,  @provstr = 'driver={sql Server Native Client 10.0}; server=xxx.xxx.xxx.xxx;', @catalog = NULLGOEXECUTEsp_addlinkedsrvlogin@rmtsrvname='DB1',@useself='false',@rmtuser='SA',@rmtpassword='Password';GO

View Code

The above implementation process is due to the fact that several versions of SQL Server have been installed on the machine. If your PC only installs SQL Server 2014, there is no other version. To add additional servers to SQL Server 2000, you need to download SQL Server Native Client 10:http://msdn.microsoft.com/zh-cn/library/ms131321.aspx After entering the link, you can select "Other versions":

Hehe, but also solved a seemingly unable to solve the problem.