SQL Server 2008 SSMS won't remember password

Question

SQL Server 2008 doesn't remember password inspite of checking the "Remember Password" checkbox.

I was suspecting a reboot would solve the problem. But, the issue persists.

Environment: Windows Vista Ultimate, SQL Server 2008

I have been hesitant to post this, as it seems so trivial and weird.

Answer 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

Answer 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!