Microsoft KB Archive/192707

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

Article ID: 192707

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q192707



BUG #: 18023 (SQLBUG_65)



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  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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.