Share via

SSMS remembered connections limit?

Pino Carafa 121 Reputation points
2022-02-17T14:14:31.42+00:00

A lot of our clients are on Azure databases and each database has its own server and connection details. I can connect to such databases and I can ask SSMS to remember the connection details. All fine and dandy.

But it only seems to remember 24 different connections and their credentials. When I add the 25th, the last one shuffles off the end of the list into the great void.

Can this limit be increased? Sure I can keep a separate list of all the connections I might possibly need and get the details for anything that isn't in the list anymore from there, but why impose a limit in the first place? If I want it to remember the credentials for 1000 different connections, why couldn't it store them all? It's not 1980 anymore. The details for 1000 connections would take up next to no space.*

*I realised they're stored in the Credentials Manager, see additional comment below

175442-homer-simpson-quotes-04-720x540.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,035 questions
0 comments
Accepted answer
  1. Michael Taylor 49,686 Reputation points
    2022-02-17T16:58:13.643+00:00

    If you're referring to the recent list then it should be small.

    Can you use the Registered Servers view and add your servers (grouped if desired) instead? We have a bunch of DBs as well and I have separate registered servers grouped by my needs. The registered server has the credentials (if desired) and all the other connection info. The nice thing about it is you can copy the file it stores this in and put it on another machine (such as when you get a new machine) rather than having to rebuild everything.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2022-02-17T17:17:07.083+00:00

    The drop down list is only the last 25 items. You should be using "Registered Servers" to group and manage servers you regularly connect.

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

    1 person found this answer helpful.
  2. Pino Carafa 121 Reputation points
    2022-02-17T14:28:02.773+00:00

    Actually.... it's even worse than that. It does remember them all..... it just doesn't list them. Once you go over 24 it lists only the 24 most recently accessed. Now THAT is just daft. I go into my "Credentials Manager" and they're all there. What's the point of them being all there if I cannot access them from the UI?

    0 comments