SQLServer solves & quot; and cannot perform this operation because the OLE of the linked server

A linked server is created between two servers in the Cross-network segment. The server reads data normally. However, when a distributed transaction is updated, the system prompts that this operation cannot be performed, because the OLEDB access interface SQLNCLI10 of The Link server XXXX cannot start distributed transactions. Solution: 1. check MSDTC settings on the Internet. refer to article 2. modify the host settings in

A linked server is created between two servers in the Cross-network segment. The server reads data normally. However, when a distributed transaction is updated, the system prompts that this operation cannot be performed, because the ole db access interface SQLNCLI10 of the server XXXX cannot start distributed transactions. Solution: 1. check MSDTC settings on the Internet. refer to article 2. modify the host settings in

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. Under C: \ Windows \ System32 \ drivers \ etc, add the IP address and computer name of the other computer to the two servers respectively, as shown below:

Peer computer IP address peer computer name

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

192.168.88.52vwin2k3-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.