none
Unable to install SQL Server 2005 Express Edition with Advanced Services Service Pack 4 (KB2463332)

    Question

  • Hello,

    Rookie here. Using SQL for an eBay software program we have been running for two years. There were simple step by step instructions to install -- point being, I really dont understand this stuff.

    Running Windows XP SP3.

    Automatic Updates is trying to install the version shown in the Title of this message. It fails to install and gives me the error: SQL BPA command line has encountered a problem and needs to close.

    I do not know where to access the error log. I will post if someone can tell me the correct one to find. In the following directory, C:\Program Files\Microsoft SQL Server\, there are directories for MSSQL.1, MSSQL.2 and MSSQL.3. Two of them show log directories with today's date.

    Any and all help is very much appreciated.

    Thank you!


    • Edited by cmhuber Friday, April 08, 2011 6:30 AM
    Friday, April 08, 2011 6:23 AM

All replies

  • Hello cmhuber

    The log is in C:\Program Files\Microsoft SQL Server\90\setup bootstrap\log. Please paste the log here for further investigation


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, April 08, 2011 6:27 AM
  • Thanks Jing.

    I followed that path, but in the Log directory, there are two sub dirs, Files and Hotfix. Each has lots of files. The Files directory has old files dated to 2010 and Hotfix has many files (and even more sub dirs) but some are dated from today. So here are the results of the Hotfix.log file:

     

    04/07/2011 23:08:42.625 ================================================================================
    04/07/2011 23:08:42.671 Hotfix package launched
    04/07/2011 23:08:42.734 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:42.765 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    04/07/2011 23:08:42.796 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:42.890 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    04/07/2011 23:08:42.906 Local Computer:
    04/07/2011 23:08:42.921 Target Details: CHRIS-CUSTOM
    04/07/2011 23:08:42.953   commonfilesdir = C:\Program Files\Common Files
    04/07/2011 23:08:42.968   lcidsupportdir = e:\1fad313053f8d876972f71f6b13ae141\1033
    04/07/2011 23:08:42.984   programfilesdir = C:\Program Files
    04/07/2011 23:08:43.000   programfilesdir_wow = C:\Program Files
    04/07/2011 23:08:43.031   supportdir = e:\1fad313053f8d876972f71f6b13ae141
    04/07/2011 23:08:43.046   supportdirlocal = e:\1fad313053f8d876972f71f6b13ae141
    04/07/2011 23:08:43.062   windir = C:\WINDOWS
    04/07/2011 23:08:43.078   winsysdir = C:\WINDOWS\system32
    04/07/2011 23:08:43.093   winsysdir_wow = C:\WINDOWS\SysWOW64
    04/07/2011 23:08:43.125
    04/07/2011 23:08:43.140 Enumerating applicable products for this patch
    04/07/2011 23:08:43.171 Found SQL 2005 Express product definition
    04/07/2011 23:08:44.671 Enumeration: Determining QFE level for product instance SQLEXPRESS
    04/07/2011 23:08:44.687 Enumeration: Cannot find following key file for product instance SQLEXPRESS: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\\Binn\SQLServr.exe
    04/07/2011 23:08:44.718 Enumeration: Determining GDR branching Hotfix for product instance SQLEXPRESS
    04/07/2011 23:08:44.734 Enumeration: Cannot find following key file for product instance SQLEXPRESS: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\\Binn\SQLServr.exe
    04/07/2011 23:08:44.750 Enumeration: Determining QFE level for product instance SQLEXPRESS
    04/07/2011 23:08:44.781 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
    04/07/2011 23:08:44.781 Enumeration: Found following QFE level for product instance SQLEXPRESS: 5000
    04/07/2011 23:08:44.812 Enumeration: Determining GDR branching Hotfix for product instance SQLEXPRESS
    04/07/2011 23:08:44.828 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
    04/07/2011 23:08:44.843 Enumeration: No GDR branch Hotfix found for product instance SQLEXPRESS
    04/07/2011 23:08:44.875 Enumeration: Determining QFE level for product instance THUBDBSERVER
    04/07/2011 23:08:44.906 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files\MSSQL.3\MSSQL\Binn\SQLServr.exe
    04/07/2011 23:08:44.921 Enumeration: Found following QFE level for product instance THUBDBSERVER: 5000
    04/07/2011 23:08:44.937 Enumeration: Determining GDR branching Hotfix for product instance THUBDBSERVER
    04/07/2011 23:08:44.968 Enumeration: Associated hotfix build information not found for the following file: C:\Program Files\MSSQL.3\MSSQL\Binn\SQLServr.exe
    04/07/2011 23:08:44.984 Enumeration: No GDR branch Hotfix found for product instance THUBDBSERVER
    04/07/2011 23:08:45.000 Enumeration: Determining QFE level for product instance
    04/07/2011 23:08:45.015 Enumeration: Cannot find following key file for product instance : C:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
    04/07/2011 23:08:45.046 Enumeration: Determining GDR branching Hotfix for product instance
    04/07/2011 23:08:45.062 Enumeration: Cannot find following key file for product instance : C:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
    04/07/2011 23:08:45.078 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.093 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    04/07/2011 23:08:45.109 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.140 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    04/07/2011 23:08:45.140 Product discovery completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.156 SP Level check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.171 Product language check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.187 Product version check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.187 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.203 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    04/07/2011 23:08:45.218 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.234 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    04/07/2011 23:08:45.250 Product discovery completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.265 SP Level check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.265 Product language check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.281 Product version check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.296 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.312 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    04/07/2011 23:08:45.328 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.343 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    04/07/2011 23:08:45.343 Product discovery completed during the install process for THUBDBSERVER
    04/07/2011 23:08:45.359 SP Level check completed during the install process for THUBDBSERVER
    04/07/2011 23:08:45.375 Product language check completed during the install process for THUBDBSERVER
    04/07/2011 23:08:45.390 Product version check completed during the install process for THUBDBSERVER
    04/07/2011 23:08:45.406 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.421 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    04/07/2011 23:08:45.421 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    04/07/2011 23:08:45.437 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    04/07/2011 23:08:45.453 Product discovery completed during the install process for SQLExpress
    04/07/2011 23:08:45.468 SP Level check completed during the install process for SQLExpress
    04/07/2011 23:08:45.484 Product language check completed during the install process for SQLExpress
    04/07/2011 23:08:45.500 Product version check completed during the install process for SQLExpress
    04/07/2011 23:08:45.515 Command-line instance name check completed during the install process
    04/07/2011 23:08:45.515 SKU check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.531 SKU check completed during the install process for SQLEXPRESS
    04/07/2011 23:08:45.546 The edition of product instance THUBDBSERVER does not qualify for this update.
    04/07/2011 23:08:45.578 SKU check completed during the install process for SQLExpress
    04/07/2011 23:08:45.593 Baseline build check completed during the installation process for SQLEXPRESS
    04/07/2011 23:08:45.609 Baseline build check completed during the installation process for SQLExpress
    04/07/2011 23:08:45.625 Baseline build check completed during the install process
    04/07/2011 23:08:45.625 Product Enumeration Results:
    04/07/2011 23:08:45.640   INF File Name: e:\1fad313053f8d876972f71f6b13ae141\HotFixExpressAdv.inf
    04/07/2011 23:08:45.656   baselinebuild = 1399
    04/07/2011 23:08:45.687   build = 5000
    04/07/2011 23:08:45.703   description = Express Database Services Adv
    04/07/2011 23:08:45.703   details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
    04/07/2011 23:08:45.718   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
    04/07/2011 23:08:45.734   kbarticle = KB2463332
    04/07/2011 23:08:45.750   kbarticlehyperlink = http://support.microsoft.com/?kbid=2463332
    04/07/2011 23:08:45.765   lcid = 1033
    04/07/2011 23:08:45.781   legalproductname = SQL Server Express Adv Database Services 2005
    04/07/2011 23:08:45.781   machinetype = x86
    04/07/2011 23:08:45.796   package = HotFixExpressAdv
    04/07/2011 23:08:45.812   packagetype = SP
    04/07/2011 23:08:45.828   productname = SQL9Express
    04/07/2011 23:08:45.843   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
    04/07/2011 23:08:45.859   servicepackname = Microsoft SQL Server 2005 Service Pack 4 Setup
    04/07/2011 23:08:45.875   sku = EXPRESS_ADVANCED
    04/07/2011 23:08:45.890   splevel = 4
    04/07/2011 23:08:45.906   sqlutility = sqlcmd.exe
    04/07/2011 23:08:45.921   supportdir = e:\1fad313053f8d876972f71f6b13ae141
    04/07/2011 23:08:45.937   validateauthentication = true
    04/07/2011 23:08:45.937   version = 9
    04/07/2011 23:08:45.953
    04/07/2011 23:08:45.968   File Group Details: EXE
    04/07/2011 23:08:45.984     parameters = INSTANCENAME=<NAME>
    04/07/2011 23:08:46.000     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
    04/07/2011 23:08:46.015     File Details: SQLEXPR_ADV.EXE
    04/07/2011 23:08:46.031
    04/07/2011 23:08:46.046   Instance Details: SQLEXPRESS
    04/07/2011 23:08:46.062     associatedhotfixbuild = 3353
    04/07/2011 23:08:46.078     clustername =
    04/07/2011 23:08:46.093     expressrsstandalone = true
    04/07/2011 23:08:46.109     features = RS_Server,RS_SharedTools,RS_Web_Interface
    04/07/2011 23:08:46.125     hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.2
    04/07/2011 23:08:46.140     id = MSSQL.2
    04/07/2011 23:08:46.156     installsqldatadir =
    04/07/2011 23:08:46.171     installsqldir = C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\
    04/07/2011 23:08:46.171     lcid = 1033
    04/07/2011 23:08:46.187     name = SQLEXPRESS
    04/07/2011 23:08:46.203     productcode = {0DAA9912-3FE2-4B84-B926-8D7F71A8A99A}
    04/07/2011 23:08:46.218     servicename = ReportServer$SQLEXPRESS
    04/07/2011 23:08:46.234     sku = EXPRESS_ADVANCED
    04/07/2011 23:08:46.250     sp = 2
    04/07/2011 23:08:46.265     type = Report Server Standalone Product
    04/07/2011 23:08:46.281     vermajbld = 3042
    04/07/2011 23:08:46.296     version = 9
    04/07/2011 23:08:46.296
    04/07/2011 23:08:46.312   Instance Details: SQLEXPRESS
    04/07/2011 23:08:46.328     associatedhotfixbuild = 1520
    04/07/2011 23:08:46.343     clustername =
    04/07/2011 23:08:46.359     features = SQL_Data_Files,SQL_Engine,SQL_FullText,SQL_Replication,SQL_SharedTools
    04/07/2011 23:08:46.375     fullversion = 2005.090.5000.00
    04/07/2011 23:08:46.390     hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1
    04/07/2011 23:08:46.406     id = MSSQL.1
    04/07/2011 23:08:46.406     installsqldatadir = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
    04/07/2011 23:08:46.421     installsqldir = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
    04/07/2011 23:08:46.437     lcid = 1033
    04/07/2011 23:08:46.453     name = SQLEXPRESS
    04/07/2011 23:08:46.468     productcode = {B0F9497C-52B4-4686-8E73-74D866BBDF59}
    04/07/2011 23:08:46.484     qfelevel = 5000
    04/07/2011 23:08:46.500     servicename = MSSQL$SQLEXPRESS
    04/07/2011 23:08:46.500     sku = EXPRESS_ADVANCED
    04/07/2011 23:08:46.515     sp = 4
    04/07/2011 23:08:46.531     type = SQL Server Standalone Product
    04/07/2011 23:08:46.562     vermajbld = 5000
    04/07/2011 23:08:46.578     version = 9
    04/07/2011 23:08:46.578
    04/07/2011 23:08:46.593   Instance Details: THUBDBSERVER
    04/07/2011 23:08:46.609     associatedhotfixbuild = 1520
    04/07/2011 23:08:46.625     clustername =
    04/07/2011 23:08:46.640     details = The edition of product instance THUBDBSERVER does not qualify for this update.
    04/07/2011 23:08:46.656     features = SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
    04/07/2011 23:08:46.671     fullversion = 2005.090.5000.00
    04/07/2011 23:08:46.687     hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.3
    04/07/2011 23:08:46.703     id = MSSQL.3
    04/07/2011 23:08:46.718     installsqldatadir = C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL
    04/07/2011 23:08:46.734     installsqldir = C:\Program Files\MSSQL.3\MSSQL
    04/07/2011 23:08:46.750     lcid = 1033
    04/07/2011 23:08:46.765     name = THUBDBSERVER
    04/07/2011 23:08:46.781     productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
    04/07/2011 23:08:46.796     qfelevel = 5000
    04/07/2011 23:08:46.812     servicename = MSSQL$THUBDBSERVER
    04/07/2011 23:08:46.828     sku = EXPRESS
    04/07/2011 23:08:46.843     sp = 4
    04/07/2011 23:08:46.843     type = SQL Server Standalone Product
    04/07/2011 23:08:46.859     vermajbld = 5000
    04/07/2011 23:08:46.875     version = 9
    04/07/2011 23:08:46.890
    04/07/2011 23:08:46.921   Instance Details: SQLExpress
    04/07/2011 23:08:46.921     associatedhotfixbuild = 1520
    04/07/2011 23:08:46.937     clustername =
    04/07/2011 23:08:46.953     expressrsstandalone = true
    04/07/2011 23:08:46.968     features = Client_Components,Connectivity,SDK,SQL_SSMSEE
    04/07/2011 23:08:46.968     hiveregpath = Software\Microsoft\Microsoft SQL Server\90\Tools
    04/07/2011 23:08:47.000     id =
    04/07/2011 23:08:47.000     installsqldatadir =
    04/07/2011 23:08:47.015     installsqldir = C:\Program Files\Microsoft SQL Server\90\Tools\
    04/07/2011 23:08:47.031     lcid = 1033
    04/07/2011 23:08:47.046     name =
    04/07/2011 23:08:47.062     productcode = {58D379F7-62BC-4748-8237-FE071ECE797C}
    04/07/2011 23:08:47.078     servicename = MSSQL$
    04/07/2011 23:08:47.093     sku = EXPRESS_ADVANCED
    04/07/2011 23:08:47.109     sp = 4
    04/07/2011 23:08:47.125     type = Tools Only
    04/07/2011 23:08:47.140     vermajbld = 5000
    04/07/2011 23:08:47.156     version = 9
    04/07/2011 23:08:47.171
    04/07/2011 23:08:47.187 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
    04/07/2011 23:08:47.203 Registry: Cannot read registry key value "PendingFileRenameOperations", error 0
    04/07/2011 23:08:47.203 Locked file: Checking for locked files
    04/07/2011 23:08:47.250 Attempting to pause the 32 bit ngen queue
    04/07/2011 23:08:47.937 Installing product: SQL9Express
    04/07/2011 23:08:47.953 Installing instance: SQLEXPRESS
    04/07/2011 23:08:47.968 Installing target: CHRIS-CUSTOM
    04/07/2011 23:08:47.984 Installing file: SQLEXPR_ADV.EXE
    04/07/2011 23:08:48.000 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR_ADV.EXE
    04/07/2011 23:08:48.015 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    04/07/2011 23:08:48.015 Registry: Cannot read registry key value "Debug", error 183
    04/07/2011 23:14:26.656 EXE returned 29552: *** Shared String ID 159552 Not Found ***
    04/07/2011 23:14:26.671 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    04/07/2011 23:14:26.703 Registry: Cannot read registry key value "Debug", error 1814
    04/07/2011 23:14:26.734 Copy Engine: Error, unable to install EXE file: e:\1fad313053f8d876972f71f6b13ae141\HotFixExpressAdv\Files\SQLEXPR_ADV.EXE
    04/07/2011 23:14:26.781 The following exception occurred: Unable to install Windows Installer MSI file  Date: 04/07/2011 23:14:26.765  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 1704
    04/07/2011 23:14:29.296 Watson: Param1 = Unknown
    04/07/2011 23:14:29.343 Watson: Param2 = 0x7370
    04/07/2011 23:14:29.359 Watson: Param3 = Unknown
    04/07/2011 23:14:29.375 Watson: Param4 = 0x7370
    04/07/2011 23:14:29.390 Watson: Param5 = copyengine.cpp@1704
    04/07/2011 23:14:29.406 Watson: Param6 = Unknown
    04/07/2011 23:14:29.421 Watson: Param7 = SQL9Express
    04/07/2011 23:14:29.453 Watson: Param8 = @
    04/07/2011 23:14:29.468 Watson: Param9 = x86
    04/07/2011 23:14:29.500 Watson: Param10 = 5000
    04/07/2011 23:14:29.515 Installed product: SQL9Express
    04/07/2011 23:14:29.546 Installing product: SQL9Express
    04/07/2011 23:14:29.562 Installing instance: SQLExpress
    04/07/2011 23:14:29.593 Installing target: CHRIS-CUSTOM
    04/07/2011 23:14:29.625 Installing file: SQLEXPR_ADV.EXE
    04/07/2011 23:14:29.656 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR_ADV.EXE
    04/07/2011 23:14:29.687 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    04/07/2011 23:14:29.703 Registry: Cannot read registry key value "Debug", error 183
    04/07/2011 23:15:12.718 EXE returned 0: The action completed successfully.
    04/07/2011 23:15:12.750 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    04/07/2011 23:15:12.765 Registry: Cannot read registry key value "Debug", error 0
    04/07/2011 23:15:12.781 Copy Engine: Installed file: e:\1fad313053f8d876972f71f6b13ae141\HotFixExpressAdv\Files\SQLEXPR_ADV.EXE
    04/07/2011 23:15:12.812 Installed target: CHRIS-CUSTOM
    04/07/2011 23:15:14.296 Installed instance: SQLExpress
    04/07/2011 23:15:14.328 Installed product: SQL9Express
    04/07/2011 23:15:14.343 Hotfix package completed
    04/07/2011 23:15:14.359 Attempting to continue the 32 bit ngen queue

    Friday, April 08, 2011 6:35 AM
  • There is also a Summary.txt file in the Hotfix directory that is dated today:

     

    Time: 04/07/2011 23:15:14.796
    KB Number: KB2463332
    Machine: CHRIS-CUSTOM
    OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
    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 Adv (SQLEXPRESS)  ENU       SP2                     x86       EXPRESS_ADVANCED
    Express Database Services Adv (SQLEXPRESS)  ENU       SP4    2005.090.5000.00  x86       EXPRESS_ADVANCED
    Express Database Services Adv (THUBDBSERVER)  ENU       SP4    2005.090.5000.00  x86       EXPRESS
    Express Database Services Adv (SQLExpress)  ENU       SP4                     x86       EXPRESS_ADVANCED

    **********************************************************************************
    Products Disqualified & Reason
    Product                                   Reason
    Express Database Services Adv (THUBDBSERVER)  The edition of product instance THUBDBSERVER does not qualify for this update.

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

    **********************************************************************************
    Product Installation Status
    Product                   : Express Database Services Adv (SQLEXPRESS)
    Product Version (Previous):
    Product Version (Final)   :
    Status                    : Failure
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR_ADV.EXE
    SQL Express Features      : RS_Server,RS_SharedTools,RS_Web_Interface
    Error Number              : 29552
    Error Description         : Unable to install Windows Installer MSI file
    ----------------------------------------------------------------------------------
    Product                   : Express Database Services Adv (SQLEXPRESS)
    Product Version (Previous): 5000
    Product Version (Final)   :
    Status                    : Not Selected
    Log File                  :
    SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_FullText,SQL_Replication,SQL_SharedTools
    Error Number              : 0
    Error Description         :
    ----------------------------------------------------------------------------------
    Product                   : Express Database Services Adv (THUBDBSERVER)
    Product Version (Previous): 5000
    Product Version (Final)   :
    Status                    : NA
    Log File                  :
    SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
    Error Description         : The edition of product instance THUBDBSERVER does not qualify for this update.
    ----------------------------------------------------------------------------------
    Product                   : Express Database Services Adv (SQLExpress)
    Product Version (Previous):
    Product Version (Final)   : 5000
    Status                    : Success
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR_ADV.EXE
    SQL Express Features      : Client_Components,Connectivity,SDK,SQL_SSMSEE
    Error Number              : 0
    Error Description         :
    ----------------------------------------------------------------------------------

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

     

    Friday, April 08, 2011 6:37 AM
  • 04/07/2011 23:14:29.656 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR_ADV.EXE
    04/07/2011 23:14:29.687 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    04/07/2011 23:14:29.703 Registry: Cannot read registry key value "Debug", error 183

     

    please check the registry key in your machine. And make sure you have sufficient permission to open the registry key.


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, April 08, 2011 6:39 AM
  • I am the administrator and have never had to login as anyone else to install programs.

    I went to HKEY_LOCAL_MACHINE and followed the path Software\Policies\Microsoft\Windows\Installer. It shows two listings: (Default) and EnableAdminTSRemote. The (default) data says (value not set) and the Enable AdminTSRemote shows 0x0000001 (1)

    Friday, April 08, 2011 6:48 AM
  • http://support.microsoft.com/kb/925976

    Please try workaround in above KB. If it still doesn;t work, you may need to remove all SQL Server 2005 components
    using the Windows Installer Cleanup utility.

    http://support.microsoft.com/kb/290301


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, April 08, 2011 7:15 AM
  •  

    Hi cmhuber,

     

    Based on the log summary.txt, there are three identical instance name of your SQL Server in your computer, it might be caused by the improper installation or the previous installed are not cleared uninstall.

     

    Can you connect to the all instances of SQL Server on your computer?

     

    Since the instance THUBDBSERVER are already updated to the SP4, and the other three detected instance are confused for us, so you could remove all the unnecessary components of these instances from Add/Remove Programs, or following the methods of this KB 909967 to uninstall an instance of SQL Server 2005 manually, after this, then you could reinstall it.

     

    Download website for SQL Server 2005 Express Edition Service Pack 4
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=26435597-b28e-4568-9d16-017bdf47abdc

     

    If there are any progress, please feel free to let me know.

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Wednesday, April 13, 2011 6:04 AM
    Moderator
  • I had the same error message when trying to run the automatic update for SQL Server 2005 Express Edition with Advanced Services SP4. After searching around, I found a thread/discussion and after reading what everyone was saying and doing, I realized I should just register the dll in the GAC first and see if that does the trick. It worked. Here is the link to the discussion in case you want to look at it, other-wise, just follow my directions at the bottom of my post  and re-run the update.

     http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff/

     

    According to Microsoft, you can just drag-n-drop a dll file into the GAC rather than doing it through the command line/prompt:

    http://support.microsoft.com/kb/815808

     

    1. You can install the .dll file by using the Gacutil tool or by dragging the .dll file to the appropriate folder. If you use the Gacutil tool, you can use a command that resembles the following:

      gacutil -I "[DriveLetter]:\[PathToBinDirectoryInVSProject]\gac.dll"
      To drag the file, open two instances of Windows Explorer. In one instance, find the location of the .dll file output for your console project. In the other instance, find c:\[SystemRoot]\Assembly. Then, drag your .dll file to the Assembly folder.

     

    Directions:

    I did the drag-n-drop thing then I did the command line thing, just to make sure.

    What I did was register this dll file in the GAC. The file is at

    "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll"

    Open up Visual Studio Command Prompt and type:

    gacutil -I "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll"

      

    "I am not discouraged, because every wrong attempt discarded is another step forward." Thomas Edison
    • Proposed as answer by Al Cantu Thursday, June 16, 2011 6:14 PM
    Tuesday, April 19, 2011 6:54 PM
  • Using the gacutil trick above worked for my failing Windows Update upgrade of SQL Server Express Reporting Services SP3 to SP4.

     

    Thanks,

    Al

    Thursday, June 16, 2011 5:59 PM