?
Solved

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

Posted on 2009-03-30
10
Medium Priority
?
870 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
10 Comments
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 500 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 47

Expert Comment

by:Donald Stewart
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
 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.​
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

762 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