November 5, 2008 at 6:14 am
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?
November 5, 2008 at 6:46 am
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
January 6, 2009 at 3:16 am
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.
May 9, 2014 at 7:44 pm
try this
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
remove the key name MSSQL10.(the servername want to remove)
May 9, 2014 at 11:59 pm
tieudu09 55544 (5/9/2014)
try thisHKEY_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
[font="Courier New"]HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\[version number]\SSDT\ConnectionMruList[/font]
where the [version number] denotes the server version. If I remember correctly, it's under
[font="Courier New"]HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio[/font]
for earlier versions.
May 10, 2014 at 12:43 am
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.
May 10, 2014 at 1:01 am
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!
May 10, 2014 at 1:09 am
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 :crazy:
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy