Most recent usable version of SSMS

Mark P 20 Reputation points
2025-12-01T10:18:49.0233333+00:00

We're currently trying to use SSMS 21, however it crashes too often to be usable. In particular any network change in the background will cause it to lock up, for example disconnection and reconnection to a VPN will make SSMS crash.

We have no need of AI or Azure specific features.

I recall that we upgraded to this because the diagramming feature in SSMS was broken for years. Prior to that the last good version worked perfectly. From memory I think that's SSMS 16, can anyone confirm? Thanks.

SQL Server | Other
{count} votes

Answer accepted by question author
  1. Yitzhak Khabinsky 27,091 Reputation points
    2025-12-01T12:28:51.2433333+00:00

    Hi @Mark P,

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Q&A Assist
    2025-12-01T10:18:57.53+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The most recent version of SQL Server Management Studio (SSMS) is 21. It has introduced various features and enhancements but has also been reported to have stability issues, including crashes related to network changes. If you are experiencing frequent crashes with SSMS 21, you might want to consider using an earlier version that is known to be more stable for your needs.

    SSMS 16 is indeed an older version that some users have found to be more reliable, especially for basic functionalities without the newer features that may not be necessary for your use case. However, it's important to note that SSMS 16 is not the latest version and may lack support for newer SQL Server features.

    If you decide to downgrade, ensure that you back up your settings and configurations to avoid any loss of work.


    References:

    0 comments No comments

  2. Mark P 20 Reputation points
    2025-12-01T12:34:27.66+00:00

    Thank you. 17.9 seems to be the last known good version. Download link is here, for anyone who wants it:

    https://learn.microsoft.com/en-us/ssms/release-history

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.