SSMS Still Forgets Passwords
You closed this same issue many times as, variously, norepro and wontfix. However, this is a serious, long-standing issue for those of us unfortunate enough to have to manage numerous SQL Server deployments.
This is a known, reproducible issue, as you can tell from the many Google results, as well as the comments on the many reports of this bug you've ignored. Below is the description of the bug from my last report, which was closed as wontfix with no explanation.
SQL Server Management Studio (SSMS) has a long-standing bug that you refuse to fix. Below are some of the spuriously-rejected bug reports. Some of them even claim to be closed because of norepro. This is an issue that has affected your users for nearly a decade now: there is no way you can legitimately claim it is not reproducible. It's time for you to trust your customers (https://www.google.com/search?q=ssms+forgets+passwords returns 32,000 hits) and actually fix this. As a DBA managing a large number of servers, having my primary management tool arbitrarily forget passwords is absurd. Saving and retrieving credentials using a secure store is a simple, solved problem. Thousands of software packages manage to perform this simple task admirably, and somehow SSMS hasn't been able to get it right since at least SQL Server 2005. Fix it. https://connect.microsoft.com/SQLServer/feedback/details/779351/sql-server-2012-management-studio-spuriously-forgets-password-despite-being-set-to-remember-it https://connect.microsoft.com/SQLServer/feedback/details/342763/sql-server-management-studio-solution-explorer-doesnt-remember-sql-authentication-password https://connect.microsoft.com/SQLServer/feedback/details/332722/sql-server-2008-ssms-forgets-passwords https://connect.microsoft.com/SQLServer/feedback/details/330055/management-studio-forgets-passwords https://connect.microsoft.com/SQLServer/feedback/details/254048/connection-password-not-truly-saved
For SSMS 18 we moved the passwords into Windows Credential manager so they can be encrypted and decrypted more reliably.
Jan Swietlik commented
Forget and we use complex passwords by policies so fix this asap...
Still forgetting password!
Pham Do Huy THANH commented
In version 18.5, MS SQL server management studio still forget my password. Please fix it! Thanks.
RAY NOVAK commented
I noticed a new behavior in 18.x. It still forgets passwords in the old way (the password box is empty, and the remember box is not checked). Sometimes now it shows **** in the password field and the remember box is checked, as if it had remembered, but the password is wrong.
For me it remembers passwords, but just not in my projects. I tried everything. Too bad. I would really like to upgrade :-(
I had windows credential manager open and was refreshing it over and over watching to see when the credential was lost.
I opened SSMS and it saved my credential as expected. When I tried to run a script file without an open connection, the Connect to Server window pops up. When the popup first opens it deletes the credential it had just created seconds earlier.
Just want to echo and reinforce the OP's message. If he sounds frustrated, it's very well warranted. This has been a continual problem for at least a decade. Seriously, I've never even heard of such a common and reproducible bug hanging around that long. It's a constant annoyance.
For a while with 18.x the problem seemed to go away. I had attributed the "fix" to SSMSBoost, but now with 18.5 it's back, so I guess not.
Guy Barrett commented
How is this closed? The problem still persists. If you connect to the same single DB every time it works, if you change / connect to a different DB is forgets the password and you have to enter it again even if you have connected to that DB before and ticked "Remember Password".
Why is this so difficult for you guys to get your head around?
Povilas Panavas commented
18.5 broke this... it was working perfectly fine before the latest update. That's super annoying, as password is not something it's easy to get!
be v commented
can not remember password after upgrade to SSMS 18.4
and often crash after open a existed project file .
Jerry Medved commented
"For SSMS 18 we moved the passwords into Windows Credential manager so they can be encrypted and decrypted more reliably." - and yet I am using SSMS 18.4 and it still reliably forgets the password every time I restart it
Ok ... you moved password into the Windows Credential Manager
Is that a reason for forgeting password
Is that a reason to tag this post as COMPLETED.
You COMPLETED WHAT exactly ?
We need an answer like: It is a Bug and our ingeneers ar looking at it.
Not a dummy answer it is because password were moved to WCM
The worst is you tag this post a COMPLETED.
You did not COMPLETE anything!
SSMS 18.3.1 still buggy
This stupid software is unable to remember password.
Connect to ServerA, disconnect, reconnect, Close SSMS, restart SSMS connect to ServerA again and the password last used is recovered.
Now switch to ServerB, SSMS Ask Password.
Then Switch back to ServerA. Though a password is already in the textbox ***** it is incorrect and needs to be re-enter
As stated by another user ... Hey MS do you test your program before making it available for download. This should have been picked up after 2 minutes of testing
fix this ******* bug already!!!! My browser does a better job a managing passwords than this pos software!
Same problem as Dave Boltman
SMSS18.2 only remembers last password used.
Dave Boltman commented
It's not "COMPLETED" as as SSMS 18.2.
Please get someone at MS to just *use* SSMS for a few weeks. Do you do any kind of software testing before release?
Clearly the problem is not with encrypting and decrypting the passwords.
It's really not rocket science!!!
Dave Boltman commented
The latest SSMS seems to have more of a scripting kiddie - type problem - it always just remembers the last password. If I change databases, it fails to log in if the new database has a different password to the one previously used. In our office, all our dev servers have the same password, so as long as we stay on those, it works. However, when switching to a customer database (or back), then it fails to log in again.
Congrats for fixing other decade old problems (like backspace not working in the object explorer). Please get rid of your remaining scripting kiddies and use real developers. (Or just open source SSMS and let us fix for you)
SSMS 18.2, Windows 10 v 1803, build 17134.1006, SQL 2016 (SP2-CU7-GDR) - 13.0.5366.0 (x64)
this issue still persists on 2017. FIX THIS BUG!