Microsoft Service MS DTC and CA ITPAM

book

Article ID: 209546

calendar_today

Updated On:

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.

Cause

In a clustered MS SQL Server DB environment, noticed that MS SQL Server service uses MSDTC service.

Environment

Release : 4.3.5

Component : Process Automation

Resolution

ITPAM do not use MSDTC service directly. 
However, If ITPAM database is configured with MS SQL Server and it uses MSDTC Service, then set the Service to "Automatic Start" mode.

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