How to Silently Install Microsoft SQL Server Management Studio

Silent install · · 7 min read

With every Windows endpoint converged on the same version, deploying Microsoft SQL Server Management Studio silently becomes a straightforward, repeatable task for IT teams. This guide is built for admins who need a reliable machine-wide rollout using the verified silent install command, with admin rights and a clear detection rule to support validation and ongoing maintenance. It is especially useful when standardizing software delivery through Intune, SCCM, or PDQ across managed environments.

STEP 0

Quick snapshot: Silently install Microsoft SQL Server Management Studio on Windows

Run in an elevated Command Prompt or PowerShell:

cmd
Microsoft.SQLServerManagementStudio.21.0.0.X64.exe --quiet --norestart --wait

Overview

ApplicationMicrosoft SQL Server Management Studio
Version21.0.0
PublisherMicrosoft Corporation
Installer typeEXE quiet installer
Install scopeSystem / machine-wide
Requires adminYes
Silent installAvailable
Silent uninstallAvailable
Detection methodFile
Installer fileMicrosoft.SQLServerManagementStudio.21.0.0.X64.exe
DownloadMicrosoft SQL Server Management Studio installer

Silent install steps

Run any one of the methods below to install Microsoft SQL Server Management Studio silently with zero user interaction. Command Prompt and PowerShell produce the same result — use whichever fits your deployment workflow.

Method 1: Install with Command Prompt

  1. Download or stage the installer (Microsoft.SQLServerManagementStudio.21.0.0.X64.exe) to a local folder, for example C:\Installers.
Installers
This PCLocal Disk (C:)InstallersSearch Installers
Microsoft.SQLServerManagementStudio.21.0.0.X64.exe6/17/2026 9:14 AMApplication
1 item1 item selected
  1. Open Command Prompt as Administrator:
    Press StartType cmdRight-click Command PromptChoose Run as administrator
AllAppsDocumentsSettingsFoldersPhotos
Best match
Command PromptSystem
Command Prompt
System
Open
Run as administrator
Run as different user
Open file location
cmd
  1. Switch to the installer folder, then run the silent install command:
cmd
Microsoft.SQLServerManagementStudio.21.0.0.X64.exe --quiet --norestart --wait

Method 2: Install with PowerShell

Run the same silent install through PowerShell (elevated).

  1. Download or stage the installer (Microsoft.SQLServerManagementStudio.21.0.0.X64.exe) to a local folder, for example C:\Installers.
  1. Open PowerShell as Administrator — right-click Start (or press Win+X), then:
    • On Windows 10: choose Windows PowerShell (Admin).
    • On Windows 11: choose Terminal (Admin) — it opens Windows Terminal running PowerShell.
Right-click the Start button — or press ⊞ Win + X
Apps and Features
Power Options
Device Manager
Disk Management
Terminal
Terminal (Admin)
Task Manager
Settings
  1. Run the command:
powershell
Start-Process -FilePath Microsoft.SQLServerManagementStudio.21.0.0.X64.exe -ArgumentList '--quiet --norestart --wait' -Wait

Deployment Notes

Key facts to confirm before rolling this out to production machines — permissions required, scope of install, and reboot behavior.

RequirementAdministrator privileges required
Install scopeMachine
Restart behaviorNo restart expected
Success exit codesAlso treat 1, 3010 as success

Detection Rules

Configure your deployment tool with the detection rule below to confirm a successful install of Microsoft SQL Server Management Studio. The same rule work for Microsoft Intune, SCCM, PDQ Deploy, and most RMM platforms — just paste the values into the matching fields.

File detection

File path%ProgramFiles%\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\SSMS.exe
Expected version21.4.36301.6
Architecture64-bit

PowerShell detection script

Prefer a script-based check? Use this as a custom detection script in Microsoft Intune (or any tool that supports detection scripts). It exits 0 when Microsoft SQL Server Management Studio is detected and 1 otherwise.

powershell
$Path = "$env:ProgramFiles\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\SSMS.exe"
if (Test-Path $Path) {
    $Version = (Get-Item $Path).VersionInfo.ProductVersion
    if ($Version -eq '21.4.36301.6') { exit 0 }
}
exit 1

Silent Uninstall Steps

Remove Microsoft SQL Server Management Studio silently from one machine or your entire fleet. The commands below uninstall without prompts and suppress automatic reboots so you control the timing.

Method 1: Uninstall with Command Prompt

