Failing SQL Server 2005 SP3 install
I finally figured out why the SQL Server 2005 SP3 install (for Express Edition) was failing on my domain controller… I had a DB on there set to “disabled” (instead of “manual” or “automatic”). The SP3 installer needs the DB to be startable in order to upgrade it. If you have SP3 still failing the install, check to make sure than all upgradable instances are startable.
J.Ja
I ran into an interesting issue when installing while installing SP2. The installation media path became corrupted and so I couldn’t install or uninstall the server. I had to use the Microsoft Installation cleaning tool to fix the matter.
Eww! I ran into another problem on a number of Vista machines, it turns out that my WMI repository had become corrupt. I had to fix it by doing the following:
1. Stop the WMI Management service
2. Delete/Rename C:WindowsSystem32WbemRepository
3. Start WMI Management service
4. Run "winmgmt /salvagerepository" as with administrator priviledges.
J.Ja
I also ran into a SP3 problem, it overlaid the entire data directory and wiped out 25 of our system test DB’s after the installer crashed… I spent a good chunk of Saturday restoring db’s. Other servers upgraded just fine though.