This question already has an answer here:

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?

marked as duplicate by Mark Storey-Smith sql-server Oct 24 '14 at 19:07

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


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 '14 at 15:48

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