Linked server was unable to begin a distributed transaction----it works for me.

来源：互联网发布：asp查询系统源码编辑：程序博客网时间：2024/05/22 18:21

Recently, I run into somes issues about linked server like below:

Error message 1:

OLE DB provider "SQLNCLI10" for linked server "xxxxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".

Msg 7391, Level 16, State 2, Line 1

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

Error message 2:

OLE DB provider "SQLNCLI10" for linked server "xxxxx" returned message "No transaction is active.".

Msg 7391, Level 16, State 2, Line 1

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

Solutions like below snapsots:

Adminstrative tools-->Component Services--right click local DTC and modify DTC properties.

Modify the Linked Server Properties.

Method 1: EXEC sp_serveroption @server = 'xxxxx',@optname = 'remote proc transaction promotion', @optvalue = 'false'
Mothod 2: as below snapshot.