MS SQL Server2014 link MS SQL Server 2000

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.