Notices: This section not yet converted to new layout. Download stats are rolling back out.

53,943

Downloads

3,505

Downloads of v 12.2.5000.20170905

9/5/2017

Last update

SQL Server 2014 Express Management Studio

12.2.5000.20170905

Package test results are passing.

This package was approved as a trusted package on 9/5/2017.

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

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

Maintainer(s)

Software Author(s)

  • Microsoft

Tags

Release Notes

Uninstall script fixed.

Version History

Version Downloads Last updated Status
SQL Server 2014 Express Management Studio 12.2.5000.20161110 26771 Thursday, November 10, 2016 approved
SQL Server 2014 Express Management Studio 12.0.2000.20160527 14164 Friday, May 27, 2016 approved
SQL Server 2014 Express Management Studio 12.0.2000.8 5637 Friday, April 17, 2015 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.5 2953 Friday, July 18, 2014 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.4 252 Thursday, July 10, 2014 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.3 153 Saturday, July 5, 2014 approved
Show More

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.

comments powered by Disqus