Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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
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
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
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…

722 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