Resolve solutions that cannot be started for OLE DB distributed transactions in Windows 2003+sql2000

window| Distributed | solution

When developing distributed database software, you often encounter the following error:
Server: Message 7391, Level 16, State 1, line 6
The operation could not be performed because the OLE DB provider ' SQLOLEDB ' could not start the split
Cloth-type transactions.
[OLE/DB provider returned message: cannot be in the specified transaction processor
Get a new transaction. ]
-----------------------------------------
Server: Message 8520, Level 20, State 1, line 8
Commit of internal MSDTC transaction failed: Result Code = 0x8004d019.

Connection interrupted
-----------------------------------------
Searching for solutions to similar problems on the Web, the following methods are recommended (method one):
1, run Regedt32, browse to HKEY_LOCAL_MACHINE OFTWARE\MICROSOFT\MSDTC.
Add a DWORD value turnoffrpcsecurity, the value data is 1.
2, restart MS DTC service.
3, open the Administrative Tools, "Component Services."
A. Browse to the Start administration tool.    B. Select Component Services.    C. Expand the Component Services tree, and then expand My Computer.     D. Right-click My Computer and choose Properties. In the MSDTC tab, make sure the following options are selected:
Network DTC access network Management network transaction XA transaction
In addition, the DTC login account must be set to "NT AUTHORITY\NetworkService". 4, restart MS DTC service.
5, run Regedt32 again, browse to HKEY_LOCAL_MACHINE OFTWARE\MICROSOFT\MSDTC, and then delete turnoffrpcsecurity items.

But in fact, this method basically can not solve the problem, after a long period of repeated practice, I finally follow the following method to solve:
(Method II)
1, in accordance with method one of the methods of processing, if not, and then continue the following method
2, install Windows 2003 SP1, after installation, method one of the 4th step of the dialog box and the original is not the same, select "Transaction Management Communication", "Do not require authentication"
3, it is best to install good MDAC2.8
3, by looking, in C: Find a file named "hosts" (no extension), usually the path is C:\WINDOWS\SYSTEM32\DRIVERS\ETC, the other server's IP and computer, refer to the following:
========================================
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#www.knowsky.com
# This file contains the mappings's IP addresses to host names. each
# entry should is kept on a individual line. The IP address should
# is placed in the ' the ' followed by the corresponding host name.
# The IP address and the host name should is separated by at least one
# space.
#
# Additionally, comments (such as) may is inserted on individual
# lines or following the machine name denoted by a ' # ' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source Server
# 38.25.63.10 x.acme.com # x client Host

127.0.0.1 localhost
192.168.1.2 Center
192.168.1.3 West Station
192.168.106.35 Information Center 2
=============================================
Be sure to modify the Hosts file for each server
Through the above methods, my distribution will be able to run normally, the speed is very fast