Solved

Unable to install Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)

Posted on 2011-03-23
4
1,494 Views
Last Modified: 2012-10-01
I am unable to install Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) using Microsoft Update.  The installation fails with an Error Code: 0x56C.

The server is Windows Server 2003 Standard with Service Pack 2 (32-bit).  There is plenty of disk space on all volumes.  There used to be SQL Server 2000 and SQL Server 2005 running on this server along with SQL Server 2005 Express.  After getting the failed installation before I removed SQL Server 2000 and SQL Server 2005 but the failed installation continues to occur.

I tried deleting the Automatic Updates cache by doing the following but that did not help.

1.    Go to Control Panel -> Administrative Tools -> Services
2.    Stop the service "Automatic Updates"
3.    Click Start -> Run and type the following %windir%\SoftwareDistribution
4.    Open the “Download” folder and delete all contents of that folder
5.    Start the service "Automatic Updates"

Here is the summary.txt and HotFix.log files from the failed installation.  The files were located in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\ directory.

=====================
summary.txt
=====================

Time: 03/23/2011 11:57:38.150
KB Number: KB2463332
Machine: MYDATABASESERVER
OS Version: Microsoft Windows Server 2003 family, Standard Edition 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       SP2    2005.090.3068.00  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): 3068
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\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              : 1388
Error Description         : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------

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

=====================
HotFix.log
=====================

