TBLEG
扫描微信账号

扫一扫微信二维码

SQLSERVER2012/2014链接到SQLSERVER2000的各种坑

2020-05-16 信息
区块链白皮书代写

    本文总结一下SQL SERVER 2012/2014链接到SQL SERVER 2000各种坑,都是在实际应用中遇到疑难杂症。可能会有人说怎么还在用SQL SERVER 2000,为什么不升级呢? 每个公司都会有一两个几乎快被人遗忘系统,接手维护这些系统人可能都不知换了多少批了。它们命运注定慢慢消亡。然而偏偏却又生命力顽强,总还有一些人在使用着这些系统。所以就处在一种尴尬境地: 升级吧,价值不大,可能再过一两年,这系统就要被其它系统替代了。而且项目经理也没有精力、人手耗费在这上面。最重要是担心风险问题。因为接手维护人对这些系统都不甚了解。如果贸然升级,可能风险很大。

1:SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions

    自SQL Server 2012开始,已经不支持通过链接服务器链接到SQL Server 2000。主要是SQL SERVER 2012/2014安装是SQL Server Native Client 11.0。而SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions。关于这个官方文档

已有说明,具体如下所示:

This topic discusses how various data-access components can be used with SQL Server Native Client.

Server Support

SQL Server Native Client 11.0 supports connections to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and Windows Azure SQL Database.

Supported Operating System Versions

The following table lists which operating systems support SQL Server Native Client.

SQL Server Native Client version

Supported operating systems

SQL Server Native Client (SQL Server 2005)

Microsoft Windows 2000 Service Pack 4 or later Microsoft Windows Server 2003 or later Microsoft Windows XP Service Pack 1 or later Microsoft Windows Vista (requires SQL Server Service Pack 2, or later) Microsoft Windows Server 2008 (requires SQL Server Service Pack 2, or later)

SQL Server Native Client 10.0 (SQL Server 2008)

Microsoft Windows Server 2003 Service Pack 2, or later Microsoft Windows XP Service Pack 2, or later Microsoft Windows Vista Microsoft Windows Server 2008

SQL Server Native Client 10.5 (SQL Server 2008 R2)

Microsoft Windows Server 2003 Service Pack 2, or later Microsoft Windows XP Service Pack 2 or later Microsoft Windows Vista Microsoft Windows Server 2008 Microsoft Windows 7

SQL Server Native Client 11.0 (SQL Server 2012)

Microsoft Windows Vista Microsoft Windows Server 2008 Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows Server 2012此时需要安装SQL Server Native Client 10. 我在这篇文章SQL SERVER 2012链接到SQL SERVER 2000问题解决案例里面介绍了如何安装SQL Server Native Client 10

 

2: 即使安装了SQL Server Native Client 10,依然不能使用下面常规建立链接服务器方法建立

EXEC master.dbo.sp_addlinkedserver @server = N'server_name', @srvproduct=N'SQL Server'
 
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'server_name',@useself=N'False',@locallogin=NULL,@rmtuser=N'username',@rmtpassword='########'
 
GO
全文阅读
文章关键词
SQL
Server
2012
2000
linkserver
扫描关注微信账号

试试长按二维码加关注