locked
SQL Server 2005 Express Edition SP2 Update failed. KB 921896 RRS feed

  • คำถาม

  •  

    Hi, i just done a MS Windows Update and this one keeps failing, any ideas?

     

    Posted are two log files both found in C%progfiles%SQLServer%90%SetupBootstrap%Log%Hotfix, one Text Doc titled Hotfix and one Text Doc titled summary, there is also a cabinet  file called KB921986_x86

     



     
     

    This is the Hotfix log file

     

     

    10/20/2008 02:17:46.703 ================================================================================
    10/20/2008 02:17:46.703 Hotfix package launched
    10/20/2008 02:17:46.812 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    10/20/2008 02:17:46.812 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    10/20/2008 02:17:46.812 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    10/20/2008 02:17:46.812 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    10/20/2008 02:17:46.812 Local Computer:
    10/20/2008 02:17:46.812 Target Details: YOUR-10F19F641C
    10/20/2008 02:17:46.812   commonfilesdir = C:\Program Files\Common Files
    10/20/2008 02:17:46.828   lcidsupportdir = c:\8a5eb1f0d83a70ef105e18\1033
    10/20/2008 02:17:46.828   programfilesdir = C:\Program Files
    10/20/2008 02:17:46.828   programfilesdir_wow = C:\Program Files
    10/20/2008 02:17:46.828   supportdir = c:\8a5eb1f0d83a70ef105e18
    10/20/2008 02:17:46.828   supportdirlocal = c:\8a5eb1f0d83a70ef105e18
    10/20/2008 02:17:46.828   windir = C:\WINDOWS
    10/20/2008 02:17:46.828   winsysdir = C:\WINDOWS\system32
    10/20/2008 02:17:46.828   winsysdir_wow = C:\WINDOWS\SysWOW64
    10/20/2008 02:17:46.828
    10/20/2008 02:17:46.828 Enumerating applicable products for this patch
    10/20/2008 02:17:46.828 Found SQL 2005 Express product definition
    10/20/2008 02:17:47.437 Enumeration: Determining QFE level for product instance MSSMLBIZ
    10/20/2008 02:17:47.453 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
    10/20/2008 02:17:47.453 Enumeration: Found following QFE level for product instance MSSMLBIZ: 2047
    10/20/2008 02:17:47.453 Enumeration: Determining GDR branching Hotfix for product instance MSSMLBIZ
    10/20/2008 02:17:47.468 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
    10/20/2008 02:17:47.468 Enumeration: No GDR branch Hotfix found for product instance MSSMLBIZ
    10/20/2008 02:17:47.468 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    10/20/2008 02:17:47.468 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
    10/20/2008 02:17:47.484 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
    10/20/2008 02:17:47.484 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
    10/20/2008 02:17:47.484 Product discovery completed during the install process for MSSMLBIZ
    10/20/2008 02:17:47.484 SP Level check completed during the install process for MSSMLBIZ
    10/20/2008 02:17:47.484 Product language check completed during the install process for MSSMLBIZ
    10/20/2008 02:17:47.500 Product version check completed during the install process for MSSMLBIZ
    10/20/2008 02:17:47.500 Command-line instance name check completed during the install process
    10/20/2008 02:17:47.500 SKU check completed during the install process for MSSMLBIZ
    10/20/2008 02:17:47.500 Baseline build check completed during the installation process for MSSMLBIZ
    10/20/2008 02:17:47.500 Baseline build check completed during the install process
    10/20/2008 02:17:47.531 Product Enumeration Results:
    10/20/2008 02:17:47.531   INF File Name: c:\8a5eb1f0d83a70ef105e18\HotFixExpress.inf
    10/20/2008 02:17:47.531   baselinebuild = 1399
    10/20/2008 02:17:47.531   build = 3042
    10/20/2008 02:17:47.531   description = Express Database Services
    10/20/2008 02:17:47.531   details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
    10/20/2008 02:17:47.531   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
    10/20/2008 02:17:47.531   kbarticle = KB921896
    10/20/2008 02:17:47.531   kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
    10/20/2008 02:17:47.531   lcid = 1033
    10/20/2008 02:17:47.531   legalproductname = SQL Server Express Database Services 2005
    10/20/2008 02:17:47.531   machinetype = x86
    10/20/2008 02:17:47.531   package = HotFixExpress
    10/20/2008 02:17:47.531   packagetype = SP
    10/20/2008 02:17:47.531   productname = SQL9Express
    10/20/2008 02:17:47.531   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
    10/20/2008 02:17:47.531   servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
    10/20/2008 02:17:47.531   sku = EXPRESS
    10/20/2008 02:17:47.531   splevel = 2
    10/20/2008 02:17:47.546   sqlutility = sqlcmd.exe
    10/20/2008 02:17:47.546   supportdir = c:\8a5eb1f0d83a70ef105e18
    10/20/2008 02:17:47.546   validateauthentication = true
    10/20/2008 02:17:47.546   version = 9
    10/20/2008 02:17:47.546
    10/20/2008 02:17:47.546   File Group Details: EXE
    10/20/2008 02:17:47.546     parameters = INSTANCENAME=<NAME>
    10/20/2008 02:17:47.546     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
    10/20/2008 02:17:47.546     File Details: SQLEXPR.EXE
    10/20/2008 02:17:47.546
    10/20/2008 02:17:47.546   Instance Details: MSSMLBIZ
    10/20/2008 02:17:47.546     associatedhotfixbuild = 0
    10/20/2008 02:17:47.546     clustername =
    10/20/2008 02:17:47.546     features = SQL_Data_Files,SQL_Engine,SQL_SharedTools
    10/20/2008 02:17:47.546     fullversion = 2005.090.2047.00
    10/20/2008 02:17:47.546     hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1
    10/20/2008 02:17:47.546     id = MSSQL.1
    10/20/2008 02:17:47.546     installsqldatadir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
    10/20/2008 02:17:47.546     installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
    10/20/2008 02:17:47.562     lcid = 1033
    10/20/2008 02:17:47.562     name = MSSMLBIZ
    10/20/2008 02:17:47.562     productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
    10/20/2008 02:17:47.562     qfelevel = 2047
    10/20/2008 02:17:47.562     servicename = MSSQL$MSSMLBIZ
    10/20/2008 02:17:47.562     sku = EXPRESS
    10/20/2008 02:17:47.562     sp = 1
    10/20/2008 02:17:47.562     type = SQL Server Standalone Product
    10/20/2008 02:17:47.562     vermajbld = 2047
    10/20/2008 02:17:47.562     version = 9
    10/20/2008 02:17:47.562
    10/20/2008 02:17:47.562 Authenticating user using Windows Authentication
    10/20/2008 02:17:47.687 SQL Service MSSQL$MSSMLBIZ was not previously running, started for authentication
    10/20/2008 02:17:47.687 Starting service: MSSQL$MSSMLBIZ
    10/20/2008 02:17:52.515 Unable to start service: MSSQL$MSSMLBIZ
    10/20/2008 02:17:52.531 The following exception occurred: Unable to start service  Date: 10/20/2008 02:17:52.531  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\service.cpp  Line: 318
    10/20/2008 02:17:52.578 The following exception occurred: Unable to start service  Date: 10/20/2008 02:17:52.578  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\control.cpp  Line: 2509
    10/20/2008 02:17:52.578 The patch installation could not proceed due to unexpected errors
    10/20/2008 02:17:53.156 Watson: Param1 = Unknown
    10/20/2008 02:17:53.156 Watson: Param2 = 0x2b22
    10/20/2008 02:17:53.156 Watson: Param3 = Unknown
    10/20/2008 02:17:53.156 Watson: Param4 = Unknown
    10/20/2008 02:17:53.156 Watson: Param5 = control.cpp@2509
    10/20/2008 02:17:53.156 Watson: Param6 = Unknown
    10/20/2008 02:17:53.156 Watson: Param7 = SQL9Express
    10/20/2008 02:17:53.156 Watson: Param8 = @
    10/20/2008 02:17:53.156 Watson: Param9 = x86
    10/20/2008 02:17:53.156 Watson: Param10 = 3042

     

     

    ........And this is the Hotfix summary notepad

     

     

    Time: 10/20/2008 02:17:53.156
    KB Number: KB921896
    Machine: YOUR-10F19F641C
    OS Version: Microsoft Windows XP Professional Service Pack 3 (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 (MSSMLBIZ)      ENU       SP1    2005.090.2047.00  x86       EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product                                   Reason
    Express Database Services (MSSMLBIZ)      Unable to start service

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

    **********************************************************************************
    Product Installation Status
    Product                   : Express Database Services (MSSMLBIZ)
    Product Version (Previous): 2047
    Product Version (Final)   :
    Status                    : Not Applied
    Log File                  :
    SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number              : 11042
    Error Description         : Unable to start service
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
         Unable to start service
         Exit Code Returned: 11042

      


    Hope these help thanks.

    20 ตุลาคม 2551 0:47

คำตอบ

  • Update - for this one i rang Microsoft who admitted this is a known issue they rang me back and did a remote assist - about 45 min, glad they rang me. Very helpfull guy. Very impressed by their service.

    Still didnt resolve my issue in another post i put on here.

    • ทำเครื่องหมายเป็นคำตอบโดย Kalman TothEditor 21 มกราคม 2555 22:54
    23 ตุลาคม 2551 14:39

ตอบทั้งหมด