The OleTx CID Is The Same, The CID should be unique to each computer

Owned by Knowledge Assistant
Dec 27, 2023
1 min read





Description of Issue

When using DTCping or Test-Dtc for testing MSDTC connection between servers, the following errors are returned:

Test-Dtc: The OleTx CID on server1 and server2 is the same. The CID should be unique to each computer. 

DTC Ping: WARNING:the CID values for both test machines are the same



Context

  • MSDTC

  • Network

  • Cloned server



Cause

The CID endpoint on the two servers is identical due to improper server cloning, causing the connection to fail.



Resolution

MSDTC needs to be reinstalled on the Non-SQL server in order to generate a unique OleTx CID endpoint.

  1. Open Component Services

    1. Browse to Computers > My Computer > Distributed Transaction Coordinator

    2. Right click Local DTC and click Properties

    3. Click the Security tab

    4. Make note of current MSDTC settings

  2. Open command prompt as an administrator

    1. Run the following: msdtc -uninstall

  3. Reboot the server

  4. Open command prompt as an administrator

    1. Run the following: msdtc -install

  5. Open Component Services > Computers > My Computer > Distributed Transaction Coordinator

    1. Verify the settings are the same and before and adjust if needed



Additional Information