BUG: Install of SQL Server 6.5 on Windows 2000 Modifies DTC Service
The information in this article applies to:
Microsoft SQL Server 6.5, when used with:
the operating system: Microsoft Windows 2000
This article was previously published under Q249310
BUG #: 18597 (SQLBUG_65)
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: .
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.
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.
Microsoft has confirmed this to be a problem in SQL Server 6.5.