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