SQL Server 2008 SSMS won't remember password

Solution 1:

There is a solution for this in SSMS 2012 that worked for me. Microsoft now provides a mechanism for removing a server from the list of remembered servers, and removing the offending server from the list will allow you to save the password the next time you connect to it:

  1. In the Connect to Database Engine dialog, drop down the server name list
  2. Use the arrow keys to select the server for which passwords aren't remembered
  3. Press the delete key on the keyboard.

https://web.archive.org/web/20160216044501/http://blogs.msdn.com/b/managingsql/archive/2011/07/13/deleting-old-server-names-from-quot-connect-to-server-quot-dialog-in-ssms.aspx

Solution 2:

If you register the server, and connect to it that way (just a quick double click), it works great!

  1. In SSMS -> View | Registered Servers
  2. Choose "Database Engine" (should be selected by default)
  3. Right click on "Local Server Groups" and choose "New Server Registration" (or create your own group first if you prefer)
  4. Enter all required details: Server address, username, password, tick "Remember password" box, Registered server name
  5. Click "OK" -- now you can always connect to this server from this "Registered Servers" tool window - it will not ask for a password again.

I got this from serverfault.com and it worked great!

Solution 3:

Does this bug report match what you're seeing?

EDIT (January 10, 2015): Ganesh points out in a comment that this link is now dead. This decade-old bug was closed as “Won’t Fix,” but it has been reposted/reopened here. (I put a screenshot of the cached page here, for anyone who’s interested.)