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