Solved

SSMS: how to remove someone from the Connection List and Remember Password

Posted on 2014-03-25
11
400 Views
Last Modified: 2014-04-01
In the SSMS 2008 "Connect to Server" list I had setup a new user on a database and tested it. Now that user is popping up by default every time I open SSMS and when I select my connection in the drop down list, it now requires a password and won't auto-log me in.

How do I get rid of that person in my list and get it to save my password? I keep selecting the "Remember Password" check box and it just ignores it and doesn't remember anything.

:(

thanks!
0
Comment
Question by:BobCSD
  • 6
  • 4
11 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
It is not possible to just "get rid of that person in my list " but to clear/reset the entire list:

http://www.mssqltips.com/sqlservertip/2319/steps-to-clear-the-server-list-in-sql-server-management-studio/
0
 
LVL 1

Author Comment

by:BobCSD
Comment Utility
How about getting it to remember my password? Is that possible? thanks!
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
Try executing SSMS as Administrator.
0
 
LVL 1

Author Comment

by:BobCSD
Comment Utility
>>Try executing SSMS as Administrator.

No. That didn't work either. :(

executed as administrator. put in password. checked the box. connected.
closed out. executed as administrator again. submitted. login failed.
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
Are you a Local Administrator on the computer where you run the SSMS? Isn't that a terminal server or some other RDP session where network policies may be in place to not allow you save it? (that's how is set up in my PROD environment and it sucks but...more secure for sure - I can't save passwords in SSMS)
What version SSMS and what service pack?
SSMS needs SQL Service pack to be applied as well (if exists) as there are bugs in management console as well.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 1

Author Comment

by:BobCSD
Comment Utility
My role on this computer is admin. It's a local computer opening SSMS to then connect remotely.

Here are the details:
Microsoft SQL Server Management Studio                                    10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools                                    2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514 (win7sp1_rtm.101119-1850)
Microsoft MSXML                                    3.0 4.0 6.0
Microsoft Internet Explorer                                    9.11.9600.16521
Microsoft .NET Framework                                    2.0.50727.5477
Operating System                                    6.1.7601
0
 
LVL 1

Author Comment

by:BobCSD
Comment Utility
After I deleted that file (or renamed it), it now saves the password fine. thanks!
0
 
LVL 1

Author Closing Comment

by:BobCSD
Comment Utility
thanks!
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
"Microsoft SQL Server Management Studio                                    10.0.1600.22 ((SQL_PreRelease).080709-1414 )"


Can you update SSMS Tool with the latest (or at least the same) service pack your SQL is running because (yes) the Tolls and any other components that don't have SP applied needs it. Try delete again the old bin tied to SSMS on that computer then login after that and save your password.
0
 
LVL 1

Author Comment

by:BobCSD
Comment Utility
OOPS! crossed in the mail. We're all set! removing the .bin file and starting fresh fixed the password save issue.
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
I would still advise you to update SSMS with the latest or at least the same SQL Server SP you have on your SQL Server Engine and not use the "SQL_PreRelease.080709-1414" - 10.0.1600.22  - version.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now