Downloads:

908,848

Downloads of v 14.0.17099.0:

1,185

Last Update:

4/28/2017

Package Maintainer(s):

Software Author(s):

  • Microsoft

Tags:

sql server management studio ssms admin

SQL Server Management Studio

This is not the latest version of SQL Server Management Studio available.

14.0.17099.0 | Updated: 4/28/2017

Downloads:

908,848

Downloads of v 14.0.17099.0:

1,185

Maintainer(s):

Software Author(s):

  • Microsoft

SQL Server Management Studio 14.0.17099.0

This is not the latest version of SQL Server Management Studio available.

This Package Contains an Exempted Check

1 Test Passing and 1 Exempted Test


Validation Testing Passed


Verification Testing Exempt:

Exempted due to necessary KB update not being available.

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

>

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

>

To uninstall SQL Server Management Studio, run the following command from the command line or from PowerShell:

>

NOTE: This applies to both open source and commercial editions of Chocolatey.

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to https://chocolatey.org/api/v2. Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Enter your internal repository url

(this should look similar to https://chocolatey.org/api/v2)

4. Choose your deployment method:


choco upgrade sql-server-management-studio -y --source="'STEP 3 URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:


choco upgrade sql-server-management-studio -y --source="'STEP 3 URL'" 
$exitCode = $LASTEXITCODE

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0
}

Exit $exitCode

- name: Ensure sql-server-management-studio installed
  win_chocolatey:
    name: sql-server-management-studio
    state: present
    version: 14.0.17099.0
    source: STEP 3 URL

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.

Coming early 2020! Central Managment Reporting available now! More information...


chocolatey_package 'sql-server-management-studio' do
  action    :install
  version  '14.0.17099.0'
  source   'STEP 3 URL'
end

See docs at https://docs.chef.io/resource_chocolatey_package.html.


Chocolatey::Ensure-Package
(
    Name: sql-server-management-studio,
    Version: 14.0.17099.0,
    Source: STEP 3 URL
);

Requires Otter Chocolatey Extension. See docs at https://inedo.com/den/otter/chocolatey.


cChocoPackageInstaller sql-server-management-studio
{
   Name     = 'sql-server-management-studio'
   Ensure   = 'Present'
   Version  = '14.0.17099.0'
   Source   = 'STEP 3 URL'
}

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


package { 'sql-server-management-studio':
  provider => 'chocolatey',
  ensure   => '14.0.17099.0',
  source   => 'STEP 3 URL',
}

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


salt '*' chocolatey.install sql-server-management-studio version="14.0.17099.0" source="STEP 3 URL"

See docs at https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.chocolatey.html.

5. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

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

This package was approved as a trusted package on 4/28/2017.

Description

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of
graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features improved compatibility with previous versions of SQL Server,
a stand-alone web installer, and toast notifications within SSMS when new releases become available.

Version Number

This package is versioned using the published build number. The corresponding 'release number' is listed below in the Release Notes section.

Supported SQL Server versions

  • This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2017), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database, and Azure SQL Data Warehouse.
  • There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly.
  • Additionally, SSMS 17.x can be installed side-by-side with SSMS 16.X or SQL Server 2014 SSMS and earlier.

Supported Operating systems

This release of SSMS supports the following platforms when used with the latest available service pack:
Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2012 (64-bit), Windows Server 2012 R2 (64-bit), Windows Server 2008 R2 (64-bit)

SSMS 17.0 is based on the Visual Studio 2015 Isolated shell, which was released before Windows Server 2016. Microsoft takes app compatibility very seriously and ensures that already-shipped applications continue to run on the latest Windows releases. Because of this, we do not anticipate that SSMS with all latest updates applied) will encounter issues when running on Windows Server 2016. Customers are advised to contact support, should they encounter any issues with SSMS on Windows Server 2016. Support will then work with customers to determine if the issue is with SSMS or Visual Studio or with Windows compatibility, and route the issue appropriately.


tools\chocolateyinstall.ps1
$ErrorActionPreference = 'Stop';

(Get-WmiObject -Class Win32_OperatingSystem).Version -match "(?<Major>\d+).(?<Minor>\d+).(?<Build>\d+)" | Out-Null

if ($Matches.Major -eq 6 -and $Matches.Minor -eq 3)
{
    # Windows 8.1 / Server 2012 R2 requires a prerequisite hotfix 
    if (-not (Get-HotFix -Id KB2919355 -ErrorAction SilentlyContinue))
    {
        Write-Error "A prerequisite for installing SQL 2016 on Windows 8.1 and Windows Server 2012 R2 is to have hotfix KB2919355 installed. See https://msdn.microsoft.com/library/ms143506.aspx for more details"
    }
}

