RE: Error installing (KB 921896)

Hi Peter, I have the same problem as the others and have tried to solve it
over the last 2 weeks. My PC automatically downloaded and installed MS SQL
Server 2005 Express Edition SP2 on 14 occasions. 2 failures
and 12 successfully . I also downloaded the program from microsoft and
installed it manually. As on the Auto updates and Downloaded prog I got the
message " installation successful". Next day and the day after that, etc
etc I keep getting the same message that I need to download and install MS
SQL Server 2005 Express Edition SP2.
I tried to hide the update on Microsoft updates but was reminded by Win
Live Onecare that I need to restore hidden update, and the hidden update was,
you guessed it MS SQL ********SP2
As per your other answers on this subject, I have inclosed the Logs. I have
posted 2 logs which cover Failure and Success.
Time: 03/18/2007 10:01:43.312
KB Number: KB921896
Machine: SN2924177186
OS Version: Microsoft Windows XP Home Edition 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 (MSSMLBIZ) ENU SP1 2005.090.2047.00
x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (MSSMLBIZ) 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 (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 : 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
----------------------------------------------------------------------------------

**********************************************************************************
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

Time: 03/29/2007 15:12:06.859
KB Number: KB921896
Machine: SN2924177186
OS Version: Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level
Platform Edition
Setup Support Files ENU 9.2.3042
x86
Database Services (MSSMLBIZ) ENU SP1 2005.090.2047.00
x86 EXPRESS
SQL Server Native Client ENU 9.00.3042.00
x86
MSXML 6.0 Parser ENU 6.10.1129.0
x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00
x86

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

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

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSMLBIZ)
Product Version (Previous): 2047
Product Version (Final) :
Status : NA
Log File :
SQL Express Features :
Error Description : The edition of product instance MSSMLBIZ does
not qualify for this update.
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success
Exit Code Returned: 0



Hope you can help Peter, it's frustrating to say the least.

Thank You,
--
Tomarn


"Peter Saddow [Microsoft]" wrote:

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


"GPO" wrote:

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.

"Peter Saddow [Microsoft]" wrote:

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]

"GPO" wrote:

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?

"Peter Saddow [Microsoft]" wrote:

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.

"DavidW" wrote:

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 disabled
----------------------------------------------------------------------------------
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




"Peter Saddow [Microsoft]" wrote:

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]


"DavidW" wrote:

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?

.

Relevant Pages

  • Re: Error installing (KB 921896)
    ... wonder if there is a way to wipe the download from my system and start over. ... Installation status: Failed ... This service pack upgrades all Microsoft SQL Server 2005 Express Edition ...
    (microsoft.public.windowsupdate)
  • RE: Error installing (KB 921896)
    ... wonder if there is a way to wipe the download from my system and start over. ... Installation status: Failed ... This service pack upgrades all Microsoft SQL Server 2005 Express Edition ...
    (microsoft.public.windowsupdate)
  • RE: Error installing (KB 921896)
    ... I have downloaded the Microsoft SQL Server 2005 Express Edition Service Pack ... wonder if there is a way to wipe the download from my system and start over. ... Installation status: Failed ...
    (microsoft.public.windowsupdate)
  • Re: DONT REQUIRE CDs for Updates!!!!!!!
    ... If it still asks for your disc during installation select "Cancel" and ... Download and install the corresponding updates. ... > Signed a guy who has ALWAYS stood up for Microsoft, ... To vote for this suggestion, ...
    (microsoft.public.officeupdate)
  • Re: PB 5.0 Installation problem - Error in Cabinet File
    ... Dean Ramsier - eMVP ... I already have Microsoft Visual Studio .Net 2003 ... > Is there anyway I can get a complete installation CD? ... >> otherwise you will get a download failure error. ...
    (microsoft.public.windowsce.platbuilder)