Setup MSDTC CID
| 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.
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.
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
-
Stop MSDTC by running the following command:
NET STOP MSDTC -
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
-
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
-
Rename the MSDTC registry key
Right-click on the key and select Rename
-
Type the new Guid value
FineBuild has to copy the registry key to a new value and delete the old key
-
Start the MSDTC service by running the following command:
NET START MSDTC -
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 |
|---|