Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you run a distributed transaction on a SQL Server 2005-based or SQL Server 2000-based failover cluster: "Resource Manager creation failed: result code = 0x8004d102"

View products that this article applies to.


You use the Microsoft Distributed Transaction Coordinator (MS DTC) to run a distributed transaction on a Microsoft SQL Server 2005-based or Microsoft SQL Server 2000-based failover cluster. However, a fatal error occurs. When this problem occurs, SQL Server may not connect to MS DTC. Additionally, the following error message may be written to the SQL error log:
Resource Manager Creation Failed: Result Code = 0x8004d102

↑ Back to the top


This problem occurs when SQL Server exits with a fatal error, the computer that is running SQL Server does not disconnect from MS DTC, and failover occurs. In this scenario, MS DTC assumes that the following conditions are true:
  • Two computers that are running SQL Server have the same GUID.
  • The two computers are trying to connect to the same MS DTC resource.
This behavior causes SQL Server not to connect to MS DTC.

↑ Back to the top


To resolve this problem, use one of the following methods:
  • Restart the MS DTC resource in the cluster.
  • Create a MS DTC resource in the same cluster group as SQL Server.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: KB924151, kbtshoot, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 924151
Revision : 5
Created on : 12/1/2006
Published on : 12/1/2006
Exists online : False
Views : 288