Error installing (KB 921896)

Discussion in 'Windows Update' started by DavidW, Mar 7, 2007.

  1. DavidW

    DavidW Guest

    This is listed as an Important Update:

    Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)

    Download size: 56.4 MB

    You may need to restart your computer for this update to take effect.

    Update type: Important

    This service pack upgrades all Microsoft SQL Server 2005 Express Edition
    instances and components to Service Pack 2 (SP2). If you need additional
    installation options, you should download this service pack at the Microsoft
    Download Center. For more information, see Microsoft Knowledge Base article
    921896.

    I tried to install and this is the error I get: WindowsUpdate_00002B33

    What should I do? Is it truly an Important update and if so, how do I
    install it?
     
    DavidW, Mar 7, 2007
    #1
    1. Advertisements

  2. Looks like you have SQL Server 2005 Express Edition installed.

    Could you post the contents of the summary.txt log located at C:\Program
    Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
    the issue.

    Thanks,
    Peter Saddow [MSFT]
     
    Peter Saddow [Microsoft], Mar 8, 2007
    #2
    1. Advertisements

  3. DavidW

    DavidW Guest

    Sure thing:

    Time: 03/07/2007 18:51:52.227
    KB Number: KB921896
    Machine: DAVID2
    OS Version: Professional (Build 6000)
    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 (ACT7) ENU SP1 2005.090.2170.00
    x86 EXPRESS
    Express Database Services (SQLExpress) ENU SP1
    x86 EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product Reason
    Express Database Services (ACT7) Service was found to be disabled

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

    **********************************************************************************
    Product Installation Status
    Product : Express Database Services (ACT7)
    Product Version (Previous): 2170
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number : 11059
    Error Description : Service was found to be disable
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLExpress)
    Product Version (Previous):
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : Client_Components,Connectivity
    Error Number : 0
    Error Description
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
    Service was found to be disabled
    Exit Code Returned: 11059




     
    DavidW, Mar 8, 2007
    #3
  4. Looks like the Express service is disabled. The service needs to be startable
    for the upgrade to complete. Go to Administrate Tools and then Services. Look
    for the entry called "SQL Server (ACT7)". Right-click on the entry and choose
    properties. You should see the "Startup Type" is disabled. Change the
    "Startup Type" to manual. Rerun the installation through Microsoft Update.

     
    Peter Saddow [Microsoft], Mar 8, 2007
    #4
  5. DavidW

    GPO Guest

    I am having the same issue. My download froze at 82% and now it wants to
    install only, and cannot complete the install, but won't go away as saying I
    should try again. Any thoughts?

     
    GPO, Mar 8, 2007
    #5
  6. You are encountering a different problem than the previous person. Try
    scanning and downloading again, maybe there was some network issue when the
    update was downloading. If you continue to encounter a problem please post a
    new message and let us know which update you are trying to download.

    Thanks,
    Peter Saddow [Microsoft]

     
    Peter Saddow [Microsoft], Mar 8, 2007
    #6
  7. DavidW

    Techjunkie Guest

    Hi Peter,

    I, too, am running ACT version 2007 that relies upon SQL Server for the
    Desktop. I've tried stopping the SQL Server Process while changing its type
    to "Manual" from "Automatic". I've tried "Manual" while it was "running".
    SQL Server's normal status after a reboot and without starting ACT is
    "running" and "automatic". Still I am unsuccessful in Service Pack 2's
    installation. I get Error Code: 0x2B26.

    BTW: I've been wanting to buy a new laptop with Vista but the ACT
    application needs elements of SQL Server that Vista reportedly doesn't
    support. Does Service Pack 2 address this deficiency?

    Thanks for the help!

     
    Techjunkie, Mar 8, 2007
    #7
  8. DavidW

    DavidW Guest

    That seemed to do it. Thanks.

     
    DavidW, Mar 8, 2007
    #8
  9. DavidW

    Steve Kuckuk Guest

    I've also received the same error, and in reading the thread from the last
    few days I think I discovered "something" with my ACT which gets in the way,
    but it doesn't appear to be quite the same as the previous user...

    Below is the "summary" file as requested from the earlier poster

    Thanks for any help you can provide...

    Steve

    Products Detected Language Level Patch Level
    Platform Edition
    Express Database Services (ACT7) ENU SP1 2005.090.2170.00
    x86 EXPRESS
    Express Database Services (SQLExpress) ENU SP1
    x86 EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product Reason
    Express Database Services (ACT7) User authentication failed.
    Please check to see if the password provided is correct or check to see if
    the SQL Server Instance is set to Mixed Authentication

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

    **********************************************************************************
    Product Installation Status
    Product : Express Database Services (ACT7)
    Product Version (Previous): 2170
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number : 11046
    Error Description : User authentication failed. Please check to see
    if the password provided is correct or check to see if the SQL Server
    Instance is set to Mixed Authentication
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLExpress)
    Product Version (Previous):
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : Client_Components,Connectivity
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
    User authentication failed. Please check to see if the password
    provided is correct or check to see if the SQL Server Instance is set to
    Mixed Authentication
    Exit Code Returned: 11046
     
    Steve Kuckuk, Mar 8, 2007
    #9
  10. DavidW

    GPO Guest

    The update is called: Microsoft SQL Server 2005 Express Edition Service Pack
    2 (KB 921896). My computer seems to think it was downloaded, and each time I
    retry to update, it seems to go to an install function (which fails). I
    wonder if there is a way to wipe the download from my system and start over.
    Here are the error details:

    Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
    Installation date: ‎3/‎8/‎2007 3:01 AM
    Installation status: Failed
    Error details: Code 2B22
    Update type: Important
    This service pack upgrades all Microsoft SQL Server 2005 Express Edition
    instances and components to Service Pack 2 (SP2). If you need additional
    installation options, you should download this service pack at the Microsoft
    Download Center. For more information, see Microsoft Knowledge Base article
    921896.
    More information:
    http://support.microsoft.com/kb/921896
    More information:
    http://support.microsoft.com

    Any help would be appreciated.

     
    GPO, Mar 8, 2007
    #10
  11. DavidW

    Techjunkie Guest

    Peter,

    I did include that file further down in this thread.

    Thanks,

    Daniel

     
    Techjunkie, Mar 8, 2007
    #11
  12. Could you post the contents of the summary.txt log located at
    %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can
    then debug the issue.

    Thanks,
    Peter Saddow


     
    Peter Saddow [Microsoft], Mar 8, 2007
    #12
  13. DavidW

    Steve Kuckuk Guest

    My non-technical nature is going to show up here.... that said.... in
    response to your pose I went into the SQL Server (ACT7) from "Component
    Services".... it was already "started", so I executed a STOP which it seemed
    to do, and then when I executed the START, it started up again.....

    If that is what you suggested I do, I've don so with no further sucess at
    installing the UPDATE.

    As for using a "different account" I'm at a loss to understand what you
    mean... this is a single user system, with only one log-in, the one I use
    daily, which has full permissions

    Steve K
     
    Steve Kuckuk, Mar 8, 2007
    #13
  14. Could you post the contents of the summary.txt log located at C:\Program
    Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
    the issue.

    SQL Server 2005 SP2 is officially supported on Vista. However, you may want
    to see if ACT officially supports Vista before migrating.

    Thanks,
    Peter Saddow

     
    Peter Saddow [Microsoft], Mar 8, 2007
    #14
  15. DavidW

    Techjunkie Guest

    Here's the installation summary.txt file:

    Time: 03/07/2007 22:59:51.390
    KB Number: KB921896
    Machine: PARENTSWORLD
    OS Version: Microsoft Windows XP Professional Service Pack 2 (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 (ACT7) ENU SP1 2005.090.2170.00
    x86 EXPRESS
    Express Database Services (SQLExpress) ENU SP1
    x86 EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product Reason
    Express Database Services (ACT7) User authentication failed.
    Please check to see if the password provided is correct or check to see if
    the SQL Server Instance is set to Mixed Authentication

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

    **********************************************************************************
    Product Installation Status
    Product : Express Database Services (ACT7)
    Product Version (Previous): 2170
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number : 11046
    Error Description : User authentication failed. Please check to see
    if the password provided is correct or check to see if the SQL Server
    Instance is set to Mixed Authentication
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLExpress)
    Product Version (Previous):
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : Client_Components,Connectivity
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
    User authentication failed. Please check to see if the password
    provided is correct or check to see if the SQL Server Instance is set to
    Mixed Authentication
    Exit Code Returned: 11046
     
    Techjunkie, Mar 8, 2007
    #15
  16. DavidW

    Peter Foldes Guest

    Wonder why are you posting via the awful CDO interface if you claim to be MSFT. Just being curious :)

    --
    Peter

    Please Reply to Newsgroup for the benefit of others
    Requests for assistance by email can not and will not be acknowledged.

     
    Peter Foldes, Mar 8, 2007
    #16
  17. Looks like when the installer tries to start the SQL service it can't since
    the password has expired or something else is wrong with the service. Try
    starting the service manually from control panel. If you see service won't
    start, you may need to use a different account or reset the password.

    See if this helps.

    Thanks,
    Peter Saddow
     
    Peter Saddow [Microsoft], Mar 8, 2007
    #17
  18. DavidW

    Techjunkie Guest

    Hi Peter,
     
    Techjunkie, Mar 8, 2007
    #18
  19. DavidW

    Alan Guest

    Hi Peter,
    I am also having a similiar problem. Running ACT 2007 for Workgroups with 3
    users. Here is the Summary Log file. Thanks for your help. Alan

    Time: 03/09/2007 13:08:09.031
    KB Number: KB921896
    Machine: ALAN_DESKTOP
    OS Version: Microsoft Windows XP Professional Service Pack 2 (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 (ACT7) ENU SP1 2005.090.2170.00
    x86 EXPRESS
    Express Database Services (SQLEXPRESS) ENU SP1 2005.090.2047.00
    x86 EXPRESS
    Express Database Services (SQLExpress) ENU SP1
    x86 EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product Reason
    Express Database Services (ACT7) User authentication failed.
    Please check to see if the password provided is correct or check to see if
    the SQL Server Instance is set to Mixed Authentication

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

    **********************************************************************************
    Product Installation Status
    Product : Express Database Services (ACT7)
    Product Version (Previous): 2170
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number : 11046
    Error Description : User authentication failed. Please check to see
    if the password provided is correct or check to see if the SQL Server
    Instance is set to Mixed Authentication
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLEXPRESS)
    Product Version (Previous): 2047
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features :
    SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLExpress)
    Product Version (Previous):
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : Client_Components,Connectivity,SDK
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
    User authentication failed. Please check to see if the password
    provided is correct or check to see if the SQL Server Instance is set to
    Mixed Authentication
    Exit Code Returned: 11046
     
    Alan, Mar 9, 2007
    #19
  20. DavidW

    Alan Guest

    Running into similiar problem. Running ACT 2007 for Workgroups. My
    Summary.txt file states:

    Time: 03/09/2007 13:08:09.031
    KB Number: KB921896
    Machine: ALAN_DESKTOP
    OS Version: Microsoft Windows XP Professional Service Pack 2 (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 (ACT7) ENU SP1 2005.090.2170.00
    x86 EXPRESS
    Express Database Services (SQLEXPRESS) ENU SP1 2005.090.2047.00
    x86 EXPRESS
    Express Database Services (SQLExpress) ENU SP1
    x86 EXPRESS

    **********************************************************************************
    Products Disqualified & Reason
    Product Reason
    Express Database Services (ACT7) User authentication failed.
    Please check to see if the password provided is correct or check to see if
    the SQL Server Instance is set to Mixed Authentication

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

    **********************************************************************************
    Product Installation Status
    Product : Express Database Services (ACT7)
    Product Version (Previous): 2170
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
    Error Number : 11046
    Error Description : User authentication failed. Please check to see
    if the password provided is correct or check to see if the SQL Server
    Instance is set to Mixed Authentication
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLEXPRESS)
    Product Version (Previous): 2047
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features :
    SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------
    Product : Express Database Services (SQLExpress)
    Product Version (Previous):
    Product Version (Final) :
    Status : Not Applied
    Log File :
    SQL Express Features : Client_Components,Connectivity,SDK
    Error Number : 0
    Error Description :
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
    User authentication failed. Please check to see if the password
    provided is correct or check to see if the SQL Server Instance is set to
    Mixed Authentication
    Exit Code Returned: 11046
     
    Alan, Mar 9, 2007
    #20
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.