03/23/2011 11:53:10.913 ================================================================================
03/23/2011 11:53:10.929 Hotfix package launched
03/23/2011 11:53:10.960 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/23/2011 11:53:10.976 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/23/2011 11:53:10.991 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/23/2011 11:53:11.007 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/23/2011 11:53:11.007 Local Computer:
03/23/2011 11:53:11.023 Target Details: MYDATABASESERVER
03/23/2011 11:53:11.038   commonfilesdir = C:\Program Files\Common Files
03/23/2011 11:53:11.054   lcidsupportdir = d:\7143a9d60007a44d6c3f\1033
03/23/2011 11:53:11.070   programfilesdir = C:\Program Files
03/23/2011 11:53:11.070   programfilesdir_wow = C:\Program Files
03/23/2011 11:53:11.085   supportdir = d:\7143a9d60007a44d6c3f
03/23/2011 11:53:11.101   supportdirlocal = d:\7143a9d60007a44d6c3f
03/23/2011 11:53:11.101   windir = C:\WINDOWS
03/23/2011 11:53:11.116   winsysdir = C:\WINDOWS\system32
03/23/2011 11:53:11.116   winsysdir_wow = C:\WINDOWS\SysWOW64
03/23/2011 11:53:11.132
03/23/2011 11:53:11.148 Enumerating applicable products for this patch
03/23/2011 11:53:11.179 Found SQL 2005 Express product definition
03/23/2011 11:53:12.116 Enumeration: Determining QFE level for product instance BKUPEXEC
03/23/2011 11:53:12.148 Enumeration: Found following QFE level for product instance BKUPEXEC: 3068
03/23/2011 11:53:12.148 Enumeration: Determining GDR branching Hotfix for product instance BKUPEXEC
03/23/2011 11:53:12.163 Enumeration: Found following GDR branch hotfix for product instance BKUPEXEC: 3229
03/23/2011 11:53:12.179 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/23/2011 11:53:12.195 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/23/2011 11:53:12.210 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/23/2011 11:53:12.226 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/23/2011 11:53:12.242 Product discovery completed during the install process for BKUPEXEC
03/23/2011 11:53:12.257 SP Level check completed during the install process for BKUPEXEC
03/23/2011 11:53:12.273 Product language check completed during the install process for BKUPEXEC
03/23/2011 11:53:12.288 Product version check completed during the install process for BKUPEXEC
03/23/2011 11:53:12.304 Command-line instance name check completed during the install process
03/23/2011 11:53:12.320 SKU check completed during the install process for BKUPEXEC
03/23/2011 11:53:12.351 Baseline build check completed during the installation process for BKUPEXEC
03/23/2011 11:53:12.351 Baseline build check completed during the install process
03/23/2011 11:53:12.382 Product Enumeration Results:
03/23/2011 11:53:12.382   INF File Name: d:\7143a9d60007a44d6c3f\HotFixExpress.inf
03/23/2011 11:53:12.398   baselinebuild = 1399
03/23/2011 11:53:12.413   build = 5000
03/23/2011 11:53:12.429   description = Express Database Services
03/23/2011 11:53:12.445   details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
03/23/2011 11:53:12.460   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
03/23/2011 11:53:12.460   kbarticle = KB2463332
03/23/2011 11:53:12.476   kbarticlehyperlink = http://support.microsoft.com/?kbid=2463332
03/23/2011 11:53:12.492   lcid = 1033
03/23/2011 11:53:12.507   legalproductname = SQL Server Express Database Services 2005
03/23/2011 11:53:12.507   machinetype = x86
03/23/2011 11:53:12.523   package = HotFixExpress
03/23/2011 11:53:12.538   packagetype = SP
03/23/2011 11:53:12.554   productname = SQL9Express
03/23/2011 11:53:12.570   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
03/23/2011 11:53:12.585   servicepackname = Microsoft SQL Server 2005 Service Pack 4 Setup
03/23/2011 11:53:12.601   sku = EXPRESS
03/23/2011 11:53:12.601   splevel = 4
03/23/2011 11:53:12.617   sqlutility = sqlcmd.exe
03/23/2011 11:53:12.617   supportdir = d:\7143a9d60007a44d6c3f
03/23/2011 11:53:12.632   validateauthentication = true
03/23/2011 11:53:12.632   version = 9
03/23/2011 11:53:12.648
03/23/2011 11:53:12.663   File Group Details: EXE
03/23/2011 11:53:12.663     parameters = INSTANCENAME=<NAME>
03/23/2011 11:53:12.679     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
03/23/2011 11:53:12.679     File Details: SQLEXPR.EXE
03/23/2011 11:53:12.695
03/23/2011 11:53:12.710   Instance Details: BKUPEXEC
03/23/2011 11:53:12.726     associatedhotfixbuild = 3229
03/23/2011 11:53:12.726     clustername =
03/23/2011 11:53:12.742     features = SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
03/23/2011 11:53:12.757     fullversion = 2005.090.3068.00
03/23/2011 11:53:12.773     hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1
03/23/2011 11:53:12.788     id = MSSQL.1
03/23/2011 11:53:12.804     installsqldatadir = C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC
03/23/2011 11:53:12.820     installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
03/23/2011 11:53:12.835     lcid = 1033
03/23/2011 11:53:12.851     name = BKUPEXEC
03/23/2011 11:53:12.867     productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
03/23/2011 11:53:12.867     qfelevel = 3068
03/23/2011 11:53:12.882     servicename = MSSQL$BKUPEXEC
03/23/2011 11:53:12.898     sku = EXPRESS
03/23/2011 11:53:12.913     sp = 2
03/23/2011 11:53:12.913     type = SQL Server Standalone Product
03/23/2011 11:53:12.929     vermajbld = 3042
03/23/2011 11:53:12.945     version = 9
03/23/2011 11:53:12.945
03/23/2011 11:53:12.960 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
03/23/2011 11:53:12.976 Registry: Cannot read registry key value "PendingFileRenameOperations", error 0
03/23/2011 11:53:12.992 Locked file: Checking for locked files
03/23/2011 11:53:13.023 Attempting to pause the 32 bit ngen queue
03/23/2011 11:53:13.695 Installing product: SQL9Express
03/23/2011 11:53:13.742 Installing instance: BKUPEXEC
03/23/2011 11:53:13.757 Installing target: MYDATABASESERVER
03/23/2011 11:53:14.507 Received list of RANU pid's
03/23/2011 11:53:14.554 Stopping service: MSSQL$BKUPEXEC
03/23/2011 11:53:16.570 Stopped service: MSSQL$BKUPEXEC
03/23/2011 11:53:16.617 Installing file: SQLEXPR.EXE
03/23/2011 11:53:16.633 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
03/23/2011 11:53:16.633 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
03/23/2011 11:53:16.648 Registry: Cannot read registry key value "Debug", error 0
03/23/2011 11:57:35.853 EXE returned 1388: *** Shared String ID 131388 Not Found ***
03/23/2011 11:57:35.868 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
03/23/2011 11:57:35.884 Registry: Cannot read registry key value "Debug", error 1814
03/23/2011 11:57:35.899 Copy Engine: Error, unable to install EXE file: d:\7143a9d60007a44d6c3f\HotFixExpress\Files\SQLEXPR.EXE
03/23/2011 11:57:35.915 The following exception occurred: Unable to install Windows Installer MSI file  Date: 03/23/2011 11:57:35.915  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 1704
03/23/2011 11:57:37.853 Watson: Param1 = Unknown
03/23/2011 11:57:37.868 Watson: Param2 = 0x56c
03/23/2011 11:57:37.884 Watson: Param3 = Unknown
03/23/2011 11:57:37.915 Watson: Param4 = 0x56c
03/23/2011 11:57:37.946 Watson: Param5 = copyengine.cpp@1704
03/23/2011 11:57:37.962 Watson: Param6 = Unknown
03/23/2011 11:57:37.978 Watson: Param7 = SQL9Express
03/23/2011 11:57:37.993 Watson: Param8 = @
03/23/2011 11:57:38.009 Watson: Param9 = x86
03/23/2011 11:57:38.025 Watson: Param10 = 5000
03/23/2011 11:57:38.040 Installed product: SQL9Express
03/23/2011 11:57:38.071 Hotfix package completed
03/23/2011 11:57:38.087 Attempting to continue the 32 bit ngen queue
0
Comment
Question by:NGPSoft1
  • 3
