Skip to content

TechDirectArchive

Hands-on IT, Cloud, Security, Veeam & DevOps

  • Home
  • About
  • Advertise With US
  • Reviews
  • Contact
  • Toggle search form

How to install Microsoft SQL Server Management Studio

Posted on 01/09/202120/08/2026 Christian By Christian No Comments on How to install Microsoft SQL Server Management Studio
  1. Home
  2. Oracle/MSSQL/MySQL
  3. How to install Microsoft SQL Server Management Studio
SQL Server Management Studio installation

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Furthermore, SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Please See how to reset MSSQL Server SA Password on Ubuntu via the command line and SQL Server Management Studio.

Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud. Discover how to install Microsoft SQL Server.

See this guide on how to download and install Microsoft SQL Server 2019 Express edition and Microsoft SQL Server Management Studio on Windows 10 and Windows Server. See how to uninstall Microsoft SQL Server on Windows 10 and Windows Server, and how to uninstall Oracle Database 11G or 12c.

At the time of writing this piece, SSMS 18.9.2 is the latest general availability (GA) version. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.9.2 upgrades it to 18.9.2. See this guide if you wish to uninstall Microsoft SQL Server Management Studio

The SSMS 18.x installation doesn’t upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x installs side by side with previous versions, so both versions are available for use. However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.9.2.

You can see if you have the preview version by going to the Help > About window. Thus, see this guide on how to manually check and update SQL Server Management Studio, and how to deploy your Angular App to Azure from Visual Studio Code.

Note: Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. In addition, users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio.

Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.

Installation of Microsoft SQL Server Management Studio

Navigate to the following link to download SSMS. Now that you’ve downloaded the SSMS-Setup-ENU file, double click to launch it.

Microsoft SSMS setup

This will open up the Microsoft SQL Server Management Studio (SSMS) install window.
– By clicking on install, you agree to the license terms as shown below. As you can see below, SSMS is currently being installed.

Installing SQL Server Management Studio

When the application completes you will be required to restart your server for setup can continue

SQL Server Management Studio download

Upon restart, you will be able to launch and start using SSMS.

Screenshot 2020 06 24 at 18.50.39
Screenshot 2020 06 24 at 18.50.39

SSMS Unattended install

To install Microsoft SQL Server, there’s a need for installation of SSMS. You can install SSMS using a command prompt script. If you want to install SSMS in the background with no GUI prompts, then follow the steps below.
– Launch the command prompt with elevated permissions.
– Type the command below in the command prompt.

start "" /w <path where SSMS-Setup-ENU.exe file is located> /Quiet SSMSInstallRoot=<path where you want to install SSMS>

Below is an example of how the command will look like. You can also pass /Passive instead of /Quiet to see the setup UI.

start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMS

So, when the installation is complete, SSMS will be installed to %systemdrive%\SSMS\Common7\IDE\Ssms.exe” based on the example stated above.

Screenshot-2021-09-01-at-20.57.12

Here are some other guides you may also want to read. How to use a dedicated MsSQL Db for Pleasant Password, how to migrate Veeam MsSQL Database to a new MsSQL Server, and how to reset MSSQL Server SA Password on Ubuntu via the command line and SQL Server Management Studio.

I hope you found this blog post helpful. With the steps listed above, you should know how to install Microsoft SQL Server. Therefore, if you have any questions, please let me know in the comment session.

Thank you for reading this post. Kindly share it with others.

  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Facebook (Opens in new window) Facebook
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on Telegram (Opens in new window) Telegram
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Share on Mastodon (Opens in new window) Mastodon
  • Share on Bluesky (Opens in new window) Bluesky
Oracle/MSSQL/MySQL Tags:Microsoft SQL, Microsoft SQL Server Studio, MsSQL, SSMS

Post navigation

Previous Post: Azure CI/CD: Configuring Email Notifications in Azure DevOps
Next Post: Service Principal Name: How to add or reset and delete SPNs

Related Posts

  • Database Collation
    Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation Oracle/MSSQL/MySQL
  • azure sql featured image
    How to delete ADFS Windows Internal Database without access credentials Oracle/MSSQL/MySQL
  • oracle q4 earnings are in e28094 but what does it really mean 700x425 1
    How to uninstall Oracle Database 11G or 12c Oracle/MSSQL/MySQL
  • Screenshot 2020 06 22 at 22.46.00
    How to use a dedicated MsSQL Db for Pleasant Password Oracle/MSSQL/MySQL
  • How to create and delete MySQL database
    How to delete and create MySQL Databases Oracle/MSSQL/MySQL
  • Step to migrate from microsft SQl to PostgreSQL
    Migrate Veeam Configuration Database to PostgreSQL Server Backup

More Related Articles

postgresql on windows Install PostgreSQL on Windows server as Veeam Database Engine Oracle/MSSQL/MySQL
Configure SQL Server to listen on a specific TCP port Configure SQL Server Instance to listen on a specific TCP Port Oracle/MSSQL/MySQL
How does key rotation work in MBAM How does Key Rotation work in MBAM? Oracle/MSSQL/MySQL
azure sql featured image How to delete ADFS Windows Internal Database without access credentials Oracle/MSSQL/MySQL
Drop or delete a MySQL user from phpmyAdmin How to delete a MySQL User Account Oracle/MSSQL/MySQL
sql How to alter a DATABASE compatibility level Oracle/MSSQL/MySQL

Leave a Reply Cancel reply

You must be logged in to post a comment.

Microsoft MVP

vexpert-badge-stars-5

Virtual Background

VEEAMLEGEND

Categories

Top 30 Sysadmin blog

veeaam100

Veeam Vanguard

  • what is winrm
    WinRM cannot complete the operation, verify that the specified computer name is valid Windows
  • Veeam backup and replication update
    How to update Veeam Backup and Replication [VBR] Backup
  • VMware Tech Showcase
    Great details on VMware Tech Showcase Virtualization
  • images
    How to perform vulnerability scan on Microsoft SQL Server Security | Vulnerability Scans and Assessment
  • enable or disable WinRM
    How to enable or disable WinRM via the command-line Windows
  • Linux Shell Scripting 1
    Write a Shell Script that Count Lines and Words in a File Linux
  • screenshot 2020 02 08 at 15.53.31
    Enable Automatic Logon via Windows Registry Windows
  • mendeley
    Run Mendeley Reference Manager and Cite for Word on Windows JIRA|Confluence|Apps

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,746 other subscribers
  • RSS - Posts
  • RSS - Comments
  • About
  • Authors
  • Write for us
  • Contact
  • Advertise with us
  • General Terms and Conditions
  • Privacy policy
  • Feedly
  • Telegram
  • Youtube
  • Facebook
  • Instagram
  • LinkedIn
  • Tumblr
  • Pinterest
  • Twitter
  • mastodon
  • Bsky

Tags

Active Directory Azure Bitlocker Microsoft Windows PowerShell WDS Windows 10 Windows 11 Windows Deployment Services Windows Server 2016

Copyright © 2026 TechDirectArchive

Loading Comments...

You must be logged in to post a comment.