Powershell - Install Sql Server Management Studio

ssms_install.ps1

# Set file and folder path for SSMS installer .exe
$folderpath="c:\windows\temp"
$filepath="$folderpath\SSMS-Setup-ENU.exe"
 
#If SSMS not present, download
if (!(Test-Path $filepath)){
write-host "Downloading SQL Server 2016 SSMS..."
$URL = "https://download.microsoft.com/download/3/1/D/31D734E0-BFE8-4C33-A9DE-2392808ADEE6/SSMS-Setup-ENU.exe"
$clnt = New-Object System.Net.WebClient
$clnt.DownloadFile($url,$filepath)
Write-Host "SSMS installer download complete" -ForegroundColor Green
 
}
else {
 
write-host "Located the SQL SSMS Installer binaries, moving on to install..."
}
 
# start the SSMS installer
write-host "Beginning SSMS 2016 install..." -nonewline
$Parms = " /Install /Quiet /Norestart /Logs log.txt"
$Prms = $Parms.Split(" ")
& "$filepath" $Prms | Out-Null
Write-Host "SSMS installation complete" -ForegroundColor Green

Hi there,

Thank you for this amazing script - for SSMS 18.1 all you need to do is to update the $URL parameter, so that it points to https://aka.ms/ssmsfullsetup

Cheers!

Awesome. thanks for sharing it

Any idea to amend this powershell scripts so that it can remotely install SSMS in multiple server with SSMS setup files already copy to multiple servers

@Mario2286 you can achieve that using Ansible Configuration management tool.

@Mario2286 You should be able to change the download URL to be the UNC path to the location on the server(s).

Excellent never thought, we can download SSMS using PowerShell also, it looks much easier to download and install using powershell.
If anyone needs to download using .exe
Check Download and install SQL Server Management Studio
Thanks.

Apparently the pipeline doesn't wait for the exe to finish download so the artifact it produces has 0KB , any ideas how to fix this?

It worked super fast. Thanks for the script.