I had installed 2008 express r2 but without the management part of it. So I downloaded the installer for the management part of it and launched the install. Went through the install and it majorly Messed everything up. So I attempted to go uninstall everything
via Add/ Remove... Which further destroyed anything related to SQL install or uninstall.
I performed a bunch of recommendations I found here on the MS sites.
http://answers.microsoft.com/en-us/windows/forum/windows_vista-windows_install/error-2203/d462b2e4-0f00-4db6-a010-b8847efb1200?auth=1
http://support.microsoft.com/kb/296175
http://answers.microsoft.com/en-us/windows/forum/windows_vista-performance/windows-installer-service-is-missing-and-im-unable/fab7d3ad-3e7f-413f-a2be-2dc596724573
http://support.microsoft.com/kb/2642495/en-us
Also did one final try by Removed all references from registry deleting install folders etc. Cant find that tab open cu ...
Go to the complete details ...