Solved

In SQL Server 2008 / Win 7, how can I get rid of old logins from the Connect prompt?

Posted on 2012-03-23
4
454 Views
Last Modified: 2012-08-14
I have a new login, but it keeps prompting me with the old login every time I want to connect.  Where does MS keep that data?  I've looked seemingly everywhere.
0
Comment
Question by:dtburdick
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 250 total points
ID: 37760226
0
 
LVL 3

Assisted Solution

by:fear-otaku
fear-otaku earned 250 total points
ID: 37761729
As stated in the link.  You need to delete the SqlStudio.bin file located at

%APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\

The only downside is that it will remove all of the remembered logins.  AFAIK there is no way to delete one or two of them.
0
 

Author Closing Comment

by:dtburdick
ID: 37767722
Worked like a charm!  Thanks!
0
 
LVL 30

Expert Comment

by:hnasr
ID: 37768106
Welcome!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Resume 5 46
Sql server Error message 3 16
Database Mail Profiles 1 22
Need quicker response from an Execption table 11 24
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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