Blog Post

SQL Server Blog
3 MIN READ

SQL Server Management Studio (SSMS) 21 is now generally available (GA)

erinstellato's avatar
erinstellato
Icon for Microsoft rankMicrosoft
May 19, 2025

SQL Server Management Studio (SSMS) 21 GA is now available

Today we are thrilled to announce the general availability release of SQL Server Management Studio (SSMS) 21! After months of hard work, collaboration, and feedback-driven development, SSMS 21 is here – rebuilt from the ground up with powerful new features and enhanced performance. This was a monumental effort from the team with a lot of learnings along the way; we can’t wait to hear what you think of SSMS 21.

Download SSMS 21.0.0

There are many exciting improvements packed into this latest version of SSMS. A Visual Studio-based solution with 64-bit support, SSMS 21 is the recommended release for SQL Server 2025 Preview, includes Copilot in SSMS (Preview), and has initial dark theme support.

Highlights

As always, you can read the entire list of new functionality and bug fixes in our release notes, but a few highlights include:

  • Installation and automatic updates via the Visual Studio Installer
  • Git integration available via the Code tools Workload
  • Smaller installation footprint and customizable installation via Workloads and Individual Components
  • A new, Modern connection dialog experience (Preview)
  • New options for customizing your SSMS experience (vertical tabs, tab coloring by project or file type, minimum and maximum tab width, font and background color for results grid cells containing NULL values, and more)
  • Always Encrypted Assessment available via the Always Encrypted Wizard
  • Migration assistance via the Hybrid and Migration Workload

Install SQL Server Management Studio 21

One notable change from previous SSMS releases is the installation mechanism for SSMS 21, which is managed using the Visual Studio Installer. To learn more about system requirements and installation instructions, see Install SQL Server Management Studio (SSMS).

If you have the SSMS 21 preview release installed, installing SSMS 21 GA will not replace it. The GA version is delivered via our Release channel. Please note that we will no longer be servicing the SSMS 21 Preview, including security fixes. Any updates to SSMS 21 will land in the Release channel, and you can install earlier versions of SSMS (e.g. 20.x) side-by-side.

SSIS and Maintenance Plans

We made the difficult decision to hold back SQL Server Integration Services (SSIS) support for this release. This includes the import/export functionality and Maintenance Plans. In the spirit of full transparency, during the final weeks of testing, we recognized that SSIS needed additional time to ensure the quality and stability our users expect, so we made the decision to temporarily hold it back while we continue to enhance the experience. Our primary focus for SSMS 21 was to move to Visual Studio 2022, provide initial support for SQL Server 2025 Preview, and support the Copilot in SSMS Preview. Our team is actively working to bring these features back in an upcoming release. For now, if you rely on SSIS we recommend using SSMS 20, which you can install side-by-side with SSMS 21 GA.

Support Policy

With the release of SSMS 21, previous versions of SSMS will no longer receive support, as per our support policy. We strongly recommend upgrading to SSMS 21 to access the latest features, security updates, and critical fixes.

Let us know what you think

We hope you’re as excited about SSMS 21 GA as we are! As always, we’d love to hear from you with any feedback or feature suggestions (using our new and improved Developer Community feedback site, which you can read more about here). We review posts and comments regularly, and your feedback helps shape the future of SSMS.

Thanks for joining us on this journey and for being a part of the SSMS community ❤️

 

 

Updated May 19, 2025
Version 3.0

20 Comments

  • ivan-eivf's avatar
    ivan-eivf
    Copper Contributor

    Nice, good job, I hope we can see github copilot integration soon, if VS have it why no SSMS

  • DevC's avatar
    DevC
    Copper Contributor

    Comical the focus was on supporting preview features, rather than a feature people rely on.  Then telling us to use an unsupported version while you guys figure it out.  Well done.

    • erinstellato's avatar
      erinstellato
      Icon for Microsoft rankMicrosoft

      DevC​  While it may not be apparent to you, we have been working on supporting preview and legacy features since SSMS 21 was released in preview. Additionally, when we state that SSMS 20 is no longer supported, it means that if you find a problem in SSMS 20 then we will fix in the current release (SSMS 21) and not back port it to a SSMS 20 release.  We don't block customers from using SSMS 20 (or earlier releases) and we recognize that many customers (and companies) cannot immediately update to the newest release. Have a great day.

      • DevC's avatar
        DevC
        Copper Contributor

        I understand what no longer supported means.  While it may not be apparent to you, decisions like this are why Microsoft products are gaining the reputation they currently have.

  • Thom_A's avatar
    Thom_A
    Copper Contributor

    I must admit, it's really frustrating to see that the feature you heavily use, SSIS, isn't supported in SSMS 21, but in the same breath be told that SSMS 20 is no longer supported; in one swoop I'm now only able to use an unsupported release.

    In my mind, if the SSMS 21 release is going to be incomplete, then support for the prior release, SSMS 20, shouldn't be revoked until the upgrade path is complete.

    • erinstellato's avatar
      erinstellato
      Icon for Microsoft rankMicrosoft

      Thom_A​ Thanks for your feedback.  For clarification, when we state that SSMS 20 is no longer supported, it means that if you find a problem in SSMS 20 then we will fix in the current release (SSMS 21) and not back port it to a SSMS 20 release.  We don't block customers from using SSMS 20 (or earlier releases) and we recognize that many customers (and companies) cannot immediately update to the newest release.  

  • SQLBIDEV's avatar
    SQLBIDEV
    Copper Contributor

    Well done, team!  But what are we supposed to gripe about now that we finally have legit dark mode?  🤣

  • Peđa's avatar
    Peđa
    Copper Contributor

    Looking nice! 

    Is it possible to connect to analysis services? 

  • SysGreg's avatar
    SysGreg
    Copper Contributor

    Still not possible to open query in design mode if it contains IIF.
    "The SQL Server IIF function is a logical function introduced in SQL Server 2012 (Transact-SQL)"
    13 years since introduction - seriously? Is it so hard?

  • EduardoSR's avatar
    EduardoSR
    Copper Contributor

    The interface looks very nice

    How can you install a local engine to be used with SSMS 21?
    Or how do you get to your old local engine?
    Maybe a lame question, but today is not the best day.

    • erinstellato's avatar
      erinstellato
      Icon for Microsoft rankMicrosoft

      EduardoSR​ If you are looking to connect to a local instance of SQL Server, you can either install Express edition or use containers.  There is Learn documentation for both options.  When you say "SSMS 21 couldn't get preferences from my old SSMS 18", I don't know if that is because of an error, or something else.  If there is an issue, please log it on the feedback site. Thanks.

    • EduardoSR's avatar
      EduardoSR
      Copper Contributor

      It is about the modern / classic connection menu.

      New menu does not have the preview, as opposed to classic menu, which shows all the available instances.

    • EduardoSR's avatar
      EduardoSR
      Copper Contributor

      By the way, SSMS21 couldn't get preferences from my old SSMS18