Solved

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

Posted on 2009-03-30
10
850 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

776 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