Solved

Microsoft SQL Server 2005 SP3 Express with Advanced Edition fails to install

Posted on 2009-03-30
10
818 Views
Last Modified: 2012-05-06
Microsoft SQL Server 2005 Express Edition wtih Advanced Services Service Pack 3 fails to install. This was pushed via WSUS. Clients attempt to install but fail. When downloading the version directly from Microsoft it installs but the Windows Update icon does not dissapear. We have rebooted, restarted services but can't resolve this issue. It still shows as failed from the WSUS notification. Haven't found any articles while researching yet.

Anybody experiencing this issue? Microsoft Windows Update Team suggest this is not an update issue. Oldly enough they made the service pack available via WSUS. NICE!!!!

Here is what they say
If you have not installed SQL Server manually, most likely, some database applications such as ACT are using SQL Server Express edition therefore SQL Server Express edition was installed by database applications. Since the installation failure of this SQL server update can be caused by corruption in the SQL program itself, we may have to recommend contacting our SQL Support team directly

0
Comment
Question by:Colmanh
  • 4
  • 3
  • 2
10 Comments
 
LVL 47

Accepted Solution

by:
dstewartjr earned 125 total points
ID: 24022910
This is most likely the problem

The XP SP3 / MSXML6 SP2 / SQL Server debacle
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24026211
0
 

Author Comment

by:Colmanh
ID: 24029433
The solution sugested by dstewartjr worked very well in this case.

I ran the Windows Installer Cleanup Utility as suggested in the SQL Blog article to remove MSXML6. This resolved the issue with one of my users and the SQL SP installed succesfully. We are going to try the same for some other users. The great news was that I did not have to remove XP SP3 or SQL so that saved a lot of time.

Thank you so much for your help and time. BTW the article from GLComputing is extremely helpful.

Best regards

C.
0
 
LVL 47

Expert Comment

by:dstewartjr
ID: 24029536
"The solution sugested by dstewartjr worked very well in this case."

Then you may have accepted the wrong comment as the solution.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24029578
As dstewartjr indicated, you can also split points between different experts who have provided information helpful to you
0
 

Author Comment

by:Colmanh
ID: 24029599
Opps. Any way to fix that?
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24029627
I think, if you click "Request Attention" in the origianl post it might attract an Admin who can re-assign
0
 

Author Comment

by:Colmanh
ID: 24029713
Done. I'll see what they come back with and update it.

Appreciate your support
0
 

Author Closing Comment

by:Colmanh
ID: 31564390
Super recomendation and solution. Have happy users :)
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now