SQL2005Exp SP2 upgrade problem
Hello,
I have MS SQL Server 2005 Express SP1 and I tried to install SP2 (I'm running MS Windows 2003 R2 SP2 ENU). I used Automatic Updates service to do that. But installation was unsuccessful. In System Log is:
Installation Failure: Windows failed to install the following update with error 0x80070643: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896).
In logfile: "c:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt" is:
Time: 04/18/2007 21:26:06.593 ********************************************************************************** ********************************************************************************** ********************************************************************************** ********************************************************************************** ********************************************************************************** **********************************************************************************
KB Number: KB921896
Machine: EMA
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
Prerequisites Check & Status
SQLSupport: Passed
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP1 2005.090.2047.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU SP1 x86 EXPRESS
Products Disqualified & Reason
Product Reason
Processes Locking Files
Process Name Feature Type User Name PID
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 2
Error Description : Unable to install Windows Installer MSI file
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity
Error Number : 0
Error Description :
-
Summary
One or more products failed to install, see above for details
Exit Code Returned: 2
In "c:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log" is:
04/18/2007 21:19:31.405 ================================================================================
04/18/2007 21:19:31.468 Hotfix package launched
04/18/2007 21:19:31.687 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:31.687 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
04/18/2007 21:19:31.765 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:31.796 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
04/18/2007 21:19:31.843 Local Computer:
04/18/2007 21:19:31.890 Target Details: EMA
04/18/2007 21:19:31.984 commonfilesdir = C:\Program Files (x86)\Common Files
04/18/2007 21:19:32.030 lcidsupportdir = c:\83db43d1d74fc335c4cba4ec\1033
04/18/2007 21:19:32.077 programfilesdir = C:\Program Files (x86)
04/18/2007 21:19:32.109 programfilesdir_wow = C:\Program Files (x86)
04/18/2007 21:19:32.124 supportdir = c:\83db43d1d74fc335c4cba4ec
04/18/2007 21:19:32.124 supportdirlocal = c:\83db43d1d74fc335c4cba4ec
04/18/2007 21:19:32.124 windir = C:\WINDOWS
04/18/2007 21:19:32.124 winsysdir = C:\WINDOWS\system32
04/18/2007 21:19:32.124 winsysdir_wow = C:\WINDOWS\SysWOW64
04/18/2007 21:19:32.124
04/18/2007 21:19:32.140 Enumerating applicable products for this patch
04/18/2007 21:19:32.140 Found SQL 2005 Express product definition
04/18/2007 21:19:33.546 Enumeration: Determining QFE level for product instance SQLEXPRESS
04/18/2007 21:19:33.546 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
04/18/2007 21:19:33.546 Enumeration: Found following QFE level for product instance SQLEXPRESS: 2047
04/18/2007 21:19:33.546 Enumeration: Determining GDR branching Hotfix for product instance SQLEXPRESS
04/18/2007 21:19:33.562 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
04/18/2007 21:19:33.562 Enumeration: No GDR branch Hotfix found for product instance SQLEXPRESS
04/18/2007 21:19:33.562 Enumeration: Determining QFE level for product instance
04/18/2007 21:19:33.562 Enumeration: Cannot find following key file for product instance : c:\Program Files (x86)\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
04/18/2007 21:19:33.562 Enumeration: Determining GDR branching Hotfix for product instance
04/18/2007 21:19:33.562 Enumeration: Cannot find following key file for product instance : c:\Program Files (x86)\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
04/18/2007 21:19:33.562 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:33.562 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
04/18/2007 21:19:33.562 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:33.562 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
04/18/2007 21:19:33.562 Product discovery completed during the install process for SQLEXPRESS
04/18/2007 21:19:33.562 SP Level check completed during the install process for SQLEXPRESS
04/18/2007 21:19:33.562 Product language check completed during the install process for SQLEXPRESS
04/18/2007 21:19:33.562 Product version check completed during the install process for SQLEXPRESS
04/18/2007 21:19:33.562 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:33.562 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
04/18/2007 21:19:33.562 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/18/2007 21:19:33.562 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
04/18/2007 21:19:33.562 Product discovery completed during the install process for SQLExpress
04/18/2007 21:19:33.562 SP Level check completed during the install process for SQLExpress
04/18/2007 21:19:33.562 Product language check completed during the install process for SQLExpress
04/18/2007 21:19:33.562 Product version check completed during the install process for SQLExpress
04/18/2007 21:19:33.562 Command-line instance name check completed during the install process
04/18/2007 21:19:33.562 SKU check completed during the install process for SQLEXPRESS
04/18/2007 21:19:33.562 SKU check completed during the install process for SQLExpress
04/18/2007 21:19:33.562 Baseline build check completed during the installation process for SQLEXPRESS
04/18/2007 21:19:33.562 Baseline build check completed during the installation process for SQLExpress
04/18/2007 21:19:33.577 Baseline build check completed during the install process
04/18/2007 21:19:33.577 Product Enumeration Results:
04/18/2007 21:19:33.577 INF File Name: c:\83db43d1d74fc335c4cba4ec\HotFixExpress.inf
04/18/2007 21:19:33.577 baselinebuild = 1399
04/18/2007 21:19:33.577 build = 3042
04/18/2007 21:19:33.577 description = Express Database Services
04/18/2007 21:19:33.577 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
04/18/2007 21:19:33.577 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
04/18/2007 21:19:33.577 kbarticle = KB921896
04/18/2007 21:19:33.577 kbarticlehyperlink =http://support.microsoft.com/?kbid=921896
04/18/2007 21:19:33.577 lcid = 1033
04/18/2007 21:19:33.577 legalproductname = SQL Server Express Database Services 2005
04/18/2007 21:19:33.577 machinetype = x86
04/18/2007 21:19:33.577 package = HotFixExpress
04/18/2007 21:19:33.577 packagetype = SP
04/18/2007 21:19:33.577 productname = SQL9Express
04/18/2007 21:19:33.577 relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
04/18/2007 21:19:33.577 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
04/18/2007 21:19:33.577 sku = EXPRESS
04/18/2007 21:19:33.577 splevel = 2
04/18/2007 21:19:33.577 sqlutility = sqlcmd.exe
04/18/2007 21:19:33.577 supportdir = c:\83db43d1d74fc335c4cba4ec
04/18/2007 21:19:33.577 validateauthentication = true
04/18/2007 21:19:33.577 version = 9
04/18/2007 21:19:33.577
04/18/2007 21:19:33.593 File Group Details: EXE
04/18/2007 21:19:33.593 parameters = INSTANCENAME=<NAME>
04/18/2007 21:19:33.593 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/18/2007 21:19:33.593 File Details: SQLEXPR.EXE
04/18/2007 21:19:33.593
04/18/2007 21:19:33.593 Instance Details: SQLEXPRESS
04/18/2007 21:19:33.593 associatedhotfixbuild = 0
04/18/2007 21:19:33.593 clustername =
04/18/2007 21:19:33.593 features = SQL_Data_Files,SQL_Engine,SQL_SharedTools
04/18/2007 21:19:33.593 fullversion = 2005.090.2047.00
04/18/2007 21:19:33.593 hiveregpath = Software\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1
04/18/2007 21:19:33.593 id = MSSQL.1
04/18/2007 21:19:33.593 installsqldatadir = c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL
04/18/2007 21:19:33.593 installsqldir = c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL
04/18/2007 21:19:33.593 lcid = 1033
04/18/2007 21:19:33.593 name = SQLEXPRESS
04/18/2007 21:19:33.593 productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
04/18/2007 21:19:33.593 qfelevel = 2047
04/18/2007 21:19:33.593 servicename = MSSQL$SQLEXPRESS
04/18/2007 21:19:33.593 sku = EXPRESS
04/18/2007 21:19:33.593 sp = 1
04/18/2007 21:19:33.593 type = SQL Server Standalone Product
04/18/2007 21:19:33.593 vermajbld = 2047
04/18/2007 21:19:33.593 version = 9
04/18/2007 21:19:33.593 wow64 = true
04/18/2007 21:19:33.593
04/18/2007 21:19:33.593 Instance Details: SQLExpress
04/18/2007 21:19:33.593 associatedhotfixbuild = 0
04/18/2007 21:19:33.593 clustername =
04/18/2007 21:19:33.593 expressrsstandalone = true
04/18/2007 21:19:33.593 features = Client_Components,Connectivity
04/18/2007 21:19:33.593 hiveregpath = Software\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools
04/18/2007 21:19:33.593 id =
04/18/2007 21:19:33.593 installsqldatadir =
04/18/2007 21:19:33.609 installsqldir = c:\Program Files (x86)\Microsoft SQL Server\90\Tools\
04/18/2007 21:19:33.609 lcid = 1033
04/18/2007 21:19:33.609 name =
04/18/2007 21:19:33.609 productcode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}
04/18/2007 21:19:33.609 servicename = MSSQL$
04/18/2007 21:19:33.609 sku = EXPRESS
04/18/2007 21:19:33.609 sp = 1
04/18/2007 21:19:33.609 type = Tools Only
04/18/2007 21:19:33.609 vermajbld = 2047
04/18/2007 21:19:33.609 version = 9
04/18/2007 21:19:33.609 wow64 = true
04/18/2007 21:19:33.609
04/18/2007 21:19:33.609 Authenticating user using Windows Authentication
04/18/2007 21:19:33.609 SQL Service MSSQL$SQLEXPRESS was previously running, ready for authentication
04/18/2007 21:19:34.484 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
04/18/2007 21:19:34.484 Registry: Cannot read registry key value "PendingFileRenameOperations"
04/18/2007 21:19:34.484 Locked file: Checking for locked files
04/18/2007 21:19:34.530 Attempting to pause the 32 bit ngen queue
04/18/2007 21:19:35.280 Installing product: SQL9Express
04/18/2007 21:19:35.312 Installing instance: SQLEXPRESS
04/18/2007 21:19:35.343 Installing target: EMA
04/18/2007 21:19:35.359 Validating database connections using Windows Authentication
04/18/2007 21:19:35.671 Pre-script database connection check was successful - proceeding with script execution
04/18/2007 21:19:36.030 Received list of RANU pid's
04/18/2007 21:19:36.030 Validating database connections using Windows Authentication
04/18/2007 21:19:36.343 Pre-script database connection check was successful - proceeding with script execution
04/18/2007 21:19:36.359 Stopping service: MSSQL$SQLEXPRESS
04/18/2007 21:19:48.390 Stopped service: MSSQL$SQLEXPRESS
04/18/2007 21:19:48.390 Installing file: SQLEXPR.EXE
04/18/2007 21:19:48.390 Copy Engine: Creating MSI install log file at: C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
04/18/2007 21:19:48.390 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/18/2007 21:19:48.390 Registry: Cannot read registry key value "Debug"
04/18/2007 21:24:39.515 EXE returned 2: *** Shared String ID 130002 Not Found ***
04/18/2007 21:24:39.577 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/18/2007 21:24:39.671 Registry: Cannot read registry key value "Debug"
04/18/2007 21:24:39.749 Copy Engine: Error, unable to install EXE file: c:\83db43d1d74fc335c4cba4ec\HotFixExpress\Files\SQLEXPR.EXE
04/18/2007 21:24:39.859 The following exception occurred: Unable to install Windows Installer MSI file Date: 04/18/2007 21:24:39.827 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 1653
04/18/2007 21:24:46.999 Watson: Param1 = Unknown
04/18/2007 21:24:47.093 Watson: Param2 = 0x2
04/18/2007 21:24:47.218 Watson: Param3 = Unknown
04/18/2007 21:24:47.312 Watson: Param4 = 0x2
04/18/2007 21:24:47.437 Watson: Param5 =copyengine.cpp@1653
04/18/2007 21:24:47.562 Watson: Param6 = Unknown
04/18/2007 21:24:47.655 Watson: Param7 = SQL9Express
04/18/2007 21:24:47.702 Watson: Param8 = @
04/18/2007 21:24:47.765 Watson: Param9 = x86
04/18/2007 21:24:47.843 Watson: Param10 = 3042
04/18/2007 21:24:47.905 Installed product: SQL9Express
04/18/2007 21:24:47.999 Installing product: SQL9Express
04/18/2007 21:24:48.109 Installing instance: SQLExpress
04/18/2007 21:24:48.187 Installing target: EMA
04/18/2007 21:24:48.280 Installing file: SQLEXPR.EXE
04/18/2007 21:24:48.312 Copy Engine: Creating MSI install log file at: C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
04/18/2007 21:24:48.343 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/18/2007 21:24:48.468 Registry: Cannot read registry key value "Debug"
04/18/2007 21:26:06.171 EXE returned 0: The action completed successfully.
04/18/2007 21:26:06.202 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/18/2007 21:26:06.202 Registry: Cannot read registry key value "Debug"
04/18/2007 21:26:06.202 Copy Engine: Installed file: c:\83db43d1d74fc335c4cba4ec\HotFixExpress\Files\SQLEXPR.EXE
04/18/2007 21:26:06.202 Installed target: EMA
04/18/2007 21:26:06.359 Installed instance: SQLExpress
04/18/2007 21:26:06.359 Installed product: SQL9Express
04/18/2007 21:26:06.359 Hotfix package completed
04/18/2007 21:26:06.359 Attempting to continue the 32 bit ngen queue
The funny is, that SQL Server now identity itself like SQL Server 9.0.3042, what means, that it is SP2. I tried to download SP2 and install it manually and it says, that it is not needed. So, what should I do now? Was installation successful or not?
Viktor Placek
