Amazingly, I’ve only just upgraded to using SqlServer Management Studio 18. I immediately ran headlong into the infamous issue of it not remembering passwords.
Turns out the fix is simple. If you imported settings from a previous version, this seem to be the root cause for majority of people. The background here is SSMS 18 switched to using the Windows Credential Manager and this seems to be the root source of the issue with importing settings.
To fix sqlserver management studio passwords storage
- Shutdown any running instances
- Delete the directory – C:\Users\jamme\AppData\Roaming\Microsoft\SQL Server Management Studio\18.0\
- Re-start SSMS (will recreate the previously deleted directory)
- Connect to the database and remember to check the remember checkbox
- Profit!
Amazingly, I’ve only just upgraded to using SqlServer Management Studio 18. I immediately ran headlong into the infamous issue of it not remembering passwords.
Turns out the fix is simple. If you imported settings from a previous version, this seem to be the root cause for majority of people. The background here is SSMS 18 switched to using the Windows Credential Manager and this seems to be the root source of the issue with importing settings.
To fix sqlserver management studio passwords storage