How to install Microsoft SQL Server Management Studio

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. 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. See how to reset MSSQL Server SA Password on Ubuntu via the command line and SQL Server Management Studio.

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.

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.

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

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

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.

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.