Share via

MSDTC duplicate CID warning message in MBV report

  • Article

<CID> is duplicated on servers <Machine-1> and <Machine-2> - Check if <Machine-1> and <Machine-2> are not cluster nodes as CID must be unique on non-clustered servers!

You might see above warning message when you run MBV report on a BizTalk Server, where BizTalk DB is configured on a Windows SQL Cluster. It completely safe to ignore this warning message iff <Machine-1> and <Machine-2> are part of same cluster i.e. <Machine-1> and <Machine-2> are configured as two physical nodes of the cluster. I am assuming that MSDTC is configured as a cluster resource. However if <Machine-1> and <Machine-2> are NOT configured as a part of same cluster, then it is must to fix it, in order to run Distributed Transaction successfully.

Whenever there is a Distributed Transaction happens between two different physical machines a superior and subordinate relationship established between them, superior being the one who starts the transaction and subordinate being the one which will participate in the transaction. And we cannot flow the transaction to subordinates if they have same CID as superior. So we HAVE to make sure that we have unique CID corresponding to MSDTC resource. While working with cluster where you have MSDTC as a clustered resource, you can have only one MSDTC service running doesn't matter how many nodes you have in the cluster. So that makes it as only single MSDTC service between all the nodes and that's why they have same CID

How to check if two machines have same CID for MSDTC service and How to fix it?

1-      Open registry editor.

2-      Browse to HKCR\CID.

3-      You will see four keys under it.

4-      Each of these keys has the same tree structure and there is one sub-key called "Description".

5-      You need to go through all the Keys and search for the one which has "Description" as "MSDTC".

Note: The "Description" should be "MSDTC" only as shown below:

6-      You can follow the same steps on other interrogated machines; if they are same continue following rest of the steps to change the CID value for MSDTC.

7-      Browse to www.GuidGen.com

8-      Click on "Create new GUID".

9-      Copy the newly create GUID under "Your GUID"

10-   Rename the key with the sub-key "Description" as "MSDTC" with the newly created GUID. For e.g. in above snapshot I would rename "2e2a8d19-18e3-4df0-8306-938d43895b89".

11-   Once you renamed it, please restart "Distributed Transaction Co-ordinator" service from Services.msc.