SQL Server Express SP2, Error installing (KB 921896) - exit code 1

Time: 03/08/2007 10:10:28.641
KB Number: KB921896
Machine: VANDIVERPC
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
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 SP2
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\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_S QLEXPR.EXE
SQL Express Features :
SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_Shar edTools
Error Number : 1627
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\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_S QLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

************************************************** ********************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1627
__________________________________________________ ________

In the C:\Program Files\MicrosoftSQLServer\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_S QLEXPR.EXE folder there
should be a log file with "SQL" in name. Open up this file and search for "ue
3" or 1627 and copy and paste into the forums the 20 lines above and below.

Thanks,
Peter

----------------------------------------------------------------------------------------

Here are the lines from SQLSetup0011_VANDIVERPC_SQL.log

Thanks for your help.

-----------------------------------------------------------------

SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to
accept client connections
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL
Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL
Native Client][SQL Server]Changed language setting to us_english.

<Func Name='SqlComponentUpgrade'>
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
<Func Name='ProcessHeaderTable'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
MSI (s) (58!B8) [08:49:41:786]: Note: 1: 2259 2: 3: 4:
<Func Name='GetFileTargetPath'>
Error Code: 0x8007065b (1627)
Windows Error Text: Function failed during execution.
Source File Name: darlib\viewinstaller.cpp
Compiler Timestamp: Wed Jun 14 16:19:22 2006
Function Name: sqls::ViewInstaller::modify
Source Line Number: 137



---- Context -----------------------------------------------


Setting status of unmanaged components and removing unmanaged resources
Failed to modify installer view
1: 2259 2: 3: 4:



Error Code: 1627
MSI (s) (58!B8) [08:49:42:083]: Product: Microsoft SQL Server 2005 Express
Edition -- Error 2259. The installer has encountered an unexpected error. The
error code is 2259. Database: Table(s) Update failed

Error 2259. The installer has encountered an unexpected error. The error
code is 2259. Database: Table(s) Update failed
<Failure Type='Fatal' Error='1627'>
<EndFunc Name='LaunchFunction' Return='1627' GetLastError='203'>
Action ended 8:49:42: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882 C2.
Return value 3.
Action ended 8:49:42: INSTALL. Return value 3.
Property(S): ProductCode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Property(S): ProductLanguage = 1033
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.2.3042.00
Property(S): MEDIAPACKAGEPATH = \Setup\
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties =
SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLB ROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPa sswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD ;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;Servic ePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15 C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_91 3B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProduct ID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8 D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_ 9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_4 0C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_4 0C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSW ORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_ 40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0