62,225

Downloads

10,330

Downloads of v 12.2.5000.20170905

9/5/2017

Last update

SQL Server 2014 Express Management Studio

12.2.5000.20170905

This package was approved as a trusted package on 5/16/2018.

This package only installs SQL Server Express Management Studio UNATTENDED! The SQL Server Express installation itself is provided in a seperate package!
My packages are available on https://github.com/riezebosch/BoxstarterPackages.git. You can fork this repository and suggest improvements using pull requests.

To install SQL Server 2014 Express Management Studio, run the following command from the command line or from PowerShell:

C:\> choco install mssqlservermanagementstudio2014express

To upgrade SQL Server 2014 Express Management Studio, run the following command from the command line or from PowerShell:

C:\> choco upgrade mssqlservermanagementstudio2014express

Files

Hide

tools\ChocolateyInstall.ps1 Show

$packageName = "MsSqlServerManagementStudio2014Express"
$chocolateyTempDir = Join-Path (Get-Item $env:TEMP).FullName "chocolatey"
$tempDir = Join-Path $chocolateyTempDir $packageName
$fileFullPath = "$tempDir\SQLManagementStudio.exe"
$extractPath = "$tempDir\SQLManagementStudio"
$setupPath = "$extractPath\setup.exe"
$silentArgs = "/IACCEPTSQLSERVERLICENSETERMS /Q /ACTION=install /UPDATEENABLED=FALSE"
$url = "https://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x86_ENU.exe"
$checksum = '8a3603ec1afe4320e4ad2685e194196584d79a7f2f5057ed4658913d6722e98a'
$url64 = "https://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x64_ENU.exe"
$checksum64 = 'b6451e433ae06b3bc6337b641e167a3b240eaf9ae2ae14449672f5f1ca7112fc'

# Using the same download location as Install-ChocolateyPackage but need to create the directory first
if (![System.IO.Directory]::Exists($tempDir)) { [System.IO.Directory]::CreateDirectory($tempDir) | Out-Null }
Get-ChocolateyWebFile $packageName $fileFullPath -Url $url -Url64bit $url64 -Checksum $checksum -Checksum64 $checksum64 -ChecksumType 'sha256'
 
Write-Host "Extracting..."
Start-Process "$fileFullPath" "/Q /x:`"$extractPath`"" -Wait

Write-Host "Installing..."
Install-ChocolateyInstallPackage "$packageName" "EXE" "$silentArgs" "$setupPath" -validExitCodes @(0, 3010)

Write-Host "Removing extracted files..."
rm -r "$extractPath"

tools\ChocolateyUninstall.ps1 Show

$packageName = "MsSqlServerManagementStudio2014Express"
$chocolateyTempDir = Join-Path (Get-Item $env:TEMP).FullName "chocolatey"
$tempDir = Join-Path $chocolateyTempDir $packageName
$fileFullPath = "$tempDir\SQLManagementStudio.exe"
$extractPath = "$tempDir\SQLManagementStudio"
$setupPath = "$extractPath\setup.exe"
$silentArgs = "/IACCEPTSQLSERVERLICENSETERMS /FEATURES=Tools /Q /ACTION=uninstall"
$url = "https://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x86_ENU.exe"
$checksum = '8a3603ec1afe4320e4ad2685e194196584d79a7f2f5057ed4658913d6722e98a'
$url64 = "https://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x64_ENU.exe"
$checksum64 = 'b6451e433ae06b3bc6337b641e167a3b240eaf9ae2ae14449672f5f1ca7112fc'

# Using the same download location as Install-ChocolateyPackage but need to create the directory first
if (![System.IO.Directory]::Exists($tempDir)) { [System.IO.Directory]::CreateDirectory($tempDir) | Out-Null }
Get-ChocolateyWebFile $packageName $fileFullPath -Url $url -Url64bit $url64 -Checksum $checksum -Checksum64 $checksum64 -ChecksumType 'sha256'

Write-Host "Extracting..."
Start-Process "$fileFullPath" "/Q /x:`"$extractPath`"" -Wait

Write-Host "Uninstalling..."
Uninstall-ChocolateyPackage "$packageName" "EXE" "$silentArgs" "$setupPath" -validExitCodes @(0, 3010)

Write-Host "Removing extracted files..."
rm -r "$extractPath"

Virus Scan Results

MsSqlServerManagementStudio2014Express.12.2.5000.20170905.nupkg (5d4dd9d11311) - ## / 60 - Log in or click on link to see number of positives

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Dependencies

- dotnet3.5

Package Maintainer(s)

riezebosch

Software Author(s)

Microsoft

Release Notes

Uninstall script fixed.

Version History

Version	Downloads	Last updated	Status
SQL Server 2014 Express Management Studio 12.2.5000.20170905	10330	Tuesday, September 5, 2017	approved
SQL Server 2014 Express Management Studio 12.2.5000.20161110	26877	Thursday, November 10, 2016	approved
SQL Server 2014 Express Management Studio 12.0.2000.20160527	15024	Friday, May 27, 2016	approved
SQL Server 2014 Express Management Studio 12.0.2000.8	5727	Friday, April 17, 2015	approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.5	3022	Friday, July 18, 2014	approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.4	317	Thursday, July 10, 2014	approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.3	224	Saturday, July 5, 2014	approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.1	236	Thursday, July 3, 2014	approved

Discussion for the SQL Server 2014 Express Management Studio Package

Ground rules:

This discussion is only about SQL Server 2014 Express Management Studio and the SQL Server 2014 Express Management Studio package. If you have feedback for Chocolatey, please contact the google group.
This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
Tell us what you love about the package or SQL Server 2014 Express Management Studio, or tell us what needs improvement.
Share your experiences with the package, or extra configuration or gotchas that you've found.
If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.