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

49,370

Downloads

26,073

Downloads of v 12.2.5000.20161110

11/10/2016

Last update

SQL Server 2014 Express Management Studio

12.2.5000.20161110

Package test results are passing.

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package was approved by moderator gep13 on 7/16/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 = "http://care.dlservice.microsoft.com/dl/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/MgmtStudio%2032BIT/SQLManagementStudio_x86_ENU.exe"
    $url64 = "http://care.dlservice.microsoft.com/dl/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/MgmtStudio%2064BIT/SQLManagementStudio_x64_ENU.exe"
    
    # 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 $url64
    
    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

New download version and checksum added.

Version History

Version Downloads Last updated Status
SQL Server 2014 Express Management Studio 12.0.2000.20160527 13926 Friday, May 27, 2016 approved
SQL Server 2014 Express Management Studio 12.0.2000.8 5617 Friday, April 17, 2015 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.5 2939 Friday, July 18, 2014 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.4 235 Thursday, July 10, 2014 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.3 134 Saturday, July 5, 2014 approved
SQL Server 2014 Express Management Studio (UNATTENDED) 1.0.1 143 Thursday, July 3, 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