MedhaCloud
Link copied to clipboard!
Managed IT Support

SQL Server Management Studio: SSMS Download, All Versions

Sreenivasa Reddy G
Sreenivasa Reddy G
Founder & CEO
Aug 2, 20269 min read
24
SQL Server Management Studio: SSMS Download, All Versions

SQL Server Management Studio (SSMS) is the tool our SQL Server support team uses daily to administer client instances. This page lists the current download, every prior version still available from Microsoft, system requirements, and install steps — all links point to official Microsoft sources.

What SSMS is

SQL Server Management Studio is Microsoft's free integrated environment for managing SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure Synapse Analytics, and SQL database in Microsoft Fabric. It combines a query editor, Object Explorer for browsing server objects, graphical tools for backup/restore and security configuration, SQL Server Agent job management, and execution-plan analysis in one Windows application. It runs only on Windows and connects to both on-premises and cloud SQL instances. Documentation lives at learn.microsoft.com/ssms.

Download SSMS — current version is 22

As of August 2026, the current release is SSMS 22 (22.8.x on the Release channel). SSMS 21 was the current version until late 2025 and still receives no support outside Microsoft's latest-release policy — if you searched for "ssms 21," install 22 unless you have a specific reason not to.

Starting with SSMS 21, installation goes through the Visual Studio Installer. The bootstrapper installs the Visual Studio Installer first, which then installs SSMS. There is no standalone MSI for SSMS 21 or 22. Versions 20 and earlier used a conventional standalone installer (SSMS-Setup-ENU.exe).

Only download SSMS from microsoft.com or learn.microsoft.com. Third-party download portals repackage installers, sometimes with adware. Every link on this page resolves to a Microsoft domain.

All SSMS versions

Microsoft keeps installers for older versions on the SSMS release history page. Latest builds per major version:

VersionLatest buildReleasedNotable changesHighest SQL Server supported
SSMS 2222.8.x (evergreen)CurrentVisual Studio 2022-based shell, workload-based install via Visual Studio Installer, Arm64 Windows support, Copilot integrationSQL Server 2025
SSMS 2121.6.17Oct 14, 2025 (final build)First 64-bit SSMS, moved to Visual Studio Installer, Preview/Release channels, dark themeSQL Server 2025
SSMS 2020.2.37 (20.2.1)Apr 8, 2025 (final build)Mandatory connection encryption by default, certificate trust changes (Strict encryption support)SQL Server 2022
SSMS 1919.3.4 (19.3)Jan 10, 2024 (final build)SQL Server 2022 support, Azure AD (Entra) authentication improvementsSQL Server 2022
SSMS 1818.12.1Jun 21, 2022 (final build)Last version supporting Windows Server 2016-era platforms; last with a fully standalone installer lineageSQL Server 2019

Both SSMS 22 and 21 connect to SQL Server 2014 and later, per the system requirements page. For SQL Server 2012 or older, use SSMS 18.x. One exception: SSMS 17 and later cannot connect to the legacy SSIS service of older SQL versions — use the SSMS version matching the SQL Server version for legacy Integration Services work. Versions can be installed side by side (22 alongside 21, 20, 19, 18). For which SQL engine versions are still supported, see our SQL Server versions guide; for the database engine itself, see SQL Server download.

System requirements (SSMS 22)

  • OS (64-bit only): Windows 11 (all mainstream editions, including Arm64), Windows Server 2019, 2022, or 2025. 32-bit and Arm32 systems are not supported. Windows 10 is not listed as supported for SSMS 22.
  • CPU: x64 processor; quad-core or better recommended.
  • RAM: 4 GB minimum; Microsoft recommends 16 GB for typical professional use.
  • Disk: 4 GB minimum; typical installations use 20–50 GB depending on selected workloads. SSD recommended.
  • Display: 1366×768 minimum at 100% scaling; 1920×1080 or higher works best.
  • .NET: .NET Framework 4.7.2 or later to install; 4.8 to run (setup installs it if missing).
  • Permissions: administrator rights are required to install or update.

Full details: SSMS system requirements.

Install steps

  1. Download vs_SSMS.exe from the official link above.
  2. Run it as administrator. Accept the license terms; the Visual Studio Installer opens.
  3. Select workloads if needed (for example, Hybrid and Migration for migration assessment tooling) or leave the default selection.
  4. Select Install. The installer downloads and installs components; a restart is sometimes required.
  5. Launch SSMS from the Start menu and connect to your instance (server name, authentication method).

