For many, many weeks I was stuck in SQL Server hell, and almost, nearly, resigned to having to wipe my hard drive clean, in order to get SQL Server to un-install and re-install successfully !!!
SQL Server un-install wizard kept on getting stuck halfway through the un-install process…as it kept asking for, but would refuse to accept, the sqlsupport.msi file, even when pointing to a valid original install location!
Until I found the answer to my woe (amazingly it works… Like a magic charm!)
Save a file as “sql.reg” on your desktop with the following text (use copy-paste) shown in italics:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
“BootstrapDir”=”C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\”
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
After saving the file to desktop, double click the file and accept the dialog to merge this to your registry.
Then copy the following files from your installation folder to the location :
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2
Note: If you don’t see these folders just create them with the exact name
What is to be copied:
folder: x64/x86/ia64 (depending on 64bit, 32bit or itanium architecture),
Now run setup.exe from your installation folder again. Your fresh installation should begin.
Hopefully this helps you too.
See : Only the good stuff