How to quickly delete the options in the drop-down list box for the logon name of SQL Server

How to quickly delete the options in the drop-down list box for the logon name of SQL Server

Problem:

I previously created a login name, such as kpi, and deleted it in "security-Logon Name". However, the logon name kpi is always displayed in the drop-down box of each logon name, how can I delete it?

Solution:

1). SQL Server 2008 R2 and SQL Server 2008

Close the database logon window and delete it:

The SqlStudio. binfile under % AppData % \ Microsoft SQL Server \ 100 \ Tools \ Shell. (Paste the path directly in the resource manager) and then open SSMS and you will not be able to see it.

2). SQL Server 2005

Close the database logon window and delete it:

The mru. dat file under % AppData % \ Microsoft SQL Server \ 90 \ Tools \ Shell. (Paste the path directly in the resource manager) and then open SSMS and you will not be able to see it.

3). SQL Server 2000

First close the database logon window, and then clear:

HKEY_CURRENT_USER \ Software \ Microsoft SQL Server \ 80 \ Tools \ Client \ PrefServers \ Corresponding content. Open SSMS and you will not be able to see it.

For versions 2) and 3), I have never put them into practice. I will make a note for the time being.

The above section describes how to quickly delete the options in the drop-down list box of the logon name for SQL Server logon. I hope this will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!