[Solved] Exception of type ‘System.EnterpriseServices.TransactionProxyException’ was thrown

While you’re configuring Microsoft BizTalk Server 2006 which has a database server on a remote machine, you may encounter the problem below. The Group feature failed and hence the others which depend on it are also failed.
BizTalk Failed Configuration

If you click on a red X icon in front of the failed Group feature, you’ll see the error message:
Exception of type ‘System.EnterpriseServices.TransactionProxyException’ was thrown.
Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown

This error indicates that MSDTC isn’t properly configured on the servers so you have to check if MSDTC has enabled on both BizTalk Server and SQL Server. You should first enable DTC, followed by MSDTC.

Step-by-step to solve exception of type ‘System.EnterpriseServices.TransactionProxyException’ was thrown.

  1. First, enable network DTC access on BizTalk Server. Open Add/Remove Windows Components by click Start -> Settings -> Control Panel -> Add or Remove Programs -> Add/Remove Windows Components.
    Add or Remove Programs
  2. On Add/Remove Windows Components window, select Application Server -> click Details -> Check Enable network DTC access -> Click OK. Now DTC has been enabled.
    Note: This step may requires Windows Installtion CD.
    Enable network DTC access
  3. Next, enable MSDTC. Open Component Services by Start -> Setttings -> Control Panel -> Administrative Tools -> Component Services.
    Open Component Services
  4. On Component Services window, expand Component Services -> Computers. You’ll see My Computer.
    My Computer in Component Services
  5. Right-click on My Computers and select Properties.
    Open My Computer Properties in Component Services
  6. On My Computer Properties window, select MSDTC tab and click on Security Configuration button in Transaction Configuration section.
    Open Security Configuration
  7. On Security Configuration window, verify that check boxes are checked as the figure below. Then, click OK.
    • In Security Settings section, check network DTC Access.
    • In Client and Administration section, check Allow Remote Clients and Allow Remote Administration.
    • In Transaction Manager Communication section, check Allow Inbound, Allow Outbound and select No Authentication Required.
  8. Check XA Transactions.
  9. Enable MSDTC Configurations

  10. Click OK to restart the MSDTC service.
    Restart MSDTC
  11. When the service is restarted, click OK again. Now you’ve finished on the BizTalk Server.
    MSDTC is restarted
  12. Next, enable MSDTC on the SQL Server by repeat step 3-10 on the SQL Server.
  13. Then, try to re-configure on the BizTalk Server again. Now, it’s should be success.
    Success Configure BizTalk

Reference

One Response

  1. Vimal Bhavsar September 18, 2012

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.