SQL Server 2012 Management Studio spuriously forgets password, despite being set to remember it. - by Jaans

Status : 


Sign in
to vote
ID 779351 Comments
Status Closed Workarounds
Type Bug Repros 7
Opened 2/15/2013 9:00:40 PM
Access Restriction Public


When using SQL Server 2012 Management Studio, I'm presented with a dialog to provide connection details and credentials.

This dialog has a checkbox to "Remember Password". This then works for a period of time, but
every so often, a bug with this checkbox happens where the checkbox clears itself and the password removed, forcing the user to obtain and provide the login credentials again.

This has been happening since SQL Server 2008 and it's becoming infuriating to no end.

Please fix it.
Sign in to post a comment.
Posted by kbutterly on 4/15/2016 at 6:30 AM
I will download the release and post here if the issue continues
Posted by Ayo Olubeko on 4/14/2016 at 12:55 PM
Hi kbutterly, are you able to reproduce this issue using the SSMS preview releases: https://msdn.microsoft.com/en-us/library/mt238290.aspx
Posted by kbutterly on 4/14/2016 at 6:31 AM
This happens to me all the time. I just had it happen. The next time it happens I will follow the directions below for grabbing the bin file and the dump file. I would mention that I have a LOT of connections, more than 15 probably.
Posted by R2JD2 on 9/2/2015 at 12:39 PM
Yes, reproducible on my machine. This is the reason I looked up the problem, because it continues to happen.
Posted by RickPaul on 1/6/2015 at 1:23 PM
Microsoft, You aren't trying hard enough to reproduce it.
Posted by Keith Beckman on 10/15/2014 at 7:05 AM
I've reopened this as https://connect.microsoft.com/SQLServer/feedback/details/1001864 with repro instructions.
Posted by Microsoft on 7/29/2013 at 5:03 PM
Hello Jaans. Thank you for reporting this problem to us. However, we have been unable to reproduce the behavior locally. We are under the impression the issue is caused by factors local to your machine, and will not be able to divine the root cause of the problem without anything short of an extended investigation of your computer directly. We will be closing the issue as a “no repro.” If you can provide more information to help us reproduce the issue, please get back in touch with us and we will assist you.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Microsoft on 3/19/2013 at 8:49 AM
Thank you, Jaans. We'll have a look and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Jaans on 3/18/2013 at 8:30 PM
Thanks Walter

It happened again this morning and I followed you instructions to include the SqlStudio.bin file and the process dump of SQL Management Studio.

The compressed ZIP file is 136MB in size, which exceeds the Connect 50MB limit. I have placed the file on my SkyDrive for you to download. If that doesn't work for you, please advise.

Here is the link: http://sdrv.ms/XVFQHC

Hope that helps
Posted by Microsoft on 3/13/2013 at 12:57 PM
Hello, Jaans. We'll be needing some more information to continue our investigation. Please take the following steps to provide it to us next time you encounter this issue. First, do not close the connection dialog window when it opens. Go to C:\Users\<accountname>\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0, and copy the SqlStudio.bin file to your desktop. Next, open task manager and find the SSMS process under the "Processes" tab. Right click it, and select “Create Dump File” (If prompted, choose "full"). Copy this dump file to your desktop as well, and create a compressed file containing both the dump and the .bin file from earlier. Once you have this compressed file, please get back to us for instructions on how to transfer the file. If it's small enough (note recommended file size limits), you should be able to simply upload it through Connect instead. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Jaans on 3/7/2013 at 5:15 PM
Hi Charles. When it happens it only clears the saved password - the other fields are still filled in.
Posted by Microsoft on 3/7/2013 at 1:09 PM
Hello Jaans,

When the password is cleared does it also clear other saved information (such as username)?

Charles Gagnon (chgagnon@microsoft.com)
Posted by Microsoft on 3/7/2013 at 10:08 AM
Hello Jaans. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)