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.

  9. Click OK.