I have about had it with this tool, I check the save password box at the login dialogue but it just doesn't work. Sometimes it will for a few days, and then the password will just be gone. Nearly every time I load this thing up I have to track down the password again and type it in. Is there some password rule in the database that would be causing this? This is driving me absolutely crazy.
+2
A:
Same thing here. Use Toad instead. It sucks less. And it can sort, something I found lacking in Mgmt Studio.
StuffMaster
2009-03-18 18:05:06
SSMS can't sort? Have you tried ORDER BY?
recursive
2009-03-18 18:54:32
I believe that's server-side. I'm talking about the interface, being able to click on a column to sort.
StuffMaster
2009-03-26 17:50:47
+1
A:
I have the same problem, and some of my colleagues too. Searching tells me that some have the same problem and some doesn't experience it at all.
Microsoft has been aware of this for two years or more, but so far it doesn't appear to be a solution...
MSDN Forums "SQL Server Management Studio 2005 forgets password?"
Here's someone why had some luck by typing in the server name instead of selecting it in the dropdown. (I haven't tried this myself yet.):
eggheadcafe "Management Studio forgets password ("change connection")"
Here's a bug report from 10/2006 that is closed because it's a dupliace, but I haven't been able to find the original bug report...
Microsoft Connect: "'Remember Password' option is not remembered in Registered Server Properties"
Guffa
2009-03-18 18:31:57
A:
Sometime ago I got the impression, that you will lose these passwords if you change your windows login password. It might be coincidence and not true at all.
dummy
2009-03-21 11:13:13
A:
Same problem here. This problem occurs while still using the same Windows password, so I don't think that is the cause. I did suspect that it might have been machine profile-based - which only happened to my "docked" vs. "undocked" laptop. I'm not so sure anymore - I think it is just a bug that has been forgotten.