How to Install Microsoft SQL Server Management Studio (SSMS)

Here’s how to install SQL Server Management Studio, the free app you use to run SQL queries. Behind the scenes it uses Visual Studio (VS), so don’t be surprised when you see that mentioned during the install.

Download & Install the Free App: Microsoft SQL Server Management Studio

1. Go to the Download SQL Server Management Studio download page.
2. Click Download SSMS 21 (it should be in the Step 2 section).
3. Open the downloaded file. How you do that depends on the web browser you use but it’s usually in the Downloads panel. Here’s how it may look:

   

4. If asked to allow this app to make changes to your device, click Yes.
5. If the Visual Studio Installer says it needs to set up a few things, click Continue.
6. You should now see the install screen. The 4 options listed are all optional, but you may want Code tools so you could check that on (you may need to scroll down to see it). None are required though.
   
7. Click Install.
8. If asked to allow this app to make changes to your device, click Yes.
9. Once the install is done, if it says a restart is recommended or required, do so. Otherwise just close the installer.

Launch the SQL Server Management Studio App

To make sure your installation was successful, open the app by doing the following:

1. Go into your Windows Start Menu and in the list of All apps, go into the Microsoft SQL Server Tools folder and click on SQL Server Management Studio.

   If nothing happens and the app does not launch, it’s likely because your computer has an ARM processor (as opposed to Intel). This version of the app does not run on ARM processors, but the previous version works fine (even though it’s using emulation mode). Try installing SSMS version 20.2 using these instructions.

2. If asked to sign in, click Skip and add accounts later.
3. If asked about trying out a “new connection dialog experience”, click Yes.
   If you already clicked No, don’t worry. It’s OK, you don’t have to switch.
4. You should now be in the SQL Server Management Studio app, which looks like this:
   
5. Congratulations, you are done!
   To close the app, you can click Cancel and then close the window.

For more information and training on the use of SQL Server Management Studios, consider enrolling in Noble Desktop’s SQL Server Bootcamp or search for a local SQL class using the Classes Near Me tool.