Workpoint XA error during Identity Manager start up

Products

• CA Identity Manager

Issue/Introduction

Seeing the following error while starting up Identity Manager, even though the MSSQL XA transaction has been enabled.

XAException occurred.  Error code is: XAER_RMERR (-3).  Exception is: Failed to initialize the stored procedure xp_sqljdbc_xa_init. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***

Environment

Identity Manager 14.5 SP1 CHF1 with Websphere

Cause

MSSQL did not sync up with  Microsoft Distributed Transaction Coordinator (MS DTC) 

Resolution

Restart MSSQL services