x
login about faq Site discussion (meta-askssc)

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 '11 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 '11 at 03:48 PM

Tim gravatar image

Tim
31.5k 20 31 116

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 '11 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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x6

asked: Mar 01 '11 at 03:44 PM

Seen: 525 times

Last Updated: Mar 01 '11 at 03:44 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.