Otek,
Try installing as uncompressed and as a separate file. This is a requirement, despite OS. I actually downgraded to XP (was on Vista Ultimate and just got tired of all the Windows Update errors, coming back once the bugs get fixed) and got the 0x6D9E myself; Windows, basically, wants this as 2 separate files, uncompressed, in 2 separate locations; I got the "better" (more detailed) error code once I re-installed it properly & did my "rinse & repeat" (see below) process to purge the Update cache. In the event you get the 80070002 or 80070003 (full error code looks like 0x80070003), be prepared to do the following (regular problem for me w/ Vista!)... and good luck:
0x80070002
0x80070003
1.) The first step is temporarily disabling Windows Automatic updates.
Start, Run, services.msc; In Vista, just click your Vista Pearl button and type Services.msc in the dialogue box. Right click the service Automatic Updates, click Stop in the services pane.
(Ignore/close any messages/popups your Anti-Virus/Anti-Spyware Software may give you, my PC-Cillin is sensitive to service changes.)
2.) The second step is clearing DataStore. This couldn't be done w/out stopping
the process before-hand or else we'd get an error.
Go to Start, Run, %windir%\SoftwareDistribution
Double-click DataStore and delete all contents.
*This is the same path as going into your C:\Windows\SoftwareDistribution\DataStore folder. Frequently, Windows Update errors are cured by clearing, alternatively, C:\Windows\SoftwareDistribution\Download (deleting the entire folder).
3.) Go back to the Windows Automatic Updates and make sure it's started-up again.
Start, run, services.msc
right-click the service Automatic Updates. Click Start.
Restart your computer and attempt to reinstall SQL Service Pack 2.
I hope this helps!
Erik
CSI.CrimeSceneInvestigation
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com