SQL Server Management Studio (SSMS) is Microsoft’s official tool for working with SQL Server. For database administrators who need to read and write T-SQL and review execution plans, it’s close to essential. Developers use SSMS too, and there are other options like the SQL Server extension for Visual Studio Code, but it doesn’t offer the same experience. I personally prefer SSMS, though I do more DBA work than development work.
When I first wrote this post, SSMS came as a single installer, SSMS-Setup-ENU.exe. That changed with SSMS 21. It now installs through the Visual Studio Installer, and what you download is a small bootstrapper rather than SSMS itself. If you’re looking for SSMS-Setup-ENU.exe because that’s what you used last time, it’s no longer how the current version installs.
Downloading SSMS
The latest release is linked from Microsoft’s SQL Server Management Studio install page.
The download is vs_SSMS.exe. Microsoft’s page calls it “a stub installer, or bootstrapper.” It installs the Visual Studio Installer, which then installs SSMS, and the page says plainly that “there’s no standalone MSI.”
Installing SSMS
Once the download completes, go to where it was saved and double-click vs_SSMS.exe. You need administrator permissions on the machine, and if you get a User Account Control prompt, choose Yes.
The Visual Studio Installer opens with a few optional choices:
- Workloads: Groups of extra features. The page gives the Hybrid and Migration workload as an example, for assessing upgrade readiness and migrating data. None of them are required for SSMS itself.
- Individual components: The same idea at a finer grain, if you’d rather pick individual pieces than a whole workload.
- Installation location: Worth deciding now. Microsoft’s page says you can choose a different drive for SSMS and the download cache “only when you first install SSMS,” and changing it later means uninstalling and reinstalling.
Then click Install. It can take anywhere from a few minutes to half an hour, depending on your system.
Post-Installation
When the installation finishes, you can open SSMS from the Start Menu or by searching for it. A reboot usually isn’t required, but if you see a prompt to restart or run into any issues, it’s a good idea to go ahead and do it.
Versions
SSMS 22 works with SQL Server 2014 and later, according to the install page, and it can be installed side by side with other versions of SSMS. If you need to manage something older than SQL Server 2014, Microsoft’s release history page has links to earlier versions.
As of September 2026, the current release is 22.10.1. Only the latest release gets fixes. The support policy says “the SSMS team doesn’t actively back-port fixes to an earlier release,” so if something is broken on an older install, the first step is to update and see whether it’s still broken.
This guide only covers installation. Connecting to remote servers, configuring databases, and security are all worth reading up on separately. If you run into issues along the way, feel free to leave a comment.