KB192707 - BUG: MS DTC Is Removed If SQL Server Registry Rebuild Is Run

Article ID: 192707

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q192707

SYMPTOMS

If you run a registry rebuild while the Microsoft Distributed Transaction Coordinator (MS DTC) service is running, the MS DTC service will be removed or marked for deletion. While running registry rebuild, you may receive the following message:

Failed to change the configuration of the MSDTC Service

WORKAROUND

To avoid removing the MS DTC service, make sure that the service is stopped before you run the registry rebuild. If you have removed the MS DTC service, running registry rebuild again adds MS DTC as a service. For more information, including the syntax of the registry rebuild command, see the following article in the Microsoft Knowledge Base:

157805 : BUG: RegistryRebuild Option of Setup Is Not Documented

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

MORE INFORMATION

The MS DTC service may immediately be removed as a Windows NT service, or may still be listed as a running service. If you attempt a distributed transaction, the BEGIN DISTRIBUTED TRANSACTION statement will fail with the following error:

"DTC on server <sever_name> is unavailable."

Another symptom is that MS DTC may not be listed in SQL Enterprise Manager. Also, you may be able to stop the MS DTC service but upon restarting the service through Enterprise Manager, you may receive the following message:

An error 1072 - (The specified service has been marked for deletion)
occurred while performing this service operation on the MSDTC service.

Additional query words: dist tran

Keywords: kbbug kbnofix KB192707