SQL Server 2008 SSMS won't remember password
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:
- In the Connect to Database Engine dialog, drop down the server name list
- Use the arrow keys to select the server for which passwords aren't remembered
- 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
If you register the server, and connect to it that way (just a quick double click), it works great!
- In SSMS -> View | Registered Servers
- Choose "Database Engine" (should be selected by default)
- Right click on "Local Server Groups" and choose "New Server Registration" (or create your own group first if you prefer)
- Enter all required details: Server address, username, password, tick "Remember password" box, Registered server name
- 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!
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.)