Setup MSDTC CID - SQL-FineBuild/Common GitHub Wiki

Previous Check MSDTC Kerberos Manual Configuration Setup MSDTC Network Access Next

FineBuild can configure MSDTC a new CID GUID for MSDTC.

Many organisations create new Windows instances by copying a master build image. This results in all MSDTC instances having the same CID (a GUID), which prevents them communicating with each other over the network. In this situation, a new CID value must be generated for MSDTC.

FineBuild MSDTC CID configuration

The MSDTC CID configuration relates to Process Id 2ACB and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupDTCCID: Yes Yes Yes
SQL2017 /SetupDTCCID: Yes Yes Yes
SQL2016 /SetupDTCCID: Yes Yes Yes
SQL2014 /SetupDTCCID: Yes Yes Yes
SQL2012 /SetupDTCCID: Yes Yes Yes
SQL2008R2 /SetupDTCCID: Yes Yes Yes
SQL2008 /SetupDTCCID: Yes Yes Yes
SQL2005 /SetupDTCCID: Yes Yes Yes

For Windows 2008 and above, the MSDTC CID processing will always be performed if Setup MSDTC Network Access is performed. For Windows 2003, the MSDTC CID processing is also performed if Setup MSDTC Network Access is performed but only if MSDTC is not being clustered.

Top

Manual MSDTC CID Configuration

The following steps show what you would have to do for manual MSDTC CID configuration. SQL FineBuild does all of this work for you automatically.

The MSDTC CID configuration is based on process documented at https://docs.microsoft.com/en-gb/archive/blogs/chiragpavecha/msdtc-duplicate-cid-warning-message-in-mbv-report

  1. Stop MSDTC by running the following command:

    NET STOP MSDTC

  2. Start Regedit and locate the registry key for MSDTC

    Browse HKCR\CID. Open each registry key in turn until you find one with a Description value of MSDTC

    CID List

  3. Obtain a new GUID value

    This can be done by visiting one of the following sites: www.GuidGen.com GuidGenerator.com

    SQL FineBuild uses a call to the system Scriptlet.TypeLib.Guid function to create the GUID

  4. Rename the MSDTC registry key

    Right-click on the key and select Rename

    Rename Key

  5. Type the new Guid value

    Key Type

    FineBuild has to copy the registry key to a new value and delete the old key

  6. Start the MSDTC service by running the following command:

    NET START MSDTC

  7. Re-initialise the MSDTC Log by running the following command:

    MSDTC -RESETLOG

Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements

Previous Check MSDTC Kerberos Top Setup MSDTC Network Access Next