Silent install

SSMS 21/22 use Visual Studio Installer command-line parameters. A quiet install from the bootstrapper:

vs_SSMS.exe --quiet --norestart

Use --passive instead of --quiet to show progress without prompts. For offline or managed deployment, Microsoft documents a layout-based process at Create an offline installation of SSMS, and full parameter reference at command-line parameters. The older SSMS 18/19/20 standalone installer used a different syntax: SSMS-Setup-ENU.exe /Install /Quiet /Norestart.

SSMS vs Azure Data Studio

Azure Data Studio was Microsoft's cross-platform (Windows/macOS/Linux) SQL editor. It is retired as of February 28, 2026 and no longer receives updates or security fixes. Microsoft's stated replacement is Visual Studio Code with the MSSQL extension for development work, while SSMS remains the supported tool for SQL Server Agent, full administration, and Windows-based DBA tasks. If your team still runs Azure Data Studio, plan the move: queries, scripts, and database projects open in VS Code without conversion.

Common install issues

  • Install hangs or fails partway: usually pending Windows updates or a pending restart. Apply updates, restart, retry. Microsoft's troubleshooting guide covers log collection.
  • Corrupted install blocks reinstall: use the InstallCleanup.exe tool documented on the release history page, then reinstall.
  • SSMS 22 won't install on Windows 10: expected — Windows 10 is not a supported OS for SSMS 22. Use a Windows 11 or Server 2019+ machine, or install SSMS 20.2.1.
  • Offline environments: the Visual C++ v14 Redistributable must be present before an offline SSMS install.
  • Connection errors after upgrading from 19 to 20+: SSMS 20 changed connection encryption defaults. If the server uses a self-signed certificate, check Trust Server Certificate or deploy a trusted certificate.

If SSMS installs fine but the instance behind it is the problem — blocking, slow queries, failed Agent jobs — that is DBA work, not tooling work. Our managed SQL Server services cover monitoring, performance tuning, and backup verification on a monthly basis.

FAQ

Is SSMS free?

Yes. SSMS is free to download and use, with no license cost, regardless of which SQL Server edition it connects to. The only cost is the SQL Server licensing on the server side.

Does SSMS 21 or 22 work with SQL Server 2016?

Yes. Both support SQL Server 2014 and later, which includes 2016, 2017, 2019, 2022, and 2025. The exception is managing the legacy SSIS service on old instances, which requires a version-matched SSMS.

Can I install two SSMS versions on one machine?

Yes. SSMS 22 installs side by side with 21, 20, 19, 18, 17, and 16 per Microsoft's system requirements documentation.

Is there an SSMS for Mac or Linux?

No. SSMS is Windows-only. On macOS or Linux, use Visual Studio Code with the MSSQL extension (the successor to the retired Azure Data Studio), or run SSMS in a Windows VM.

Which SSMS version do I need for SQL Server 2012 or 2008 R2?

SSMS 18.12.1 is the practical choice — it connects to older engines that 21/22 no longer list as supported. Those engine versions are themselves out of extended support; if you are still running them, that is a bigger risk than the tooling. Our SQL Server consulting team handles upgrades from end-of-life versions — see SQL Server consulting.

Running SQL Server without a DBA? Medha Cloud provides 24/7 Microsoft SQL Server support — monitoring, tuning, backups, and version upgrades, billed monthly.

Protect your organization with expert healthcare IT support designed for HIPAA compliance.

Managed IT for Healthcare

Topics

ssmssql-serverssms-download
Sreenivasa Reddy G
Written by

Sreenivasa Reddy G

Founder & CEO15+ years

Sreenivasa Reddy is the Founder and CEO of Medha Cloud, recognized as "Startup of the Year 2024" by The CEO Magazine. With over 15 years of experience in cloud infrastructure and IT services, he leads the company's vision to deliver enterprise-grade cloud solutions to businesses worldwide.

Managed IT SupportCloud InfrastructureDigital Transformation
Follow on LinkedIn

Need Expert Help?

Our certified cloud and IT engineers are ready to tackle your toughest challenges — from migrations to managed services.