BUG: Install of SQL Server 6.5 on Windows 2000 Modifies DTC Service (249310)
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)
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.
Modification Type: | Major | Last Reviewed: | 10/31/2003 |
---|
Keywords: | kbBug kbpending KB249310 |
---|
|