Microsoft KB Archive/271887

= PRB: Desktop Engine Upgrade of MSDE 1.0 Fails =

Article ID: 271887

Article Last Modified on 7/28/2001

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)

-



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 &quot;Symptoms&quot; 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

Keywords: kbprb KB271887

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.