Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Bad login entry on Connect to Server

Author  Topic 

jack42
Starting Member

1 Post

Posted - 2010-01-18 : 13:38:59
I apologize in advance if this is not the right forum.

How It Came About: I tried to connect to a database in Management Studio with a particular Login (using SQL Server Authentication). The password I was given was incorrect, and it turned out I didn't need that particular login anyway (different server was needed).

The Problem as I See It: every time I attempt to login to that server (the second most-used one in my work), that bad login entry is the default value (rather than the last one I used). Further, the actual login I use for this server now says the saved password is invalid when I connect with it, and even though I have "remember password" checked, it will not save the correct password I then type in. I suspect it is related to the invalid login entry since I never had the problem before I attempted to use the invalid login entry (and the stored password worked fine).

Finally, The Question: how do I get rid of this invalid entry from the drop down?

Attempted fixes: I've searched the registry for the invalid login entry. I've tried to delete the entry from the login dropdown. I have searched for anything related to this that I can think of. If a solution exists "out there", I don't know how to phrase my search any differently to find it.

Any help or direction on this would be greatly appreciated and lead to my undying adulation of your skills. oh, and much less frustration for me.

Jack

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-18 : 17:26:32
I found this and I think it could help:
http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -