remove entries from ssms server name

I am using 2K8 if that matters.
when you open ssms and click Connect > Database Engine you are presented with a dialog that may have a list of entries under Server Name.
I want to be able to remove entries from this list.
If that is not possible then can I clear the list?

Thanks
LVL 25
dgrafxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Just select the server name that you want to delete from the list and press the delete key.
0
dgrafxAuthor Commented:
no - that doesn't ...
I did find that solution when Googling and one would hope that something like this that is similar to other software would work - but it doesn't.
In some of these same articles / forums one sees that many responders say it doesn't work for them either.

Thanks
0
Tapan PattanaikSenior EngineerCommented:
Hi dgrafx,

For SQL Server Management Studio 2008

For removing  Server name, Login , Password please  delete the file:

C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Regards,
Tapan Pattanaik
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Which version of SSMS do you have? Should work at least for SQL Server 2012 and 2014.
0
dgrafxAuthor Commented:
Tapan - yes that works - thanks
Is there a way to remove an item from the list instead of clearing?

Vitor - I stated what version in the first line of my first post

Thanks
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. Didn't see it at first time. You can always install earlier versions of SSMS as won't affect your SQL Server engine.
About the SqlStudio.bin there's more stored information than server names so you'll lose all configurations from your SSMS.
0
dgrafxAuthor Commented:
yes - i understand that - thanks.
but am wanting to know if there is a solution to removing one item from a list of servers on ssms 2008.

thanks
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
As far as I know, a single item, no.
0
Tapan PattanaikSenior EngineerCommented:
Hi dgrafx,

As per my knowledge you can't remove an single item from the list instead of clearing.
0
dgrafxAuthor Commented:
Thanks
I've read that on newer versions (2012 +) simply highlighting the server then hitting the delete key will remove the server
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.