I have had a number of different SQL installations on my computer (2005, 2005 express, 2008). I uninstalled all the SQL modules I could find using Revo Uninstaller, but when I try to install SQL 2008 R2, it shows a number of instances that are already there (including the default instance, meaning I can't install under the default instance, which is what I want to do).
Also, SQL services such as SQL Agent are still showing up under services. It seems that SQL has been incompletely installed. I tried deleting stuff from Program Files and combing through the registry to delete mentions of SQL (perhaps unwise but I only deleted stuff that was blatantly associated with it, and I figure there shouldn't be any mentions of it if I've uninstalled it properly).Anyway, can anyone point me to a resource for things to check to make sure phantom instances aren't picked up by the installer? Thanks.
asked Mar 01, 2011 at 03:44 PM in Default
You really have done most of the things I would do. There are some other MSI cleanup stuff but honestly the best way to clean up your system if you have had so many instances installed is to wipe the box and start over. Also might I suggest in the future if you will be doing these sorts of testing activities to use a VM for it. VMLite is free and simple to use. It will save you the heartache of messing up your primary station.
answered Mar 01, 2011 at 03:48 PM