I would really like to remove a user name from the SSMS "Connect to Server" dialog, but I can't figure out how, and I can't find if anywhere.
I don't want to delete the SqlStudio.bin file, or the mru.dat file, because that resets all the login information, plus a bunch of other settings as well.
Also, I already tried hovering over the user name and hitting the delete key. I even tried the backspace key for good measure. No luck on those.
If anyone knows of something I haven't tried, I'd be most grateful.
Thanks in advance!
P.S. - SSMS 2016 on Windows 10
If you are using SSMS 2012 or greater, you can simply delete the server from the dropdown and that will allow you to start fresh with just that server by highlighting it in the dropdown and hitting Delete See below link for reference to Aaron Bertrand's answer:
One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server does not require in the future.
Let me demonstrate it step by step. In order to open “Connect to Server” window, first of all you need to select file menu and click on connect object explorer.. in SSMS as shown below.
To remove a saved login, delete the associated saved server name. Expand the server name drop-down list, hover over a server name, and hit the delete key. Thanks for contributing an answer to Stack Overflow!
To remove a saved login, delete the associated saved server name. Expand the server name drop-down list, hover over a server name, and hit the delete key.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With