Skip to content

Instantly share code, notes, and snippets.

@justinsoliz
Created February 17, 2018 19:45
Show Gist options
  • Star 14 You must be signed in to star a gist
  • Fork 7 You must be signed in to fork a gist
  • Save justinsoliz/34324700ea93c7b77b4ac3e132584de7 to your computer and use it in GitHub Desktop.
Save justinsoliz/34324700ea93c7b77b4ac3e132584de7 to your computer and use it in GitHub Desktop.
Powershell - Install Sql Server Management Studio
# 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
@Chandrashekar-MS18
Copy link

It worked super fast. Thanks for the script.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment