Microsoft Service MS DTC and CA ITPAM

Products

• CA Process Automation Base

Issue/Introduction

MSDTC (Microsoft Distributed Transaction Coordinator) is a Windows service that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems.

Environment

CA Process Automation 4.3.5 and higher

 

Cause

In a clustered MS SQL Server DB environment, noticed that MS SQL Server service is dependent on MSDTC service.

Resolution

ITPAM does not use MSDTC service. 

Since SQL Service is dependent on MSDTC service in a cluster environment, set the MSDTC service startup type to "Automatic Start". 

For more information on MSDTC service, please refer:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-availability-group-for-distributed-transactions?view=sql-server-ver15