VERIFIED SOLUTION i

Need of having Distributed Transaction Coordinator(MS DTC) on Database server (SQL Server) in Portrait Dialogue

Database: SQL Server
Dialogue server connects to SQL Server system using standard OLEDB driver. In addition, this communication must support distributed transactions. Therefore,
if Application and Database (SQL Server) are on different Servers/Machines, then both requires to have distributed transaction coordinator (MS DTC) for successful communication between them.

For detailed information about configuration of distributed transaction on Application and Database server, refer MTS DCOM Setup guide shipped with installation package.
UPDATED:  November 7, 2017