• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1626
  • Last Modified:

SQL Server Express 2005 SP Install Issues

Hi All

We have had issues with getting SP2-3- or 4 onto our DC (also Backup Exec 2010 Server) and it is failing with the following errors:

C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\hotfix.log

Time: 05/03/2011 21:57:23.062
KB Number: KB2463332
Machine: CHG-SRVR2
OS Version: Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 4
Package Version: 5000
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 (BKUPEXEC)      ENU       SP1    2005.090.2047.00  x86       EXPRESS
Express Database Services (SQLExpress)    ENU       SP4                     x86       EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason

**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID

**********************************************************************************
Product Installation Status
Product                   : Express Database Services (BKUPEXEC)
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_KB2463332_SQLEXPR.EXE
SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number              : 1332
Error Description         : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product                   : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final)   : 5000
Status                    : Success
Log File                  : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_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: 1332

and
C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\summary.txt

05/04/2011 09:41:11.718 ================================================================================
05/04/2011 09:41:11.718 Hotfix package launched
05/04/2011 09:41:11.734 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.734 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
05/04/2011 09:41:11.734 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.734 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
05/04/2011 09:41:11.734 Local Computer:
05/04/2011 09:41:11.734 Target Details: CHG-SRVR2
05/04/2011 09:41:11.734   commonfilesdir = C:\Program Files (x86)\Common Files
05/04/2011 09:41:11.734   lcidsupportdir = d:\ef31ae173f511457b6aed63ba28689b5\1033
05/04/2011 09:41:11.734   programfilesdir = C:\Program Files (x86)
05/04/2011 09:41:11.734   programfilesdir_wow = C:\Program Files (x86)
05/04/2011 09:41:11.734   supportdir = d:\ef31ae173f511457b6aed63ba28689b5
05/04/2011 09:41:11.734   supportdirlocal = d:\ef31ae173f511457b6aed63ba28689b5
05/04/2011 09:41:11.734   windir = C:\WINDOWS
05/04/2011 09:41:11.734   winsysdir = C:\WINDOWS\system32
05/04/2011 09:41:11.734   winsysdir_wow = C:\WINDOWS\SysWOW64
05/04/2011 09:41:11.734
05/04/2011 09:41:11.734 Enumerating applicable products for this patch
05/04/2011 09:41:11.734 Found SQL 2005 Express product definition
05/04/2011 09:41:11.937 Enumeration: Determining QFE level for product instance BKUPEXEC
05/04/2011 09:41:11.953 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
05/04/2011 09:41:11.953 Enumeration: Found following QFE level for product instance BKUPEXEC: 2047
05/04/2011 09:41:11.953 Enumeration: Determining GDR branching Hotfix for product instance BKUPEXEC
05/04/2011 09:41:11.953 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
05/04/2011 09:41:11.953 Enumeration: No GDR branch Hotfix found for product instance BKUPEXEC
05/04/2011 09:41:11.953 Enumeration: Determining QFE level for product instance
05/04/2011 09:41:11.953 Enumeration: Cannot find following key file for product instance : C:\Program Files (x86)\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
05/04/2011 09:41:11.953 Enumeration: Determining GDR branching Hotfix for product instance
05/04/2011 09:41:11.953 Enumeration: Cannot find following key file for product instance : C:\Program Files (x86)\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
05/04/2011 09:41:11.953 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.953 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
05/04/2011 09:41:11.953 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.953 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
05/04/2011 09:41:11.953 Product discovery completed during the install process for BKUPEXEC
05/04/2011 09:41:11.953 SP Level check completed during the install process for BKUPEXEC
05/04/2011 09:41:11.953 Product language check completed during the install process for BKUPEXEC
05/04/2011 09:41:11.953 Product version check completed during the install process for BKUPEXEC
05/04/2011 09:41:11.953 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.953 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files (x86)\Common Files
05/04/2011 09:41:11.953 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
05/04/2011 09:41:11.953 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files (x86)
05/04/2011 09:41:11.953 Product discovery completed during the install process for SQLExpress
05/04/2011 09:41:11.953 SP Level check completed during the install process for SQLExpress
05/04/2011 09:41:11.953 Product language check completed during the install process for SQLExpress
05/04/2011 09:41:11.953 Product version check completed during the install process for SQLExpress
05/04/2011 09:41:11.953 Command-line instance name check completed during the install process
05/04/2011 09:41:11.953 SKU check completed during the install process for BKUPEXEC
05/04/2011 09:41:11.953 SKU check completed during the install process for SQLExpress
05/04/2011 09:41:11.953 Baseline build check completed during the installation process for BKUPEXEC
05/04/2011 09:41:11.953 Baseline build check completed during the installation process for SQLExpress
05/04/2011 09:41:11.953 Baseline build check completed during the install process
05/04/2011 09:41:11.953 Product Enumeration Results:
05/04/2011 09:41:11.953   INF File Name: d:\ef31ae173f511457b6aed63ba28689b5\HotFixExpress.inf
05/04/2011 09:41:11.953   baselinebuild = 1399
05/04/2011 09:41:11.953   build = 5000
05/04/2011 09:41:11.953   description = Express Database Services
05/04/2011 09:41:11.953   details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
05/04/2011 09:41:11.953   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
05/04/2011 09:41:11.953   kbarticle = KB2463332
05/04/2011 09:41:11.953   kbarticlehyperlink = http://support.microsoft.com/?kbid=2463332
05/04/2011 09:41:11.953   lcid = 1033
05/04/2011 09:41:11.953   legalproductname = SQL Server Express Database Services 2005
05/04/2011 09:41:11.953   machinetype = x86
05/04/2011 09:41:11.953   package = HotFixExpress
05/04/2011 09:41:11.953   packagetype = SP
05/04/2011 09:41:11.953   productname = SQL9Express
05/04/2011 09:41:11.953   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
05/04/2011 09:41:11.968   servicepackname = Microsoft SQL Server 2005 Service Pack 4 Setup
05/04/2011 09:41:11.968   sku = EXPRESS
05/04/2011 09:41:11.968   splevel = 4
05/04/2011 09:41:11.968   sqlutility = sqlcmd.exe
05/04/2011 09:41:11.968   supportdir = d:\ef31ae173f511457b6aed63ba28689b5
05/04/2011 09:41:11.968   validateauthentication = true
05/04/2011 09:41:11.968   version = 9
05/04/2011 09:41:11.968
05/04/2011 09:41:11.968   File Group Details: EXE
05/04/2011 09:41:11.968     parameters = INSTANCENAME=<NAME>
05/04/2011 09:41:11.968     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
05/04/2011 09:41:11.968     File Details: SQLEXPR.EXE
05/04/2011 09:41:11.968
05/04/2011 09:41:11.968   Instance Details: BKUPEXEC
05/04/2011 09:41:11.968     associatedhotfixbuild = 0
05/04/2011 09:41:11.968     clustername =
05/04/2011 09:41:11.968     features = SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
05/04/2011 09:41:11.968     fullversion = 2005.090.2047.00
05/04/2011 09:41:11.968     hiveregpath = Software\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1
05/04/2011 09:41:11.968     id = MSSQL.1
05/04/2011 09:41:11.968     installsqldatadir = C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL
05/04/2011 09:41:11.968     installsqldir = C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL
05/04/2011 09:41:11.968     lcid = 1033
05/04/2011 09:41:11.968     name = BKUPEXEC
05/04/2011 09:41:11.968     productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
05/04/2011 09:41:11.968     qfelevel = 2047
05/04/2011 09:41:11.968     servicename = MSSQL$BKUPEXEC
05/04/2011 09:41:11.968     sku = EXPRESS
05/04/2011 09:41:11.968     sp = 1
05/04/2011 09:41:11.968     type = SQL Server Standalone Product
05/04/2011 09:41:11.968     vermajbld = 2047
05/04/2011 09:41:11.968     version = 9
05/04/2011 09:41:11.968     wow64 = true
05/04/2011 09:41:11.968
05/04/2011 09:41:11.968   Instance Details: SQLExpress
05/04/2011 09:41:11.968     associatedhotfixbuild = 1520
05/04/2011 09:41:11.968     clustername =
05/04/2011 09:41:11.968     expressrsstandalone = true
05/04/2011 09:41:11.968     features = Client_Components,Connectivity
05/04/2011 09:41:11.968     hiveregpath = Software\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools
05/04/2011 09:41:11.968     id =
05/04/2011 09:41:11.968     installsqldatadir =
05/04/2011 09:41:11.968     installsqldir = C:\Program Files (x86)\Microsoft SQL Server\90\Tools\
05/04/2011 09:41:11.968     lcid = 1033
05/04/2011 09:41:11.968     name =
05/04/2011 09:41:11.968     productcode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}
05/04/2011 09:41:11.968     servicename = MSSQL$
05/04/2011 09:41:11.968     sku = EXPRESS
05/04/2011 09:41:11.968     sp = 4
05/04/2011 09:41:11.968     type = Tools Only
05/04/2011 09:41:11.968     vermajbld = 5000
05/04/2011 09:41:11.968     version = 9
05/04/2011 09:41:11.968     wow64 = true
05/04/2011 09:41:11.968
05/04/2011 09:41:11.968 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
05/04/2011 09:41:11.968 Registry: Cannot read registry key value "PendingFileRenameOperations", error 0
05/04/2011 09:41:11.968 Locked file: Checking for locked files
05/04/2011 09:41:12.000 Attempting to pause the 32 bit ngen queue
05/04/2011 09:41:12.687 Installing product: SQL9Express
05/04/2011 09:41:12.687 Installing instance: BKUPEXEC
05/04/2011 09:41:12.687 Installing target: CHG-SRVR2
05/04/2011 09:41:13.468 Received list of RANU pid's
05/04/2011 09:41:13.468 Stopping service: MSSQL$BKUPEXEC
05/04/2011 09:41:15.468 Stopped service: MSSQL$BKUPEXEC
05/04/2011 09:41:15.468 Installing file: SQLEXPR.EXE
05/04/2011 09:41:15.468 Copy Engine: Creating MSI install log file at: C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
05/04/2011 09:41:15.468 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/04/2011 09:41:15.468 Registry: Cannot read registry key value "Debug", error 0
05/04/2011 09:43:26.765 EXE returned 1332: *** Shared String ID 131332 Not Found ***
05/04/2011 09:43:26.765 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/04/2011 09:43:26.765 Registry: Cannot read registry key value "Debug", error 1814
05/04/2011 09:43:26.765 Copy Engine: Error, unable to install EXE file: d:\ef31ae173f511457b6aed63ba28689b5\HotFixExpress\Files\SQLEXPR.EXE
05/04/2011 09:43:26.765 The following exception occurred: Unable to install Windows Installer MSI file  Date: 05/04/2011 09:43:26.765  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 1704
05/04/2011 09:43:27.031 Watson: Param1 = Unknown
05/04/2011 09:43:27.031 Watson: Param2 = 0x534
05/04/2011 09:43:27.031 Watson: Param3 = Unknown
05/04/2011 09:43:27.031 Watson: Param4 = 0x534
05/04/2011 09:43:27.031 Watson: Param5 = copyengine.cpp@1704
05/04/2011 09:43:27.031 Watson: Param6 = Unknown
05/04/2011 09:43:27.031 Watson: Param7 = SQL9Express
05/04/2011 09:43:27.031 Watson: Param8 = @
05/04/2011 09:43:27.031 Watson: Param9 = x86
05/04/2011 09:43:27.031 Watson: Param10 = 5000
05/04/2011 09:43:27.031 Installed product: SQL9Express
05/04/2011 09:43:27.031 Installing product: SQL9Express
05/04/2011 09:43:27.031 Installing instance: SQLExpress
05/04/2011 09:43:27.031 Installing target: CHG-SRVR2
05/04/2011 09:43:27.031 Installing file: SQLEXPR.EXE
05/04/2011 09:43:27.031 Copy Engine: Creating MSI install log file at: C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
05/04/2011 09:43:27.031 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/04/2011 09:43:27.031 Registry: Cannot read registry key value "Debug", error 0

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

I believe we have stripped SQL back by uninstalling all SQL components HP SIM and BE11d (as we couldnt upgrade from 11 to 2010.

I have found:

http://support.microsoft.com/kb/925976
http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/bb6c0f1b-efe8-49de-8285-544a11c6a22d

but not helping.

I guess the server still assumes instance SQLExpress is running/installed, which could be the cause???

Ideas on how to fix this would be helpful as this is running in our production environment.

Note, backups are also failing due to the server trying to install SP4 for SQL 2005  automatically out of hours every night at approx 21:00-22:00.  
We have unticked automatically install updated for the corresponding group within WSUS.  
0
CHI-LTD
Asked:
CHI-LTD
  • 2
1 Solution
 
johanntagleCommented:
Think you mistakenly chose MySQL Server as zone here.  You should have it changed to MS SQL Server
0
 
CHI-LTDAuthor Commented:
oooops
0
 
CHI-LTDAuthor Commented:
fixed by uninstallign and reinstalling
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now