-
-
Save justinsoliz/34324700ea93c7b77b4ac3e132584de7 to your computer and use it in GitHub Desktop.
# 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 |
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.
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!