Solved

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

Posted on 2010-09-08
5
660 Views
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!

0
Comment
Question by:TechnoTroy
[X]
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
5 Comments
 
LVL 6

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.
0
 

Author Comment

by:TechnoTroy
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?          
0
 
LVL 6

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.
0
 

Accepted Solution

by:
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.    
0
 
LVL 6

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 ;)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

623 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