SQLX05 SP1 Upgrade To SP2 Acted Like A Failure, But Seems To Work?

Hi guys, got an interesting scenario: I have a new Dell server with an "empty" Windows Server 2003 SE SP2 installation (all latest updates), joined to a 2003-native domain, ~60 GB/free space, 2 GB ram, P4, etc etc. I loaded up BackupExec 11d 7170, which installs SQL Server 2005 Express Edition SP1.

Before I even used Backup Exec, I knew I wanted to get SQLX05 SP2 installed. First, I followed the preliminary steps listed in the SQL Server 2005 Express Edtion SP2 readme file (backup master/model/msde and bedb/be_dlo databases, verify DB space, verify enabled services/accounts, stop dependant services).

By now it was after-hours and I was away from the office, so I logged into the server with my 2k3 Enterprise Admin account via Remote Desktop. I changed the server from Windows Update to Microsoft Update, and it found/downloaded/installed SQLX05 SP2 for me.

But about 7 minutes later, Microsoft Update told me it failed with code 0x3B30- and the Help & Support had no help for that code.

I started to look around the 'net for the error- I found that some people went into Add/Remove programs, clicked Change on SQLX05, selected the instance, and wound up clicking on "complete the suspended install"- unfortunately, it wanted the source for sqlrun_sql.msi, which I didn't have anywhere, so I clicked Cancel.

I looked at the server, and finally found the summary.txt file buried in C:program filesmicrosoft sql server90setup bootstraploghotfix. It showed passing the prereq check, product detection (2047/express), no disqual'd prods, no locked files, and then had this section:

Product Installation Status
Product : Express Database Services (BKUPEXEC)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 15152
Error Description : Unable to install Windows Installer MSI file



Then I saw the hotfix.txt file in the same directory, which had at the end:

12/19/2007 19:08:59.523 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
12/19/2007 19:08:59.523 Registry: Cannot read registry key value "Debug"
12/19/2007 19:11:30.696 EXE returned 15152: *** Shared String ID 145152 Not Found ***
12/19/2007 19:11:30.696 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
12/19/2007 19:11:30.696 Registry: Cannot read registry key value "Debug"
12/19/2007 19:11:30.696 Copy Engine: Error, unable to install EXE file: f:2f8accb14e453f672d9698d97c30d3e7HotFixExpressFilesSQLEXPR.EXE
12/19/2007 19:11:30.696 The following exception occurred: Unable to install Windows Installer MSI file Date: 12/19/2007 19:11:30.696 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 1653
12/19/2007 19:11:30.977 Watson: Param1 = Unknown
12/19/2007 19:11:30.977 Watson: Param2 = 0x3b30
12/19/2007 19:11:30.977 Watson: Param3 = Unknown
12/19/2007 19:11:30.992 Watson: Param4 = 0x3b30
12/19/2007 19:11:30.992 Watson: Param5 = copyengine.cpp@1653
12/19/2007 19:11:30.992 Watson: Param6 = Unknown
12/19/2007 19:11:30.992 Watson: Param7 = SQL9Express
12/19/2007 19:11:30.992 Watson: Param8 = @
12/19/2007 19:11:30.992 Watson: Param9 = x86
12/19/2007 19:11:30.992 Watson: Param10 = 3042
12/19/2007 19:11:30.992 Installed product: SQL9Express
12/19/2007 19:11:30.992 Installing product: SQL9Express
12/19/2007 19:11:30.992 Installing instance: SQLExpress
12/19/2007 19:11:30.992 Installing target: BKUP1
12/19/2007 19:11:30.992 Installing file: SQLEXPR.EXE
12/19/2007 19:11:30.992 Copy Engine: Creating MSI install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
12/19/2007 19:11:30.992 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
12/19/2007 19:11:30.992 Registry: Cannot read registry key value "Debug"
12/19/2007 19:12:14.305 EXE returned 0: The action completed successfully.
12/19/2007 19:12:14.305 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
12/19/2007 19:12:14.305 Registry: Cannot read registry key value "Debug"
12/19/2007 19:12:14.305 Copy Engine: Installed file: f:2f8accb14e453f672d9698d97c30d3e7HotFixExpressFilesSQLEXPR.EXE
12/19/2007 19:12:14.305 Installed target: BKUP1
12/19/2007 19:12:14.337 Installed instance: SQLExpress
12/19/2007 19:12:14.337 Installed product: SQL9Express
12/19/2007 19:12:14.337 Hotfix package completed
12/19/2007 19:12:14.337 Attempting to continue the 32 bit ngen queue

More digging found the C:program...loghotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXEFilesSQLSetup0002_BKUP1_SQL.log file- which was 6822 kb large! But there are repeated errors in it that go something like this:


SQL Server Setup has encountered the following problem:
Failed to execute the Transact-SQL statement: EXEC sp_update_user_instance N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql'
Script file:
The error was: [Microsoft][SQL Native Client][SQL Server]Cannot update user instances. Reason: Cannot start user instance 'D66F74F5-91FF-40' for update. Error code: 0x3c0c.. To continue, correct the problem, and then run SQL Server Setup again.

Error Code: 0x80073b30 (15152)
Windows Error Text: Source File Name: libodbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@HotfixDBEINST@13
Source Line Number: 91


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


sqlStatement
Originial error was 80073b30 (15152)
on SqlScript
SqlUpgradeScriptHlpr



Error Code: 15152



Now here's the strange part- I saw something on the 'net that suggested rebooting and applying it again. So I rebooted the server, went to Microsoft Update- and it didn't show that I needed the SQLX05 SP2 update. I checked the Application event log, and it showed that during the SQLX05 startup SQLX05 reported version number 9.00.3042.00! I ran a TSQL command (with sqlcmd) and systemproperty('productlevel') came back as SP2.

I finished my TSQL command, and got a popup from Microsoft Error reporting saying some errors happened recently for hotfix.exe. I clicked showdetails, and the p-vals with information were P2=0x3b30, P4=0x3b30, P5=copyengine.cpp@1653 , P7=sql9express. So I sent the report up.

Out of curiousity, I went back to Add/Remove programs, clicked on SQLX05 and "change", selected the instance, next, next, and wound up at the SQL Server Install Wizard. It STILL had a box for me to click on saying "Complete the Suspended Installation"- so I cancelled it.

But everything "looks" fine! Is it? Can I trust it?? Could Sql Server Express have automatically ran the failed sql files after the reboot?

Thanks!


-Thomas H