PRB: Desktop Engine Upgrade of MSDE 1.0 Fails (271887)


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
This article was previously published under Q271887

SYMPTOMS

When you try to upgrade Microsoft SQL Server 7.0 Microsoft Data Engine (MSDE) 1.0 with Microsoft SQL Server 2000 Desktop Engine, the following error message may occur:
Microsoft SQL Server Desktop Engine

Upgrade process failed. Check the log files for more
information. You can run setup again to complete the upgrade.

[ OK ]
After the preceding error message occurs, you may not be able to restart the SQL Server service. The SQL Server error log file may look similar to this example: 
2000-08-19 23:15:21.22 server    Microsoft SQL Server  2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows 4.10 (Build 1998:   )
2000-08-19 23:15:21.22 server    Copyright (C) 1988-2000 Microsoft Corporation.
2000-08-19 23:15:21.22 server    All rights reserved.
2000-08-19 23:15:21.23 server    Server Process ID is -117121.
2000-08-19 23:15:21.23 server    Logging SQL Server messages in file 'C:\MSSQL7\LOG\ERRORLOG'.
2000-08-19 23:15:21.31 server    SQL Server is starting at priority class 'normal'(1 CPU detected).
2000-08-19 23:15:21.73 server    SQL Server configured for thread mode processing.
2000-08-19 23:15:21.80 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2000-08-19 23:15:22.16 spid3     Starting up database 'master'.
2000-08-19 23:15:24.68 spid3     0 transactions rolled back in database 'master' (1).
2000-08-19 23:15:25.01 spid5     Starting up database 'model'.
2000-08-19 23:15:25.07 spid3     Server name is 'COMPUTERS_NAME'.
2000-08-19 23:15:25.73 server    SuperSocket Info: Bind failed on TCP port 1433.
2000-08-19 23:15:25.75 spid3     Starting up database 'msdb'.
2000-08-19 23:15:25.84 server    SQL server listening on TCP, Shared Memory.
2000-08-19 23:15:25.90 server    SQL server listening on 199.99.99.99:1433, 127.0.0.1:1433.
2000-08-19 23:15:25.93 server    SQL Server is ready for client connections
2000-08-19 23:15:26.39 spid5     Clearing tempdb database.
2000-08-19 23:15:26.71 spid3     Converting database 'msdb' from version 515 to the current version 539.
2000-08-19 23:15:28.99 spid5     Starting up database 'tempdb'.
2000-08-19 23:15:32.90 spid3     Error: 50000, Severity: 22, State: 127
2000-08-19 23:15:32.90 spid3     sp_msupg_upgradecatalog detected inconsistent versioning!.
2000-08-19 23:15:32.93 spid3     Process ID 3 has raised user error 50000, severity 22. SQL Server is terminating this process.
2000-08-19 23:15:33.03 spid3     Recovery complete.
The SQL Server 2000 Desktop Engine Edition does not create a Sqlstp.log file, which is normally used to determine the reason for installation problems. Instead, you can use a command line parameter with the SQL Server 2000 Desktop Engine setup or upgrade, which allows you to specify a location for a written log that records the progress of the installation. If the installation or upgrade fails with the error message shown in the "Symptoms" section, and the reason for the error is the lack of a proper entry in the path for the current MSDE installation, then your log file will have a section similar to this excerpt: 
Loading extended custom action library sqlcax.dll
Starting custom action NoRebootReplace
RollbackCleanup: File: D:\Config.Msi\33cac3.rbf
RollbackCleanup: File: D:\Config.Msi\33cac4.rbf
RollbackCleanup: File: D:\Config.Msi\33cac5.rbf
RollbackCleanup: File: C:\Config.Msi\33cb27.rbf
Action ended 15:25:47: InstallFinalize. Return value 1.
Action start 15:25:48: DetectReboot.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 15:25:48: DetectReboot.2D02443E_7002_4C0B_ABC9_EAB2C064397B. 
Return value 1.
Action start 15:25:48: 
UpgradeDatabases.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Loading extended custom action library sqlcax.dll
Starting custom action UpgradeDatabases
Stopping service
Starting service
Upgrading master database
Upgrade process failed. Check the log files for more information. You can run setup again to complete the upgrade.
Upgrade process returned error code 1
Action ended 15:27:32: 
UpgradeDatabases.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
Action start 15:27:32: 
RemoveSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 15:27:32: 
RemoveSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
Action start 15:27:32: RemoveExistingProducts.
Action ended 15:27:32: RemoveExistingProducts. Return value 1.
Action ended 15:27:32: INSTALL. Return value 1.
=== Logging stopped: 8/2/00  15:27:54 ===
MSI (c) (5B:1F): Product: Microsoft SQL Server Desktop Engine -- 
Installation operation completed successfully.

CAUSE

The problem in this case is the Path statement. The error message can occur if the path statement does not contain the path to the Sqlservr.exe file. For example:

(C:\Windows;C:\Mssql7\Binn;C:\)

WORKAROUND

Microsoft Windows 98

On a Microsoft Windows 98-based computer, edit the Path statement in the Autoexec.bat file and either add or correct the path to MSDE 1.0.

Microsoft Windows NT or Microsoft Windows 2000

On a Microsoft Windows NT-based computer or a Microsoft Windows 2000-based computer, use the System applet in Control Panel to edit the Environment Variables and either add or correct the path for MSDE 1.0 in the Path statement.

MORE INFORMATION

Before you start to run an installation or an upgrade check the following:
  • The Path statement must specify the directory location for the Sqlservr.exe file for the version of MSDE that is currently installed on the computer.

  • The SQL Server service (Sqlservr.exe) must not be running; otherwise, the error message may occur.
Following is an example of how you can initiate the installation or upgrade process:

Command Line

setup.exe /i Setup\SqlRun01.msi /settings setup.ini /l*v c:\msde_install.txt

Setup.ini

[Options]
UPGRADE=1
UPGRADEUSER=sa

Modification Type:MajorLast Reviewed:7/28/2001
Keywords:kbDSupport kbprb KB271887
©2002 Microsoft Corporation. All rights reserved.