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

@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.