Http://expert.csdn.net/Expert/topic/2835/2835706.xml? Temp =. 1959955.
Reply to: j9988 (j9988)
I. a. No transaction is required, and the SELECT statement is used. Can it be distributed? Query ?
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 Tool ".
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. 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 edition -- Administrative 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 your two servers Server Whether it is 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. Yes Install Latest SQL patch: sp3a
'Location Of All Patches
Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 9032f608-160a-4537-a2b6-4cb265b80766
'The patch to be installed SQL 2000 sp3
Http://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.exe
My solution is: net stop MSDTC ", and then run" Net start MSDTC "to enable the Service.