$packageName= 'SQL Server Management Studio'
$toolsDir   = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
$url = 'https://download.microsoft.com/download/9/3/3/933EA6DD-58C5-4B78-8BEC-2DF389C72BE0/SSMS-Setup-ENU.exe'

$packageArgs = @{
  packageName   = $packageName
  unzipLocation = $toolsDir
  fileType      = 'EXE'
  url           = $url

  silentArgs    = "/quiet /install /norestart /log `"$env:TEMP\chocolatey\$($packageName)\$($packageName).MsiInstall.log`""
  validExitCodes= @(0, 3010, 1641)

  softwareName  = 'SQL Server Management Studio - 17.0'
  checksum      = '76501959FABD6FF51C7D27B60B049DC84BDB89BF68B5242D3AE1C4B5B91E269D'
  checksumType  = 'SHA256'
}

Install-ChocolateyPackage @packageArgs

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.

Version Downloads Last Updated Status
SQL Server Management Studio 18.2 15.0.18142.0 30 Thursday, October 3, 2019 Approved
SQL Server Management Studio 18.1 15.0.18131.0 98655 Friday, June 14, 2019 Approved
SQL Server Management Studio 18.0 15.0.18118.0 84400 Monday, April 29, 2019 Approved
SQL Server Management Studio 17.9.1 14.0.17289.1 339680 Wednesday, November 28, 2018 Approved
SQL Server Management Studio 17.9 14.0.17285.0 81149 Thursday, September 13, 2018 Approved
SQL Server Management Studio 17.8.1 14.0.17277.0 54088 Tuesday, July 10, 2018 Approved
SQL Server Management Studio 17.7 14.0.17254.0 47665 Friday, May 11, 2018 Approved
SQL Server Management Studio 17.6 14.0.17230.0 11339 Friday, March 30, 2018 Approved

SSMS 17.0 release

Generally available | Build number: 14.0.17099.0

Enhancements
  • Upgrade package and Windows Software Update Services (WSUS)
  • Future 17.X releases include a smaller cumulative update package
  • The update package will also be published to the WSUS catalog
  • Icon Updates
  • Icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions
  • New SSMS and Profiler program icons to differentiate between 16.X and 17.X versions
  • SQL PowerShell Module
  • SQL Server PowerShell module removed from SSMS and now ships via the PowerShell gallery (PowerShell 5.0 now required to support module versioning)
  • Miscellaneous improvements to the "presentation" (formatting) of some SMO objects (e.g. databases now show the size and the available space and tables show row count and space usage)
  • Added colorization when the PowerShell command prompt is invoked from the "Start PowerShell" menu in OE
  • Added -ClusterType and -RequiredCopiesToCommit parameter to AG cmdlets (New-SqlAvailabilityGroup, Join-SqlAvailabilityGroup, and Set-SqlAvailabilityGroup cmdlets)
  • Added parameters -ActiveDirectoryAuthority and -AzureKeyVaultResourceId to Add-SqlAzureAuthenticationContext cmdlet
  • Added Revoke-SqlAvailabilityGroupCreateAnyDatabase, Grant-SqlAvailabilityGroupCreateAnyDatabase and Set-SqlAvailabilityReplicaRoleToSecondary cmdlets
  • Added -SeedingMode parameter to Set-SqlAvailabilityReplica and New-SqlAvailabilityReplica cmdlets
  • Added -ConnectionString parameter to Get-SqlDatabase
  • SQL Server on Linux
  • General improvements and fixes for Log Shipping
  • Added support for native Linux paths Attach, Restore and Backup database
  • Added support for native Linux paths for audit log destination folder
  • Analysis Services
  • DAX Query Window:
  • Parentheses matching in the editor
  • DEFINE MEASURE and DEFINE VAR syntax support
  • Assorted Intellisense improvements
  • Universal Authentication
  • Allows users to specify a username and no password and the Azure Login Dialog will handle the connection
  • SSMS PQ Integration:
  • Scripting of structured data sources works
  • Viewing and Editing of structured data sources in PQ UI
  • New "Add Unique Constraint" template
  • Showplan
  • Show max instead of sum across the threads in properties window for elapsed time
  • Expose new mem grant operator properties
  • Enabled the "Edit Query" button in Live Query Statistics
  • Support for interleaved execution
  • New option to "Analyze Actual Execution Plan"
  • General improvements to showplan compare
  • Introduced functionality in Showplan Comparison feature to find significant differences in Cardinality Estimation between matching nodes of two query plans and perform basic analysis of the possible root causes
  • Removed Configuration Manager from Registered Servers explorer
  • Enable reading audit logs from Azure blob storage
  • Added Parameterization for Always Encrypted, please refer to this page for more details
  • AAD Universal auth connection to Azure SQL DB supports custom tenant id
  • Generate scripts for Azure SQL Database, now scripts full text, rules, and database
  • Branding fixes in splash screens for SSMS and Profiler
  • Removed Utility Control Point UI from SSMS
  • SSMS can now create "PremiumRS" edition SQL Azure databases
  • Always On Availability Groups
  • Add support for new cluster types: EXTERNAL and NONE
  • Add support for SQL Server on Linux
  • Add automatic seeding as an option for initial data synchronization
  • Fixed the some defects, e.g. endpoint URL handling, DB refresh and UI layout
  • Removed Azure replica related features
  • Improved IntelliSense for several Availability Group keywords
  • Activity Monitor
  • Added new "Activity Monitor" pane to the SSMS Output window
  • Changed connection error/timeout message to log info to output window rather than a pop up message
  • Removed empty chart (5th chart) in Overview section
  • Added "(paused)" to Overview title if the Activity Monitor data collection is paused
  • Graph Extensions to SQL Server
  • New icons for graph node and edge tables
  • Graph node and edge tables will be displayed under Graph Tables folder
  • Templates to create graph node and edge tables available
  • Presentation Mode
  • 3 new tasks available via Quick Launch (Ctr-Q)
  • PresentOn - Turn on presentation mode
  • PresentEdit - Edit the presentation font sizes for presentation mode. "Text Editor font" for the Query Editor. "Environment font" for other components.
  • RestoreDefaultFonts - Revert back to default settings.
  • Note: there is currently no PresentOff command at this time. Use RestoreDefaultFonts to turn off Presentation Mode
Bug fixes
  • Fixed an issue where SSMS crashed when showplan scrolled via surfacebook touchpad
  • Fixed an issue where SSMS hangs for a long times while getting the properties of a databases which is being restored or offline
  • Fixed an issue where "Help viewer" could not be opened in RC builds
  • Fixed an issue where "Maintenance Plans Tasks Toolbox" items may be missing in SSMS.
  • Fixed an issue in SSMS where the user was unable to shrink a database when the database name contained curly braces. Connect Item
  • Fixed an issue where SSMS was trying to script the deletion of an Azure database was actually causing the deletion of the database itself. Connect Item
  • Fixed an issue where default values were not scripted for user defined table types. Connect Item
  • Another round of perf improvements around context menu on indexes. Connect Item
  • Fixed issue which was causing excessive flickering when hovering mouse over missing index in execution plan. Connect Item
  • Fixed an issue where SSMS was taking the DB offline when scripting Connect Item
  • Miscellaneous UI fixes on localized (non-English) versions of SSMS.
  • Fixed issue where "Always Encrypted Keys" node was missing when targeting SQL 2016 SP1 Standard Edition.
  • Always Encrypted
  • "Always Encrypted" menu was incorrectly enabled when targeting SQL 2016 RTM Standard Edition or any SQL 2014 (and below) servers
  • Fixed an issue where IntelliSense is reporting an error when the CREATE OR ALTER syntax is used
  • Fixed issue where encryption fails in case CMK/CEK contain characters that should be escaped, i.e. enclosed in brackets
  • When an Out of Memory exception occurs in SSMS, the user is presented an error that suggests to use the native (64bit) PowerShell instead.
  • Fixed issue where the AE wizard was failing in case the user was using Resource Group Manager subscriptions instead of Classic Azure subscriptions
  • Fixed issue where AE wizard was showing an incorrect error when the user had no permissions in any subscriptions or had no Azure Key Vaults in any of them.
  • Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions in case of multiple AAD
  • Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions for which the user has reader permission
  • Fixed an issue where resource files may not be loaded correctly, thus resulting in inaccurate error messages
  • Improved contrast of hyperlinks on SSMS Setup page
  • Fixed an issue where Polybase nodes were not displayed when connected to SQL Server Express (2016 SP1)
  • Fixed an issue where SSMS is unable to change the Compatibility Level of an Azure DB to v140
  • Improved performance of Object Explorer when expanding the list of Azure databases Connect Item
  • Fixed an issue where "View SQL Server Log" context menu item appeared incorrectly for non-relational server types (AS\RS\IS)
  • Fixed an issue where checking syntax of an Analysis Services partition query using SQL auth could result in login failed message
  • Fixed an issue where renaming a preview 1400 compat-level AS tabular model would fail in SSMS
  • Fixed an “operation failed on model” issue that could occur after attempting an invalid operation on the AS server in rare circumstances, revert local changes after unsuccessful save on the model
  • Fixed a typo in Analysis Services Synchronize Database popup dialog
  • Backup/restore container dialogs come up offscreen on multiple monitor setups.
  • SecurityPolicy create fails if target object has ] in its name.
  • SSMS 2016 "Open recent" menu doesn't show recently saved files. Connect Item
  • Removed reset of user settings when VS Shell is updated.
  • Fixed an issue that was preventing the user from being able to change Compatibility Level of a database on SQL Server 2017.
  • Query windows using AAD Universal authentication cannot refresh the query after an hour.
  • Utility Control Point UI removed from SSMS.
  • AD Universal auth connections fail to query data after the initial token expiration.
  • Unable to script Rules from Azure SQL DB to Azure SQL DB.
  • Fixed issue were SQL PowerShell was not able to connect legacy SQL instances (2014 and older). Connect Item
  • Fixed an issue that was causing SSMS to crash when failing to import registered servers.
  • Fixed an issue that was causing SSMS to crash if a user has certain permissions an a database.
  • SSMS - tables disappear from design surface while reviewing views. Connect Item
  • The table scrollbar does not allow the user to scroll the table content, only the up/down Arrow allow this. Its also possible to scroll the table content after trying to scroll using the scrollbar which is a bug. Connect Item
  • Registered Servers not displaying icons after refreshing the root node.
  • Script button for Create Database on Azure v12 servers executes script then displays message "No action to be scripted".
  • SSMS Connect to Server dialog does not clear "Additional Properties" tab for each new connection.
  • Generate Tasks script doesn't generate Create Database scripts for an Azure SQL DB.
  • Scrollbar in View Designer appears disabled.
  • Always Encrypted AVK key paths do not include version ids.
  • Reduced number of engine edition queries in the query window. Connect Item
  • Always Encrypted errors from refreshing modules after encryption are incorrectly handled.
  • Changed default connection timeout for OLTP and OLAP from 15 to 30 seconds to fix a class of ignored connection failures.
  • Fixed a crash in SSMS when custom report is launched. Connect Item
  • Fixed an issue where "Generate Script…" fails for Azure SQL databases.
  • Fix "Script As" and "Generate Script Wizard" to not add extra newlines when scripting objects such as stored procedures. Connect Item
  • SQLAS PowerShell Provider: Add LastProcessed property to Dimension and MeasureGroup folders. Connect Item
  • Live Query Statistics: fixed issue where it was only showing the first query in a batch. Connect Item
  • Showplan: show max instead of sum across the threads in properties window.
  • Query Store: add new report on queries with high execution variation.
  • Object explorer performance issues: Connect Item
  • Context menu for tables momentarily hangs
  • SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection).
  • Avoid issuing table queries that sort on the server
  • Removed Azure Deployment Wizard (Deploy Database to Azure VM) from SSMS
  • Fixed issue where missing indexes were not shown in execution plans in SSMS Connect Item
  • Fixed common crash-on-shutdown issue in SSMS
  • Fixed issue in Object Explorer where an error occurred when bringing up the context menu on the Polybase|Scale-Out Group nodes Connect Item
  • Fixed an issue where SSMS may crash when trying to display the permissions on a database
  • Query Store: general enhancements in context menu items for result grids of query store report
  • Configuring Always Encrypted for an existing table fails with errors on unrelated objects. Connect Item
  • Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect Item
  • The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect Item
  • When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.
  • Fixed UI truncation issue on "New Server Registration" dialog
  • Fix DMF Condition UI incorrectly updating expressions that contain string constant values with quotes in them
  • Fixed an issue that may cause SSMS to crash when running custom reports
  • Add “Execution in Scale Out…” menu item to the folder node
  • Fixed an issue with Azure SQL DB firewall whitelist IP address feature
  • Fixed an issue in SSMS which caused an Object reference not set exception when editing the source of AS multi-dimensional partition
  • Fixed an issue in SSMS which caused an Object reference not set exception when deleting a customer assembly from multi-dimensional AS server
  • Fixed an issue where renaming an AS tabular 1400 db failed
  • Fixed an issue with scripting a 1400 compat-level AS tabular datasource from connection properties dialog
  • Remove assumption that tables in AS 1400 compat-level model have at least one partition
  • Ctrl-R now toggles results pane in SSMS DAX query editor

Discussion for the SQL Server Management Studio Package

Ground Rules:

  • This discussion is only about SQL Server Management Studio and the SQL Server 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 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