Run the uninstall command from an elevated Command Prompt.

  1. Open Command Prompt as Administrator.
  2. Run the silent uninstall command.
cmd
"%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" uninstall --installPath "%ProgramFiles%\Microsoft SQL Server Management Studio 21\Release" --quiet --norestart

Method 2: Uninstall with PowerShell

Run the same silent uninstall command through PowerShell.

  1. Open PowerShell as Administrator.
  2. Run the silent uninstall command.
powershell
Start-Process -FilePath "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" -ArgumentList 'uninstall --installPath "%ProgramFiles%\Microsoft SQL Server Management Studio 21\Release" --quiet --norestart' -Wait

Deployment Examples

Drop one of the snippets below into your deployment tool, Group Policy, or scheduled task. Each script wraps the silent install command for Microsoft SQL Server Management Studio as a batch file or PowerShell script — copy, save, and run.

Batch file example

Save the following content as install-microsoft-sql-server-management-studio.bat in the same folder as the installer.

cmd
@echo off
cd /d "%~dp0"
Microsoft.SQLServerManagementStudio.21.0.0.X64.exe --quiet --norestart --wait
exit /b %errorlevel%

PowerShell script example

Save the following content as install-microsoft-sql-server-management-studio.ps1 in the same folder as the installer.

powershell
Set-Location -Path $PSScriptRoot
$Installer = 'Microsoft.SQLServerManagementStudio.21.0.0.X64.exe'
& $Installer --quiet --norestart --wait
exit $LASTEXITCODE

Frequently asked questions

Can I silently install Microsoft SQL Server Management Studio on Windows?
Yes. This guide uses EXE silent installer switches to install Microsoft SQL Server Management Studio 21.0.0 in a fully unattended way with no user interaction. It is commonly deployed through Intune, SCCM, PDQ Deploy, and RMM tools.
Do I need administrator privileges to install Microsoft SQL Server Management Studio?
Yes. Microsoft SQL Server Management Studio requires elevated rights for installation. Run the installer as Administrator or deploy it under the SYSTEM context.
Will installing Microsoft SQL Server Management Studio restart the computer?
No. The silent EXE installer for Microsoft SQL Server Management Studio finishes without rebooting the device. Use the silent switch listed in the install command above.
How do I verify Microsoft SQL Server Management Studio installed successfully?
Verify Microsoft SQL Server Management Studio using the detection rule provided in this guide, such as a file path, registry key, MSI product code, or MSIX package family name. These are commonly supported in Intune, SCCM, and PDQ.
How do I silently uninstall Microsoft SQL Server Management Studio?
Silently remove Microsoft SQL Server Management Studio by running the vendor-provided uninstaller, setup.exe with --uninstall flags.
Which deployment tools support these commands?
These commands are commonly used with Intune, SCCM/MECM, PDQ Deploy, ManageEngine, NinjaOne, Datto RMM, Atera, and Action1 for deploying Microsoft SQL Server Management Studio.

Troubleshooting

If the install fails, exits with a non-zero code, or leaves no trace on the target machine, work through the checks below. Most issues come down to permissions, paths, or exit code handling.

Run as administratorMake sure Command Prompt or PowerShell is opened as Administrator. This installer writes to a machine-wide location and will fail silently without elevated permissions.
Verify the installer file nameConfirm that the installer file name matches the command shown in this guide: Microsoft.SQLServerManagementStudio.21.0.0.X64.exe.
Run from the correct folderRun the command from the folder that contains the installer file. For batch or PowerShell deployments, place the script and installer in the same folder.
Check exit codesIf the installer returns a non-zero exit code, review the installer log or your deployment tool's logs. This package also treats 1, 3010 as success.
Restart if requiredIf the application does not appear immediately after installation, sign out and sign back in, or restart the device — this refreshes Start menu shortcuts, file associations, and Path entries written by the installer.
Validate detection rulesIf your deployment tool reports the app as not installed, verify that the detection rule matches the installed version, MSI product code, registry key, or file path. Use the Detection Rules section above to confirm whether the application was installed successfully.

Deployment recap

Before you roll Microsoft SQL Server Management Studio out to production, confirm you have:

  • The silent install command, run from an elevated prompt
  • The matching silent uninstall command for rollback
  • The detection rule wired into your deployment tool

Got all three? You’re ready to deploy at scale. If this guide saved you time, fuel the next one:

Rating
be the first to rate

Comments

Loading comments…

    Leave a comment

    ✎ Edit