BUG: MSDTC Fails to Start if Different Drives/Paths Are Chosen (150020)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q150020
BUG#: 14794 (6.50)

SYMPTOMS

If you choose different drives or paths for the SQL Server binaries and data (for example, place binaries on C:\MSSQL and data on D:\MSSQL), the MSDTC is registered incorrectly. The log file is always put wherever the Master.Dat file is, but the MSDTC is registered saying it is in the DATA subdirectory beneath the binaries. (In the example above, the log would be in D:\MSSQL\DATA, but setup calls to register MSDTC saying it is in C:\MSSQL\DATA).

WORKAROUND

Use the Microsoft SQL Enterprise Manager (SEM) to reset the log. Right click the Servers, Distributed Transaction Coordinator icon and choose Configure, this will bring up the Configuration window. Choose an appropriate path and click the Reset Log button. The MSDTC service will now be able to start.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.5.
Modification Type:MinorLast Reviewed:3/14/2005
Keywords:kbBug kbsetup KB150020
©2004 Microsoft Corporation. All rights reserved.