SQL Authentication

Question

when logging into sql manangement studio via windows authentication, i used to be able to drop down to select the server i wanted to log into. Now, it only saves the last one i logged into, with no option to see the others i logged into previously. It is not efficient to keep tying the server name as there are about 8-10 i log into in a daily basis.

Answer 1

It sounds like the setting for the number of recently used servers in SSMS might have been changed. You can adjust this setting to increase the number of servers that appear in your history.

Open SQL Server Management Studio.

1. Go to Tools > Options > General.
2. Look for the option “Display files in recently used list”.
3. Change the value to the desired number (up to 24).
4. Click OK to save changes.

Answer 2

used to be able to drop down to select the server i wanted to log into

You mean the MRU = "Most recently used" list? Nothing reliable, stored somewhere in registery.

Better use SSM "Registered Server" to manage a list of server you want to connect to:

https://learn.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-ver16

Answer 3

Hi @Marie A,

Thanks for your information.

This article describes how to save the connection information for servers that you access frequently, by registering the server in the Registered Servers component of SSMS in SQL Server.

Hope this can help you well.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 4

didn't work... still asking me to type in.