SQL Server 2014 Management Studio 连接sqlserver2000提示:SQL Server Native Client 11.0 不支持连接到 SQL Server 2000 或更早的版本。 安装SQL Server Native Client 10.0,接口选择SQL Server Native Client 10.0还是不行,用 以下sql语句搞定:
EXECUTE sp_addlinkedserver
@server='11.5.254.136\bjcwk33',
@srvproduct = 'sqlserver',
@provider = 'MSDASQL',
@datasrc = NULL,
@location = null,
@provstr = 'DRIVER={SQL Server Native Client 10.0};SERVER=11.5.254.136\bjcwk33;',
@catalog = NULL
GO
EXECUTE sp_addlinkedsrvlogin
@rmtsrvname='11.5.254.136\bjcwk33',
@useself='false',
@rmtuser='mts',
@rmtpassword='BJmt.100';
GO