x

Getting rid of phantom SQL instances to install SQL 2008 R2

Hey all,

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.
more ▼

asked Mar 01, 2011 at 03:44 PM in Default

cjohn5552 gravatar image

cjohn5552
21 3 3 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Mar 01, 2011 at 03:48 PM

Tim gravatar image

Tim
36.4k 35 41 139

Thanks, that is what I'm considering at this point. I think the issue was that I inherited the computer from someone else and installed SQL Express in a failed experiment. Hopefully, a formatted install of SQL 2008 R2 will last me for a while.
Mar 01, 2011 at 05:41 PM cjohn5552
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x6

asked: Mar 01, 2011 at 03:44 PM

Seen: 849 times

Last Updated: Mar 01, 2011 at 03:44 PM