"This operation cannot be performed because the ole db access interface" sqlncli10 "of the linked server cannot start distributed transactions" is solved by SQL Server"

A connection server is established between two servers in the Cross-network segment. The data can be read normally. However, when a distributed transaction is updated, the system prompts "this operation cannot be performed, because the ole db access interface "sqlncli10" of the link server "XXXX" cannot start distributed transactions"

Solution:

1. Check the MSDTC settings online. For more information, see this article.

2. Modify the host settings. In c: \ windows \ system32 \ drivers \ etcTwo serversAdd the IP address and computer name of the Peer computer respectively, as shown below:

Peer computer ip Peer computer name

-------------------------------------------------

192.168.88.52
Vwin2k3-8852

3. Open the servers on both sides, then open SSMs, right-click Database Server properties, and select "distributed transactions need to be used for server-to-server communication" on the connection tab ."

Restart the database services of both parties.