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

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.