Microsoft KB Archive/249310

From BetaArchive Wiki
Knowledge Base


BUG: Install of SQL Server 6.5 on Windows 2000 Modifies DTC Service

Article ID: 249310

Article Last Modified on 10/31/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition, when used with:
    • Microsoft Windows 2000 Standard Edition



This article was previously published under Q249310

BUG #: 18597 (SQLBUG_65)

SYMPTOMS

When you install SQL Server 6.5 from the CD, and you then install the Microsoft SQL Server Service Pack 5a (which is required to run SQL Server 6.5 on Microsoft Windows 2000), the service pack installation removes the Microsoft Windows 2000 version of the Distributed Transaction Coordinator (DTC) service and replaces it with the MSDTC service from the SQL Server 6.5 CD or service pack 5a. To see this, open Control Panel, double-click the Administrative Tools icon and then double-click Services.

Another way to see this is to click Start, point to Programs, point to Administrative Tools, point to Computer Management, point to System Tools, point to System Information, point to Software Environment, and then double-click the Loaded Modules folder. The Msdtc.exe process should be there. However, after you install SQL Server 6.5, Msdtc.exe is run from the Mssql\Binn folder of SQL Server 6.5, rather than the Winnt\System32 folder, and the version number for the module is not that of the original Windows 2000 (which is 1999.9.3422.24).

Another indication that this problem occurred is if you find the following entry in your Microsoft Windows Event Viewer (Application) Log:

Event Type:Error Event Source:MSDTC Event Category:SVC Event ID:4377 Date:5/21/2000 Time:3:15:24 PM User:N/A Computer:TESTCOMPUTER Description: Running "msdtc -remove" is no longer supported. To un-install MSDTC please contact product support. To configure this system to use a remote MSDTC as the coordinator please use the Component Services Explorer.


Another possible Description may be:

The description for Event ID ( 4377 ) in Source ( MSDTC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: .


CAUSE

SQL Server 6.5 and service pack 5a has an add on program, DTC, which runs as part of the larger SQL Server install process. The version checking for this DTC install package was developed prior to the creation of Windows 2000, and the DTC package is consequently unaware of the Windows 2000 version.

So, both SQL Server 6.5 and the service pack 5a installation packages run the Dtcsetup.exe from the wrong place, which in this case is from either the SQL Server 6.5 CD or service pack 5a.

WORKAROUND

If the Windows 2000 version of Dtcsetup.exe is located on either the Windows CD or in the C:\Winnt\System32 folder, and has the following properties:

  • File Version 1999.9.342x.x
  • Product Version of 3.00.00.342x



You can then run that Dtcsetup.exe file, which then properly reconfigures the Distributed Transaction Coordinator service back to the correct state.

WARNING: If the MSSQLServer service is running when you run the Dtcsetup.exe, then that service will be stopped. Also, in some cases it may be necessary to set the MSDTC and IISAdmin services to DISABLED and to then reboot the computer, before you successfully run the Dtcsetup.exe.

STATUS

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



Additional query words: w2k, win2000, win2k MSCS

Keywords: kbbug kbpending KB249310