4 Comments
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 35209357
It seems to run into a problem reading your registry - the first place I see an error is here:

03/23/2011 11:53:16.633 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
03/23/2011 11:53:16.648 Registry: Cannot read registry key value "Debug", error 0
03/23/2011 11:57:35.853 EXE returned 1388: *** Shared String ID 131388 Not Found ***

After that, it seems to start rolling back. Though there's a big lag between the two events (the "error" and the missing registry value, is it possible they're related? I don't have that registry key on my computer (I checked two I own), but maybe you can check for it on yours and see if it exists.

My first inclination is that your registry permissions might not be correct - I've been that change at times when the sids get messed up and it can block updates - but there's nothing in this case that really sticks out. Maybe you can Google that error message a bit more, since it seems to give you more information that the general one you were receiving before.
0
 
LVL 4

Author Comment

by:NGPSoft1
ID: 35226963
I checked the "Software\Policies\Microsoft\Windows\Installer" registry location and there is no "Debug" registry key.  I will research furhte using this information.
0
 
LVL 4

Accepted Solution

by:
NGPSoft1 earned 0 total points
ID: 38437057
It turns out that this server was turned into a domain controller at one time and then the domain controller role was removed.  This database is used by Symantec's Backup Exec.  According to Symantec the domain controller role caused changes that are preventing the installation of the service pack.  In the end we decided to migrate Backup Exec off of this aging server.
0
 
LVL 4

Author Closing Comment

by:NGPSoft1
ID: 38450092
I am sure ryanmccauley was right about the permission.  I believe the domain controller role caused these permission changes.  I awarded ryanmccauley with the full points but accepted my answer as the best solution as it gives the reason why the changes took place that caused the problem.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Learn about cloud computing and its benefits for small business owners.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now