The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server


需要对执行链接数据库时,出现标题异常。那是因为目标数据没有配置好:
目标数据打开以下几个选项:

The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server
EXECUTE sp_configure 'show advanced options',1; 
GO
 
RECONFIGURE;
GO
 
EXECUTE sp_configure 'remote access',1; 
GO
 
RECONFIGURE; 
GO
 
EXECUTE sp_configure 'remote admin connections',1; 
go
 
RECONFIGURE; 
GO
 
EXECUTE sp_configure 'remote proc trans',1 ; 
GO
Source Code


接下来,启用命令行:
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server

 

The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server

 

最后是在防火墙打开:
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server

 

重启服务器。

上一篇:SQL Server 阻止了对组件 'Ad Hoc Distributed Queries' 的 STATEMENT'OpenRowset/OpenDatasource&


下一篇:dpkg: 处理软件包 xxx (--configure)时出错 解决办法