Go Premium for a chance to win a PS4. Enter to Win


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

Posted on 2010-09-08
Medium Priority
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

971 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