Failure To Install Microsoft SQL Server 2005 Express Edition SP2 & SP3 In Windows 7.

Posted on 2010-09-08
Last Modified: 2012-05-10
Hello. I have an issue I hope you can answer.

Hello. Can not install a Windows Update (Fails!): Microsoft SQL Server 2005 Express Edition
 Service Pack 2 (KB921896) or Service Pack 3 (KB955706) Installation status: Failed Error
details: Code 6D or 41D  randomly given for either service pack. If I attempt to try to install
and then reboot/restart the system and attempt again to install, I will get one or the other
Error Details Code (either Code 6D or Code 41D).

I have tried on several occasions to fix this issue and have had an unsuccessful installation
on my Windows 7 Professional in each instance. I do not know what is causing the install
failure or even how to fix this issue.

I have tried downloading the 32-Bit version (x86) of Microsoft SQL Server 2005 Express
Edition Service Pack 3 (KB955706) as an EXE file form Microsoft website and installing it
separately in Safe Mode to see if I could get this service pack 3 installed. Unfortunately, I
can not get it installed either in Safe Mode after a few attempts.

To add, I have installed Microsoft Office 2007 Ultimate that I know has a feature called
MSSMLBIZ which relates to Microsoft SQL Express. This was installed when I installed
this software suite.

How can I successfully install both these service packs into my system? I had no issues
with Microsoft SQL Server 2005 Express Edition in Windows XP when I had installed
Microsoft Office 2007 Ultimate? I remember installing SP2 & SP3 just fine on Windows XP.      

Please reply with the reason (possibilites) and resolution(s) to this issue.
Thank you!

Question by:TechnoTroy
  • 3
  • 2

Expert Comment

by:Cesar Aracena
ID: 33633257
Hi TechnoTroy,

I had the same problem when installing Visual Studio .NET. The error appeared when it tried to install SQL. I fixed it by formatting and installing Visual Studio BEFORE Microsoft Office 2007. Both installations ran very smoothly in that order.

I'm pretty sure somebody else could point out another way that doesn't involve formatting the PC but unfortunatelly I didn't want to spend 12 hours looking for a solution. Formatting was the fastest approach in my case.

Author Comment

ID: 33633432
Hello. Thanks for your reply, Caracena!

I appreciate your prompt reply. I see you basically state that I would need to do a complete re-install to overcome this issue -- a clean re-install of my Windows 7. Not exactly exciting me. I will have to hide the updates so they do not keep trying to install. What exactly is causing this? Any idea why? I mean if I were to do another re-install of Windows 7, this issue would not come back and both service packs would install fine? ...or would I have the same issue again? Something particular to Windows 7?          

Expert Comment

by:Cesar Aracena
ID: 33633520
Well... I forgot to say that I'm using W7 Ultimate x64 so yes, it worked fine with this OS. I'm not saying it's the only possible solution, but the fastest in my case and maybe someone else find a better work around.

Windows 7 installation should take no more than 1 hour or so and basic programs installation another 2 hours so 3 hours worth of work was better than 6 to 12 hours of looking into solving the problem itself.

If you do it and it works, well good for you (again, this worked for me but not everyone uses the same programs & configurations... not even the same languages in my case is Spanish). If it doesn't work, at least you'll have a fresh windows install to play with. I look at it as an excercise hehe.

Accepted Solution

TechnoTroy earned 0 total points
ID: 33659378
This is the solution. I found it the HARD WAY! Part of my Office 2007 Ultimate features, I need to have Business Contact Manager installed in order to interact with my SQL Server Express 2005. Since I installed by default the SQL Server Express 2005 from the Office 2007 software without having any programs dependent upon it (I did not want to install Business Contact Manager at that time.) , it would give errors -- I think to other realted Windows servcies as well (SQL services). You need to install the Business Contact Manager just to "satisfy" SQL Server Express 2005. But if you STILL do NOT want to use Business Contact Manager, then you have to DISABLE it in the system registry and DO NOT UNINSTALL IT or your back to the same senario I am experencing now. Now, Windows Update sees SQL Server Express 2005 installed on my system. But since SQL Server Express 2005 cannot run becuase it is dependent upon having a program installed to use it (no Business Contact Manager installed), it refuses to update with those service packs (2 & 3). I had to install Business Contact Manager, then the Windows Updates for SP2 & SP3 for SQL Server Express 2005 installed.    

Expert Comment

by:Cesar Aracena
ID: 33662681
Good to know. Nice workwaround. Maybe I "satisfied" SQL by installing both fully in reverse order? Don't know. Still took me less time by formatting hehe.

Glad to see you worked it out ;)

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.

740 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