欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri

程序员文章站 2024-01-23 15:59:16
Question: SQL SERVER 通过Linkserver连接A和B 2台,A对B执行单条的增删改查没有异常(没有配置DTC) 但是开启事务后就会出现报错 Solution: 在A和B上配置DTC(控制面板→管理工具→组件服务),配置参数如下: 再次测试无异常 开启事务前Set XACT_A ......

question:

  sql server 通过linkserver连接a和b 2台,a对b执行单条的增删改查没有异常(没有配置dtc)

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri

 

但是开启事务后就会出现报错

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri

 

 


solution:

在a和b上配置dtc(控制面板→管理工具→组件服务),配置参数如下:

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri

 

 

 再次测试无异常

 The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri

开启事务前set xact_abort on 否则会报以下异常

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SDSSDFCC" was unable to begin a distri