views:

178

answers:

2

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 servers.

How can I get this to work all the time?

+2  A: 

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'.

eddiegroves
I'm really immpressed that MS let this persist from 2005 through 2008... and I'm guessing it'll be in 2010 SSMS as well
hamlin11
SSMS is kinda like a bastard child of the Visual Studio team + SQL team. And look at the duplication between the current VS and SSMS. Fact is, tooling for DBAs is not a priority from MS.
eddiegroves
Do you think I should accept this answer or delete the question?
hamlin11
A: 

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...

BrunoLM
Over 10 days and it is still working. Seems the perfect workaround.
BrunoLM

related questions