Home Dashboard Directory Help
Search

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


Status: 

Closed


10
1
Sign in
to vote
Type: Bug
ID: 779351
Opened: 2/15/2013 9:00:40 PM
Access Restriction: Public
0
Workaround(s)
view
3
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
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)?

Thanks,
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)
Sign in to post a workaround.