SQL Server - sqlserver2005 express sp4 will not update

I have been trying tou update sql server for months now.  I get a variety of errors, D56 being the most popular!

I have tried updating manually, and despite thinking that success in the dialogue box meant it was updated I still get the important update in windows update....... 

I find that mssmlbiz may be the problem, but as I have no idea what sql server is doing on my computer in the first place I am not sure what mssmlbiz is all about either.

Can someone please shed some light on what my problems may be?

Is SQL server needed at all?

Can I rid myself of the problem by simply deleting sql server...?

here is a copy of the log file.

Time: 04/23/2011 11:24:42.372
KB Number: KB2463332
Machine: GOLDFINGER
OS Version: Home Edition Service Pack 2 (Build 6002)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 4
Package Version: 5000
Command-line parameters specified:
Cluster Installation: No

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

**********************************************************************************
Products Detected             Language  Level  Patch Level     Platform  Edition
Express Database Services (MSSMLBIZ)    ENU     SP3    2005.090.4053.00  x86     EXPRESS
Express Database Services (SQLEXPRESS)    ENU     SP4    2005.090.5000.00  x86     EXPRESS
Express Database Services (SQLExpress)    ENU     SP4           x86     EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product                   Reason

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

**********************************************************************************
Product Installation Status
Product           : Express Database Services (MSSMLBIZ)
Product Version (Previous): 4053
Product Version (Final)   :
Status            : Failure
Log File          : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
SQL Express Features    : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number        : 3414
Error Description     : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product           : Express Database Services (SQLEXPRESS)
Product Version (Previous): 5000
Product Version (Final)   : 5000
Status            : Success
Log File          : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
SQL Express Features    : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number        : 0
Error Description     :
----------------------------------------------------------------------------------
Product           : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final)   : 5000
Status            : Success
Log File          : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB2463332_SQLEXPR.EXE
SQL Express Features    : Client_Components,Connectivity,SDK
Error Number        : 0
Error Description     :
----------------------------------------------------------------------------------

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

Nig

Suggestion:

will this run on a 64 bit system with dual core processor?

Absolutely. Don't forget, 64-bit systems can also run 32bit software.

Thanks Peter, I am on it now.

Agh, I am not having much luck here....

I deleted 2005..... no problems there.

downloaded 2008, tried to install.  got an error saying I needed to restart the computer, I did this.  Still got the restart error!!

Tried to run program as an administrator, still the same problem.

ran the computer in safe mode, by passed the restart problem, but got errors..
here is the log text of the error.
TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:

SQL Server Setup has encountered an error when running a Windows Installer file.

Windows Installer error message: The Windows Installer Service could not be accessed. This can occur if the Windows Installer is not correctly installed. Contact your support personnel for assistance.

Windows Installer file: c:\1e683b7e8d489227fb752d37c3cca6\x86\setup\SqlSupport.msi
Windows Installer log file: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20110424_080705\SqlSupport_Cpu32_1_ComponentUpdate_1.log

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0x5D9A8C61

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------


Strangely my computer seems to be working just fine without SQL server on it at all and I have stopped getting the irritating update reminder.

Do I need SQL server?

Nig

If you do not use SQL Server, then you do not need it.

Fantastic, my computer is a happy bunny.

Thanks for  your advice...


Nig