When I connect to a database using ssms, I also have a checkbox labelled "Remember password". However, ssms will not remember the password. The next time I connect to the same server, I have to write it again.

What is the actual functionality of the "remember password" checkbox?


2 Answers 2


As said in the link from comment, It's a bug in SQL Server Management Studio

SQL Server 2012 Management Studio spuriously forgets password. and SQL Server Management studio solution explorer doesn't remember SQL authentication password

Some alternate solutions may work for you.


I think that password is only kept during the session with BIDS.

  • Are you using SQL Authentication?
    – Jeff A
    Sep 22, 2014 at 15:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.