SQL Server Management studio solution explorer doesn't remember SQL authentication password - by BruceScott

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 342763 Comments
Status Closed Workarounds
Type Bug Repros 21
Opened 5/8/2008 10:25:01 AM
Access Restriction Public


Bug with the Remember Password checkbox when connecting to a SQL 2005 server using SQL authentication

Sign in to post a comment.
Posted by Dean_Jackson on 7/28/2016 at 1:49 PM
2016...another year gone by and the problem is still there. I'm using the latest SSMS as of 7/28/2016 (version 13.0.15600.2) on a fresh install of Windows 10 (also tried fresh install of Windows 8.1), and the problem is still there.

Microsoft, aren't you going to say something?
Posted by RickPaul on 1/14/2015 at 2:09 AM
2015 and this terrible bug has still not been fixed.
Posted by Keith Beckman on 10/15/2014 at 7:07 AM
I've reopened this at https://connect.microsoft.com/SQLServer/feedback/details/1001864
Posted by Adam Christie on 6/12/2014 at 5:11 AM
This is one of the stupidest bugs ever. It is infuriating to encounter and I really really hope that you reconsider the "won't fix" status - or at least present the reasons why not!

Also: workaround not valid for SSMS 2012.

Posted by q_kev on 5/16/2014 at 7:59 AM
Thanks to JackZito for posting that workaround! I was going crazy with this. I too cannot believe this was not addressed and resolved. Seems an EXTREMELY simple fix from a programming perspective.
Posted by Hypoxide on 12/5/2013 at 7:03 AM
This bug is absolutely obnoxious! Does Microsoft administrate their own databases with a different product? How could this go unfixed for so many years? The development team can't take 20 minutes to fix this?
Posted by Michael K Campbell on 9/6/2013 at 3:09 PM
Love that this bug still exists with SSMS 2012.

Guess they were serious when they said they wouldn't fix this.
Posted by Jonny Weiss on 8/16/2013 at 10:20 AM
"Won't Fix" is an absolutely absurd response to a bug this annoying
Posted by Arkaine55 on 1/21/2013 at 11:35 AM
This issue is still present in SSMS 2008 R2. This issue will happen occasionally for some server profiles and not others. It will happen reliably for any server profile that has multiple logins, it seems to have an additional case where the password looks like it was remembered but will be unable to login without retyping the password. It seems to become confused over which password goes with which login. Even if one login has a saved password and other logins don't.

I agree with Keith Beckman, "Won't fix" is an unreasonable answer... we should at least get the canned response: "Unable to reproduce bug" or something. Having the passwords stored improperly and/or mismatching to logins seems like a possible security issue.
Posted by Keith Beckman on 8/29/2012 at 11:05 AM
This issue is still present in the current release. Also, it shouldn't've been closed as wontfix without a reasonable explanation.
Posted by kbbpll on 1/12/2012 at 1:39 PM
SQL 2008 R2 - still needs a "Remember password, goddamnit!" checkbox, which overrides the other checkbox with a "really remember it this time, no, REALLY" command.
Posted by JackZito on 4/12/2011 at 7:26 AM
Posted workaround. Worked for me.
Posted by gf1 on 11/11/2010 at 4:03 PM
I have also had a lot of frustration with this because I use a randomly generated password with special characters in it so I have to cut and paste it from my password tool everytime I login to SQL Server Management Studio.

Posted by rathor on 4/22/2010 at 5:57 AM
Won't fix ?!?
Why? It wasn't fixed in 2008 either.

This may seem trivial on the surface, but for those managing many servers, this is a HUGE frustration and time-waster. After five years, new version, service packs, and hundreds of hotfixes, why isn't this resolved? This is a database product... it should be able to reliably, consistently retain and utilize such a tiny amount of data. Third party products do it.
Posted by mclabman on 4/21/2010 at 6:35 AM
It happens on some connections, but on other password remembered. But if password forget no way to force remember it.
Posted by Davz on 2/17/2010 at 1:48 PM
Seriously? "Won't fix"?
That's just crazy.
Everyone I know has experienced this.

It's as if Windows randomly reset all your display settings to default. Yes, it's THAT big a problem.
Posted by EverythingIsTakenGiveMeSomeFreakinHelpWithNames on 2/10/2010 at 2:46 PM
Seriously, did you guys even QA this product? Management Studio 2005 was super sporadic in remembering the password. Now this one will work as long as you remember to check it the first time. If you forget though, it will never remember it. How hard can this possibly be to get right?
Posted by Tryout User on 1/25/2010 at 12:11 AM
So, when this stupidest bug will be fixed? I'm fed up with it!

Have you guys ever try to administrate servers with passwords more complex than just a "qwerty" string? This particular bug makes it very annoying.
Posted by Microsoft on 5/9/2008 at 1:59 PM
Bruce -

Thanks so much for the very detailed repro steps - that really helps! We're taking a look at this entire area for the next release (after SQL Server 2008) to be a better experience.

Thanks for submitting -

Buck Woody, SQL Server Program Manager