This problem is making my head sore so really hope someone can through some light on the subject. I have a Vista Bus SP1 HP nx9420 laptop with 4G memory. I run SQLEXPR2005 for various small database projects (none installed at present so no databases present)
A couple of weeks ago I had a problem with SQL2005 SP2 which was applied through windows updates (WSUS3 from our SBS2003 server) I can;t remember the error, but I donwloaded the SQL SP2 manually and deployed it OK.
This week I've had an update to SQL2005 which is KB960089 which fails to install through Windows update and I can't get it to install manually either (Error code c064. Since I'm about to start work on a project I wanted to tidy the install up so elected to uninstall then reinstall SQL2005 on this Visa PC, I can't.
I have tried uninstall through Control Panel/Programs and features but that fails during the setup progress (3 log files are included but the datastore log is XML and won't upload here) If I try to run the SQL setup program this reveals a Pending Reboot which won't clear.
I did try the SQLEXPR SP3 for 2005. Which install a default instance but would not update the named SQLEXPRESS instance.
I've obtained the MS 'Manual' cleanup script but it is less than clear and mostly fails whenever I attempt part of it (this is KB957008 29/01/2009 rev 3)
How do I cleanup and start again?
Or how do I approach getting the setup/uninstall to function again.