SQL Server Management Studio 18 remember password not working?

galletto 186

With one of the latest updates of SSMS 18 (I'm now on 18.6), the remember password feature does not seem to work anymore. Am I missing something?

Cheers,
Galletto

Leo Muller 26 Reputation points

2020-11-02T11:36:18.317+00:00

It seems that SQL Server Management Studio from time to time randomly sees to forget your password that you clearly asked to remember. Even though many times it may remember, and then one day, it forgets.

This seems to happen ALWAYS when you have something stored in your CLIPBOARD when you open SQL Management Studio.
hermecDBA 1 Reputation point

2020-12-02T23:53:58.13+00:00

If anyone also has this issue, please vote it up here:
https://feedback.azure.com/forums/908035-sql-server/suggestions/41354875-ssms-18-6-remember-password-option-doesnt-work
Will de Haan 1 Reputation point

2020-12-04T08:06:58.167+00:00

@hermecDBA that forum asks me to provide a password, but it's not clear to me for what account?
Jay Imerman 11 Reputation points

2020-12-17T19:33:55.393+00:00

For the Vote Up, we need an "Up +1000" for this particular issue! It has been doing this for years now, and it is so annoying.
Jay Imerman 11 Reputation points

2020-12-17T19:34:05.283+00:00

For the Vote Up, we need an "Up +1000" for this particular issue! It has been doing this for years now, and it is so annoying.
galletto 186 Reputation points

2020-12-21T08:15:35.503+00:00

I tried voting, but it won't accept my login there.
Bill Guenthner 1 Reputation point

2021-08-13T14:05:14.007+00:00

I don't understand it either. Microsoft struggles to keep basic functionality working in many of their applications. It can't be a lack of talent so it has to be a lack of caring.

11 answers

Jay Imerman 11 Reputation points

2023-01-19T19:37:59.2633333+00:00

I found a permanent solution! I am dropping SMSS, and am now using dbForge for SQL Server. This is an awesome tool! The ER diagram tool is compliant with industry standards and lacks all the bugs of SMSS, it saves passwords, and allows you to mark the maturity of each database (Dev, Test, Production...). It also allows you to sync database with a SCM, and compare and sync databases with each other. That's only a small portion of the features, it is so feature-rich I don't think I need another tool again.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

SQL Server Management Studio 18 remember password not working?

11 answers