When the BizTalk SQL adapter is applied, "new transactions cannot be registered to the specified transaction processor" appears.

When the BizTalk SQL adapter is applied, "new transactions cannot be registered to the specified transaction processor" appears.Author: Zheng Zuo Date:-6-26 while working on the BizTalk project, BizTalk Server and SQL Server are not on the same computer, when you use the SQL adapter to send data with the error message "new transactions cannot be registered to the specified transaction processor", the same problem occurs when you add the SQL adapter metadata. 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 programs ". 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 · Allow outbound attention in Windows Server 2003 cluster environment, ensure that "verification is required for the caller" is selected ". 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 the transaction manager to communicate are: verification required for both parties · verification required for the caller · verification not required. Different situations need to be treated differently for this setting, (1) The installed systems are 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.