SSMS doesn’t ship as a standalone installer anymore. Starting with SSMS 21 it installs through the Visual Studio Installer, and what you download is a small bootstrapper rather than the thing itself. If you’re looking for SSMS-Setup-ENU.exe because that’s what you downloaded last time, it’s gone, and I wrote the original version of this post back when that file was still the answer.
SQL Server Management Studio (SSMS) is Microsoft’s official tool for interacting with Microsoft SQL Server. SSMS is an essential for Database Administrators that need to both read/write T-SQL and review execution plans. Developers often utilize SSMS, but there are some plugins for Visual Studio Code, such as this one, but it doesn’t offer the same experience that SSMS does. I personally prefer SSMS over Visual Studio Code, but I do more DBA work than development work.
Downloading SSMS
The latest version of SSMS is always available from Microsoft’s official website. To ensure you’re getting the most up-to-date release, visit the SQL Server Management Studio install page.
The download gives you vs_SSMS.exe. Microsoft’s page calls it “a stub installer, or bootstrapper”, and its job is to install the Visual Studio Installer, which then installs SSMS. The page is direct that “there’s no standalone MSI”, so this is the path now whether you wanted the Visual Studio Installer on your machine or not.
Installing SSMS
Once the download completes, navigate to the location where the installer was saved. Double-click vs_SSMS.exe to start. You need administrator permissions on the machine, and if you get a User Account Control prompt, choose Yes.
The Visual Studio Installer opens and hands you a few optional choices:
- Workloads: Groups of features, like the Hybrid and Migration workload for upgrade assessment and data migration. You can skip all of them and still get SSMS.
- Individual components: The same thing at a finer grain, if you’d rather pick pieces than a bundle.
- Installation location: Worth a look here, because Microsoft’s page says you can only choose a different drive for SSMS and the download cache “when you first install SSMS”. 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
Once the installation is finished, you’ll see a message confirming the successful installation of SSMS. At this point, you can launch SSMS from the Start Menu or by searching for it on your system.
No reboot is typically required, but if you run into any issues or see a prompt to restart, it’s a good idea to go ahead and do so.
Next Steps
Now that you have SSMS installed, you can start managing your SQL Server instances, running queries, or configuring settings. Keep in mind that this guide is focused purely on installation. For additional tasks such as connecting to remote servers, database configuration, or security best practices, be sure to consult further resources.
The version numbers are the part I keep having to look up. The install page says “SSMS 22 works with SQL Server 2014 (12.x) and later versions,” and that you “can install SQL Server Management Studio 22 side-by-side with other versions,” so having 20 and 22 on the same machine is fine. If you’re managing something older than 2014, Microsoft’s release history page has the older builds. I’ve got more than one version installed on this laptop and I couldn’t tell you why anymore.
The current release is 22.9.0 as of August 2026, and only the latest one gets fixed. The support policy says “the SSMS team doesn’t actively back-port fixes to an earlier release,” so if something’s broken on an older install, upgrading comes before reporting it.