Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update

LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
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 (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

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

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

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
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) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

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

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.

Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

jn

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2