How can I delete Un_installed servers from the sql server Config manager>

Question

How can I delete Un_installed servers from the sql server Config manager>

SQL learner22

Default port

Points: 1487
More actions
March 7, 2013 at 12:28 pm

#275008

i have 12 instances that i have installed and Uninstalled from my laptops and sql services are still showing in the configuration manager?
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

I would then say that they are wither not uninstalled completely or that there was a problem with the uninstall. If you are positive that they all uninstalled correctly, you could alter the registry and remove the instance names. I don't recommend this, but as a last resort you could do this. If you go to my blog, I have a related post. It will show you the location if the keys.

Jared
CE - Microsoft

Lowell SSC Guru Points: 323518 More actions · Answer 2

i believe he's not talking about the registry for installed machines, but rather the saved connections that SSMS might have connected with in the past.

those connections are stored in a persons personal application settings;

as i remember it is is an all-or-nothing thing. you cannot selectively remove a couple of entries.

you also loose settings like keyboard shortcuts, the default output size of SQL results, etc.

ie mine for SQL2008 SSMS is stored in

%SystemDrive%\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\

my notes say browse to this location:

%SystemDrive%\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\

(For SQL Server 2008 should be 100 instead of 90)

2. Backup and then delete the 'Shell' folder. This folder will be rebuilt when you start SSMS. You will lose your connected server history, but you should retain recent files, etc.

For SQL 2005, delete the file:

C:\Documents and Settings\(UserLogin)\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

For SQL 2008, they changed the name of the file:

C:\Documents and Settings\(UserLogin)\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL learner22 Default port Points: 1487 More actions · Answer 3

you right about that I did not uninstalled the services from the computer.

i thought I did.

thanks