Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Clear Database Engine Server Name drop down Expand / Collapse
Author
Message
Posted Wednesday, November 5, 2008 6:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 6, 2009 6:09 AM
Points: 3, Visits: 6
I have managed to fat finger a number of database engine server names that do not exist and now want to clear that list to start over. Anyone know how to do this?
Post #597268
Posted Wednesday, November 5, 2008 6:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:11 PM
Points: 12,905, Visits: 32,161
I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

mine has a list of 10 or so servers, all of which appear in the drop down for SSMS for me


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #597295
Posted Tuesday, January 6, 2009 3:16 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:12 AM
Points: 585, Visits: 385
I'm using the SQL2008 SSMS and have the same problem. I've found these keys and sure enough they list all of the valid servers I've connected to, but where I've mistyped a servername, it appears in the drop down but not in this are of the registry. Any more ideas?


---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
Post #630398
Posted Friday, May 9, 2014 7:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 7:44 PM
Points: 1, Visits: 6
try this
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

remove the key name MSSQL10.(the servername want to remove)
Post #1569482
Posted Friday, May 9, 2014 11:59 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 2,214, Visits: 5,979
tieudu09 55544 (5/9/2014)
try this
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

remove the key name MSSQL10.(the servername want to remove)


This has nothing to do with the Connection MRU (Most Recently Used), the registry keys for 2012/2014 are under

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\[version number]\SSDT\ConnectionMruList

where the [version number] denotes the server version. If I remember correctly, it's under

HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio

for earlier versions.
Post #1569490
Posted Saturday, May 10, 2014 12:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:47 AM
Points: 6,951, Visits: 7,066
For 2008 the list is actually in a binary file
%AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Removing this file will clear the list BUT WILL ALSO REMOVE ALL OTHER SSMS SETTINGS



Far away is close at hand in the images of elsewhere.

Anon.

Post #1569493
Posted Saturday, May 10, 2014 1:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 2,214, Visits: 5,979
David Burrows (5/10/2014)
For 2008 the list is actually in a binary file
%AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Removing this file will clear the list BUT WILL ALSO REMOVE ALL OTHER SSMS SETTINGS


Thanks David for the correction!
Post #1569496
Posted Saturday, May 10, 2014 1:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:47 AM
Points: 6,951, Visits: 7,066
no problem

It always annoys me when MS keeps changing config files and locations and why oh why try to obfuscate it in a binary file



Far away is close at hand in the images of elsewhere.

Anon.

Post #1569497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse