The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "xxx.xxx.xxx.xxx" was unable to begin a distributed transaction.

时间：2021-09-01 21:33:23 收藏：0 阅读：16

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

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

接下来，启用命令行：

最后是在防火墙打开：

重启服务器。

原文：https://www.cnblogs.com/insus/p/15207055.html

The operation could not be performed because OLE DB provider &quot;SQLNCLI10&quot; for linked server &quot;xxx.xxx.xxx.xxx&quot; was unable to begin a distributed transaction.

The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "xxx.xxx.xxx.xxx" was unable to begin a distributed transaction.