.::: Configure Microsoft Distributed Transaction Coordinator (MSDTC). Trouble shoot Failed to restart the MS DTC Service :::.

Modules such as the Web Portal, the iOS app, and any custom built API rely on Integration Services to communicate with the database. Integration Services enables access so these programs can authenticate, read, and update information in your Perspective database.

Integration Services is based on Microsoft Distributed Transaction Coordinator (MSDTC). The MSDTC service is a component of modern versions of Microsoft Windows that are responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems.

MSDTC needs to be configured only if your database and the Perspective application reside on separate servers. 

Configure MSDTC

1. From Start, search for dcomcnfg and press Enter on your keyboard.

2. Expand the nodes in the Console pane to locate the DTC (e.g. Local DTC).

3. Right-click the DTC then click Properties.

4. Click the Security tab.

5. Under Security Settings, select the Network DTC Access

6. Under Transaction Manager Communication, select the Allow Inbound and Allow Outbound checkboxes.

7. Under Transaction Manager Communication, click the No Authentication Required radio button.

8. Select the Enable XA Transactions checkbox.

if there problem "Failed to restart the MS DTC Service. Please Examine the evenlog for futher details"

9. Change DTC Login Account to user level admin (example Administrator, teguh)

10. Klik Ok and apply. close MS DTC Properties and reopen MS DTC 

11. Repeat step 9 and change to  Network Service