Search

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

Active

3
1
Sign in
 to vote
Type: Bug
ID: 779351
Opened: 2/15/2013 9:00:40 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows 7 Enterprise

Operating System Language

English

Steps to Reproduce

Refer to the description text

Actual Results

Refer to the description text

Expected Results

If the "Remember Password" checkbox is set, then is should remember the password always, until the user clears it.

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement