SQL Authentication

Marie A 20 Reputation points
2024-04-18T15:21:50.3266667+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,742 questions
Accepted answer
  1. Alex Burlachenko 810 Reputation points
    2024-04-18T15:25:01.1966667+00:00

    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.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marie A 20 Reputation points
    2024-04-18T15:37:45.53+00:00

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

  2. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-19T03:07:25.6066667+00:00

    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

  3. Olaf Helper 40,896 Reputation points
    2024-04-19T06:25:11.0633333+00:00

    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

    0 comments