Solved

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

Posted on 2009-03-30
10
835 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:
Donald Stewart 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: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
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.

 
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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

21 Experts available now in Live!

Get 1:1 Help Now