3

How can I force SSMS to forget the recently used logins?

Of course I use "SQL Server Authentication" with Login/Password fields.

(It get's annoying, as everytime I open SSMS it shows the "Connect to Server"-Dialog, with a login preselected that is not valid anymore.)

Didn't find any option, and no info here.

Thank you.

Improve this question
1
  • I haven't installed SP3 yet, I try this now to see if it maybe resolves the problem (same as using SSMS 2012 would).
    – SwissCoder
    Nov 26, 2012 at 5:33

2 Answers 2

Reset to default
3

If you move to SQL Server 2012 Management Studio (and no reason not to, now that it's free and you can still manage the same set of down-level servers that 2008 R2 lets you manage), you can simply delete old servers right from the connection dialog using the standard Delete key.

Improve this answer
6
  • 1
    It would have been nice if they had implemented the same delete logic for the login list, too. (Edit: Whoops. Accidentally tested on the wrong box.)
    – Jon Seigel
    Nov 23, 2012 at 18:11
  • What you mean by free Aaron? I am a bit reluctant to istall the express edition, I don't want to have too many installs. Since when is the full version free?
    – SwissCoder
    Nov 26, 2012 at 5:02
  • Well from the SQL Server Express Download page microsoft.com/en-us/download/details.aspx?id=29062 the Management Studio is a separate download, so I guess that's what you mean. I'm currently installing it, thank you for the hint!
    – SwissCoder
    Nov 26, 2012 at 5:31
  • @SwissCoder no, did you read my blog post? I think you'll need the SP1 version from microsoft.com/en-us/download/details.aspx?id=35579
    – Aaron Bertrand
    Nov 26, 2012 at 13:47
  • I read your blogpost, but didn't realize ur link for Express SP1 would point to the full installer. Unfortunately Windows Update seems to be unaware of the SP1, so I have to go for a full download/install again.. (300MB more than the pre SP1 Version, I wonder what they packed in there additionally!)
    – SwissCoder
    Nov 27, 2012 at 4:54
2

Try to delete the following file and open the SSMS and see.

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

Hope this helps!

Improve this answer
4
  • 1
    Thank you Gowdhaman, but I think I will not simply delete all this file, as I see there are many other settings stored in this file as well (for example: Microsoft.SqlServer.Management.UserSettings.QueryExecutionSettings). Actually I found the user in there and tried to remove it from that configuration, but when I reopen SSMS it will add the user again to this file...
    – SwissCoder
    Nov 23, 2012 at 8:08
  • Did you deleted alone SqlStudio.bin file. that resolved my problem.
    – Gowdhaman Dhandapani
    Nov 23, 2012 at 9:49
  • Hello Gowdhaman, I can deelete only this file, but then I loose other information. I want to explicitly only loose the information for the logins, or better for 1 specific login only.
    – SwissCoder
    Nov 23, 2012 at 11:16
  • I dont think we can do that, because SqlStudio.bin file is the binary file and its very dangerous to edit in binaries.
    – Gowdhaman Dhandapani
    Nov 23, 2012 at 11:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.