LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Introduction

The Distributed Transaction Coordinator (MSDTC) service is a component of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers in a clustered environment.

Error Scenario

Errors may occur when duplicate CIDs exist in the same environment, or where virtual machines have been used to add capacity to an environment. Virtual machines that are mirrored often encounter this issue.
Note: The steps discussed in this article for the MSDTC configuration should be applied to the individual machines. In the case where the K2 Server and the SQL Server are separate machines, they must each be configured as described in this article.
The image below illustrates one scenario where an error was received relating to the SmartObject Server.

DTC Error
[Figure 1. DTC Related Error]

Note: This error may be encountered in standalone environments without NETCARDs.

Error Resolution


The following is a step-by-step discussion to repair the error described above. The use of external tools provided by Microsoft to assist in the diagnosis process, may be required. Links to these tools can be found at the end of the article.
Note: The steps below describe one scenario under which this error may occur. They are simplified and not all steps are shown or described
Step 1: Uninstall Network DTC (these steps apply to Windows Server 2003)
  1. From the Control Panel, click Add or Remove Programs
  2. Click Add/Remove Windows Components
  3. Click Application Server
  4. Click the Details… button
  5. Uncheck Enable network DTC access
  6. Click OK, and then click Next
Then uninstall MSDTC from the command line:
  1. Click Run on the Start menu
  2. Type CMD and press Enter
  3. On the command line type "MSDTC –uninstall" and press Enter

Step 2: Remove Registry Keys
Use the Windows Registry Editor (regedit.exe), delete the following keys and subkeys:
  • MSDTC keys in HKLM/Software/Microsoft/ MSDTC, HKLM/System/CurrentControlSet/Services/MSDTC,
  • HKEY_CLASSES_ROOT\CID (if found)
Reboot the computer

Step 3: Reinstall DTC
  1. Click Run on the Start menu
  2. Type CMD and press Enter
  3. On the command line, type "MSDTC –install" and press Enter
From the Add or Remove Program, add the Enable network DTC access feature again. Refer to the steps above for details.
  1. Click Run on the Start menu
  2. Type CMD and press Enter
  3. On the command line, type "net start msdtc" and press Enter
Once the above steps are complete, if errors are still encountered with DtcTester (link provided below) which attempts to create a temporary table on the SQL database you are trying to hit and then deletes it.

Additional Resources

Once the above steps are complete, if errors are still encountered with DtcTester (link provided below) which attempts to create a temporary table on the SQL database you are trying to hit and then deletes it. Reference the following Microsoft Knowledge Base article for more information: support.microsoft.com/default.aspx?scid=kb;EN-US;q250367 as well as the blog entry Warning: the CID values for both test machines are the same

To further assist in the diagnostic process, the following Microsoft tools are available: