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.
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!
Pull your thumb out of your backside and FIX YOUR STUPID BUGS
Rolled back to 17.9.1, no issues there. Will stick with that until this is resolved.
I just upgraded to 18.1 and server names and passwords are now getting wiped out when I use runas.exe to start SSMS. I have to alternate between running SSMS normally, and using runas.exe /user:xyz but doing so wipes out the entire list. This is very painful...
Martin Szabo commented
It just happened to me that it forgot all my servers, and I'm running latest (17.9.1). In the past few weeks it has forgot passwords for my most used user.
We made some improvements in this area for SSMS 18.
Could you see if you can repro the issue with the latest Preview 5?
Happens to me as well. I have a SQL2012, SQL2014 and SQL2017 SSMS installed on different machines, each managing to forget passwords. SQLOps is much better are Managing SQL than Microsoft is.
Utku Genel commented
very annoying bug. still happens on SSMS 2017.
I think bug appear after windows update.
Steve Mendoza commented
Same issues here too.
Rui Holdorf commented
It happens more often when you have connections to remote servers. Very rarely when you're connected to a local instance. The password will last for a few days, then SSMS will forget that, but wont forget the server name. As far as I can recall, that happens since the year 2008.