Zheng Zuo 2006-6-26
During the BizTalk project, BizTalk Server and SQL
The server is not on the same computer, and the SQL adapter is used to send data prompting the error "new transactions cannot be registered to the specified transaction processor". The same problem occurs when the SQL adapter metadata is added.
The system prompts "the SQL statement cannot be executed. Make sure that the provided syntax is correct. New transactions cannot be registered with the specified transaction processor ." I checked the information, which is caused by incorrect settings in MSDTC.
Perform the following operations on each computer. The operation steps on windwos Server 2003 are as follows,
1. Click Start, point to control panel, and click add or delete Program ".
2. In the "add or delete programs" dialog box, click "Add/delete Windows Components ".
3. On the "Windows Components" Page, select "Application Server" and click "details ".
4. Select enable Network COM + ACCESS, click OK, and then click Next ".
5. On the "complete Windows component wizard" page, click "complete ".
6. Close the "add or delete programs" dialog box.
7. Click Start, point to all programs and administrative tools, and click component service ".
8. Expand "component service" and then "computer ".
9. Right-click my computer, select properties, and click Properties ".
10. Select the "MSDTC" tab and click "Security Configuration ".
11. In the Security Settings pane, select the following options:
• Network DTC Access
• Allow remote clients
• Allow Remote Management
• Allow inbound traffic
• Allow outbound traffic
Note: In the Windows Server 2003 cluster environment, make sure that you select "verify the caller ". You must select this transaction mode.
Enable XA transaction
12. Click OK ".
13. In the "DTC console message" dialog box, click "yes" to restart the DTC.
14. In the "DTC console message" dialog box, click "OK" to confirm that the DTC has been restarted.
15. Click OK to close the my computer Properties dialog box.
16. Disable "component service MMC ".
note:
the three single options for Transaction Manager communication are
• both parties must be verified
• the caller must be verified
• not required to be verified
BR> you need to treat this setting differently in different situations,
(1) the installed system is Windows Server 2000, Windows XP without SP2, and Windows 2003 without SP1, windows XP with SP2 and Windows 2003 with SP1.
(2) whether the computer of the Windows system is in one domain, in multiple domains, or in a working group.
Note:
you can open the component service by running dcomcnfg. EXE.
the above settings may not make MSDTC normal operation, such as the system firewall settings may also cause abnormal operation, for the use of MSDTC problems, can access the http://go.microsoft.com/fwlink? Linkid = 61920.
