The partner transaction manager has banned its support for remote/network transactions

Original address



Simple Introduction

When starting a distributed transaction involving the SQL Server database engine, some configuration is required for MSDTC.

Otherwise, you may receive the following error: The partner transaction manager has disabled support for remote/network transactions.

How to Solve

1. Two-way to start the MSDTC service by: command line service.msc, select Distributed Link trackingclient. Right-click to start, and. Right-click Properties, start Type to Manual.

2. Manually set up the DTC, such as the following: Control Panel, Administrative Tools, double-click Component Services, computer, computers--My Computer->distributedlink tracking client On the Local DTC node, right-click Properties. Tick agree to remote client, agree to remote management, agree to inbound, agree to outbound, do not ask for verification. and apply the settings.

3. The above operation is under Win7, for different operating system version number (win, win2008), there may be different settings, but. Spirit: Open the MSDTC service. and set the specified configuration for the local DTC. These settings are set up according to the different operating system version number to find.

Enlightenment

When this error occurs, the first idea is to direct the wrong information to Google. But. The results are very troubling. Because they are found on the Internet are some copy and paste garbage. Could not give psychiatric advice, so a search on MSDN, very quickly found a guiding solution. One revelation to me is that Microsoft's products are a problem, or that Microsoft's own community is more practical and other products are similar.

Baidu and Google are not the ultimate tools for solving the problem.

Resources

Http://support2.microsoft.com/kb/2027550/zh-cn

Http://technet.microsoft.com/zh-cn/library/cc731495.aspx

The partner transaction manager has banned its support for remote/network transactions