Today I’m returning to one of my favorites topics … no not transformations, this time is all about “Errors and Warnings, Causes and Solutions”.
Today I encountered the following issue when I was trying to connect to a remote SQL Server database:
“The local MS DTC detected that the MS DTC on <server name> has the same unique identity as the local MS DTC. This means that the two MS DTC will not be able to communicate with each other. This problem typically occurs if one of the systems were cloned using unsupported cloning tools. MS DTC requires that the systems be cloned using supported cloning tools such as SYSPREP. Running ‘msdtc -uninstall’ and then ‘msdtc -install’ from the command prompt will fix the problem. Note: Running ‘msdtc -uninstall’ will result in the system losing all MS DTC configuration information.”
Cause
The error message is quite lucid about the main reason of this error, this normally occurs when the machines are cloned: “…systems be cloned using supported cloning tools such as SYSPREP.”
Solution
This is one of those very few cases that the error message will give us the actual cause of the problem and the solution: “Running ‘msdtc -uninstall’ and then ‘msdtc -install’ from the command prompt will fix the problem.”
So, to solve this problem you need to:
- Click Start, and then click Command Prompt.
- At the command prompt, type “msdtc -uninstall”, and then press ENTER.
- At the command prompt, type “msdtc -install”, and then press ENTER.
Note: To perform this procedure, you must have membership in Administrators, or you must have been delegated the appropriate authority.
However, after I resolve this condition by uninstalling and then reinstalling the Microsoft Distributed Transaction Coordinator service (MSDTC), when I access the BizTalk Administration Console and try to refresh (F5) the Group Hub Page I got this additional error:
“The Microsoft Distributed Transaction Coordinator (MSDTC) may not be configured correctly. Ensure that the MSDTC service is running and DTC network access is allowed on the BizTalk, SQL and SSO Master servers. For more information, see “MSDTC Configuration settings required for BizTalk Server” in the BizTalk Server Help.”
I try to restart the MSDTC service or other services like the Enterprise Single Sign-On Service without any success… to avoid spending more time on this issue, and because this was a DEV standalone machine, I decided to restart the server… and that did the trick, after the restart, everything was working without any problem.