如何解决由于链接服务器的ole db provider sqlncli10无法启动分布式事务而无法执行操作的问题？ [英] How to resolve the issue that operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction?

问题描述

How to resolve the issue that  operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction?

我正在使用链接服务器并将数据存档从一台服务器中的数据库存档到另一台数据库服务器中的另一个数据库



启动/启用DTC。但是当运行查询

从链接服务器数据库中的表中获取数据时，得到如下错误

I am using linked server and doing Archival of data from a DB in one server to another DB in another DB Server

The DTC is started/ enabled for the same. But while running the query
to fetch data from a Table in Linked Server Database getting the error as below

operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction

我尝试过：



DId将数据从一台服务器中的数据库存档到另一台数据库服务器中的另一台数据库

DTC启动/启用相同

但运行查询时



SET XACT_ABORT ON

BEGIN DISTRIBUTED TRANSACTION

从Test.Corporate.dbo.Employee中选择*



其中测试链接服务器

Corproate-DB

dbo-Schema

员工 - 表名

What I have tried:

DId Archival of data from a DB in one server to another DB in another DB Server
The DTC is started/ enabled for the same
But while running the query

SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
Select * from Test.Corporate.dbo.Employee

where Test-Linked Server
Corproate-DB
dbo-Schema
Employee-Table Name

推荐答案

我认为你需要安装和配置MSDTC（分布式事务处理协调器）

I think you need to install and configure MSDTC (Distributed Transaction Coordinator)

这篇关于如何解决由于链接服务器的ole db provider sqlncli10无法启动分布式事务而无法执行操作的问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！