Asp.net 2.0 transaction problems

"ProgramIt can run normally if it is on the same machine as database sub-a, but if it moves the program to another machine sub-B and the database is connected to database A, the database statements cannot be operated ."

I. a. Do not use transactions. Use select statements. Can I perform distributed queries?

B. linkserver cannot operate on the local machine when performing distributed update transactions (that is, it cannot return distributed transactions)

C. DBCC traceon (3604,730 0) -- use tracking to view more detailed error information.

D.download the dtcping.exe package of msbench on two machines and run it according to readme instructions. See error information.
Http://download.microsoft.com/download/complus/msdtc/1.7/nt45/en-us/DTCPing.exe

2. Whether MSDTC is enabled for both machines.

Iii. Whether MSDTC is set correctly.
1. Open the command prompt, Run "net stop MSDTC", and then run "Net start MSDTC ".
2. Go to "Component Service Management Tools ".
3. Browse to "start management tool ".
4. Select "component service ".
A. Expand the "component service" tree and then expand "my computer ".
B. Right-click "my computer" and select "properties ".
C. On the MSDTC tab, make sure the following options are selected: Network DTC Access
Network Management
Network transactions
XA transaction
E. In addition, "DTC Logon account" must be set to "nt authority \ NetworkService ".
5. Click OK ". This will prompt you that "Ms DTC will stop and restart.
All dependent services will be stopped. Press "yes" to continue ". Click "yes" to continue.
6. Click "OK" to close the "my computer" Properties window.

4.
MSDTC depends on rpc. RPC uses port 135 to test whether port 135 is enabled. Is there a firewall? If the firewall is disabled first.
Telnet IP 135
If it is disabled, open it.

5.
For various reasons, sqloledb cannot use distributed transactions and is changed to "msdasql" ODBC connection.
Use RRAS instead of RAS. (control panel -- Management Tools -- remote service manager)
Check whether you are using remote access server (RAS) to access remote servers. if so, make sure that you have implemented routing RAS (RRAS ). linked server does not work on Ras because Ras allows only one way communication.

7. Check whether your two servers are in the same domain.
Whether to establish a trusted connection if it is not in the same domain.

8. Upgrade to SP4.

9. Upgrade MDAC to 2.6 or above, preferably 2.8.

10. Install the latest SQL patch: sp3a
Bytes ------------------------------------------------------------------------------------
To solve this problem, you must enable telnet access and port 135 (Control Panel> Administrative Tools> services> Telnet)
Select "do not require verification" When configuring MSDTC (Control Panel> Management Tools> component services> Computer> my computer> Properties> MSDTC)