Sql Server Management Studio Express (2005 or 2008) - Save Password Doesn't work

I always click "Remember Password" when connecting to a database server.

Sometimes when I come back into SSMS, it has it remembered, sometimes not. More often it does not. I regularly connect to about 4 different servers, it's fairly random when it works for which serve开发者_如何学Crs.

How can I get this to work all the time?

Yup this is a known bug in SSMS - I believe all versions, reported here on connect. I have experienced it in the past, yet had machines that never had any problems.

I would love to say I have a solution for it, but unfortunately the solution for me was to allow windows authentication for connecting instead.

My recommendation is to post on the bug report and if enough people do it Microsoft will either fix it or provide information about it. Yes, they do pay attention to connect bug reports when they get 'popular'.

I found this link on the connect link provided by eddiegroves.

It is a tutorial that shows you how to create a new server registration. I've added one, restarted SSMS a couple times and it seems my password is still there...

I've experienced this issue in 2005, 2008 and 2008 R2. Haven't found a fix, but here's a workaround (sort of): Assuming that you've successfully logged in to a given server previously... When you open the "Connect to Database Engine" dialog, press the down arrow followed by the up arrow on your keyboard, and SSMS magically "remembers" the forgotten password! Not a fix, but certainly easier that typing out a password.