Solved

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

Posted on 2010-09-08
5
642 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
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:Caracena
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:Caracena
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:Caracena
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
HP 15-F033WM Drivers 4 28
Need a poor man's PowerPoint 5 40
MS Office subscription 11 35
cannot unmapped a network drive 10 51
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now