To facilitate transactions between SQL Server and BizTalk Server, you must enable Microsoft Distributed Transaction Coordinator (MS DTC) on the Local Host Server (LHS).
To enable Distributed Transaction Coordinator (DTC) on the LHS:
- Click Start, click Run, type dcomcnfg and then click OK to open Component Services.
- In the console tree, expand Component Services, expand Computers, expand My Computer, expand Distributed Transaction Coordinator, and then click Local DTC.
- Right-click Local DTC and click Properties to display the Local DTC Properties dialog box.
- Click the Security tab.
-
Ensure that each of the following four options is selected, and all others are cleared:
-
Network DTC Access
-
Allow Inbound
-
Allow Outbound
-
Allow Remote Clients
-
Allow Remote Administration
-
No Authentication Required
-
- Click OK to close the Local DTC Properties dialog box. If prompted to restart the MSDTC service, click Yes.
- Close Component Services.
- Click Start, point to Administrative Tools, and then click Windows Firewall with Advanced Security.
- In Windows Firewall with Advanced Security, click Inbound Rules.
- In the Inbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.
- In Windows Firewall with Advanced Security, click Outbound Rules.
- In the Outbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.
- On the Control Panel, double-click Administrative Tools.
- In the right-hand pane, double-click Services.
- In the right-hand pane of Services (Local), right-click COM+ System Application, click Restart, and wait for the service to restart.
- Right-click and restart the Distributed Transaction Coordinator service.
- Right-click and restart the SQL Server (MSSQLSERVER) service.
- Close Services (Local), and then close Administrative Tools.