Ran into a new error today when working with Linked Servers.

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

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

As the error mentioned above this is a distributed transaction error.

1st I verified that the "Distributed Transaction Coordinator" service was started, which it was but still got the error. I then verified in the properties of the service and made sure that all the security information was checked to allow inbound and outbound communication, still had error.

What ended up happening was my IT team cloned the servers which caused these issue.

Solution:

The cloned servers copied the same DTC names to the linked servers. To fix the issue you need to uninstall and reinstall DTC.

Ran the following command prompt commands:

Net stop medic

Msdtc –uninstall

Msdtc –install

Net start medic

The key now which is not in any other article that I have found is to:

Restart SQL Server