SQL Server Management Studio Silent Install (How-To Guide)


SQL Server Management Studio (SSMS) is a software application that is used for configuring, managing, and administering all components within Microsoft SQL Server. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of SQL Server Management Studio (SSMS) from the command line using the EXE installer.

How to Install SQL Server Management Studio Silently

SQL Server Management Studio Silent Install (EXE)

  1. Download the SQL Server Management Studio Installer
  2. Download the SSMS-Setup-ENU.exe to a folder created at (C:\Downloads)
  3. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  4. Navigate to the C:\Downloads folder
  5. Enter the following command: SSMS-Setup-ENU.exe /install /quiet /norestart
  6. Press Enter
Microsoft SQL Server 2019 Express S...
Microsoft SQL Server 2019 Express Silent Install (How-To Guide)

After several minutes you should see the SQL Server Management Studio entries in the Start Menu, Installation Directory, and Programs and Features in the Control Panel.

Software Title:SQL Server Management Studio
Vendor:Microsoft Corporation
Version:18.8
Architecture:x86
Installer Type:EXE
Silent Install Switch:SSMS-Setup-ENU.exe /install /quiet /norestart
Silent Uninstall Switch:SSMS-Setup-ENU.exe /uninstall /quiet /norestart
Repair Command:SSMS-Setup-ENU.exe /repair /quiet /norestart
Download Link:https://aka.ms/ssmsfullsetup
PowerShell Script:https://silentinstallhq.com/sql-server-management-studio-install-and-uninstall-powershell/
Detection Script:https://silentinstallhq.com/create-a-custom-detection-script-for-sql-server-management-studio-powershell/

The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.


Additional Configurations

Create a SQL Server Management Studio Installation Log File

The SQL Server Management Studio installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following commands to create a verbose log file with details about the installation.

SQL Server Management Studio (SSMS) Silent Install with Logging

SSMS-Setup-ENU.exe /install /quiet /norestart /log "%WINDIR%\Temp\SSMS-Install.log"

How to Uninstall SQL Server Management Studio Silently

Check out the SQL Server Management Studio Install and Uninstall (PowerShell) post for a scripted solution.

  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following command:

SQL Server Management Studio (SSMS) Silent Uninstall

SSMS-Setup-ENU.exe /uninstall /quiet /norestart

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.

Recent Posts