Unpacking Software Livestream

Join our monthly Unpacking Software livestream to hear about the latest news, chat and opinion on packaging, software deployment and lifecycle management!

Learn More

Chocolatey Product Spotlight

Join the Chocolatey Team on our regular monthly stream where we put a spotlight on the most recent Chocolatey product releases. You'll have a chance to have your questions answered in a live Ask Me Anything format.

Learn More

Chocolatey Coding Livestream

Join us for the Chocolatey Coding Livestream, where members of our team dive into the heart of open source development by coding live on various Chocolatey projects. Tune in to witness real-time coding, ask questions, and gain insights into the world of package management. Don't miss this opportunity to engage with our team and contribute to the future of Chocolatey!

Learn More

Calling All Chocolatiers! Whipping Up Windows Automation with Chocolatey Central Management

Webinar from
Wednesday, 17 January 2024

We are delighted to announce the release of Chocolatey Central Management v0.12.0, featuring seamless Deployment Plan creation, time-saving duplications, insightful Group Details, an upgraded Dashboard, bug fixes, user interface polishing, and refined documentation. As an added bonus we'll have members of our Solutions Engineering team on-hand to dive into some interesting ways you can leverage the new features available!

Watch On-Demand
Chocolatey Community Coffee Break

Join the Chocolatey Team as we discuss all things Community, what we do, how you can get involved and answer your Chocolatey questions.

Watch The Replays
Chocolatey and Intune Overview

Webinar Replay from
Wednesday, 30 March 2022

At Chocolatey Software we strive for simple, and teaching others. Let us teach you just how simple it could be to keep your 3rd party applications updated across your devices, all with Intune!

Watch On-Demand
Chocolatey For Business. In Azure. In One Click.

Livestream from
Thursday, 9 June 2022

Join James and Josh to show you how you can get the Chocolatey For Business recommended infrastructure and workflow, created, in Azure, in around 20 minutes.

Watch On-Demand
The Future of Chocolatey CLI

Livestream from
Thursday, 04 August 2022

Join Paul and Gary to hear more about the plans for the Chocolatey CLI in the not so distant future. We'll talk about some cool new features, long term asks from Customers and Community and how you can get involved!

Watch On-Demand
Hacktoberfest Tuesdays 2022

Livestreams from
October 2022

For Hacktoberfest, Chocolatey ran a livestream every Tuesday! Re-watch Cory, James, Gary, and Rain as they share knowledge on how to contribute to open-source projects such as Chocolatey CLI.

Watch On-Demand

Downloads:

3,446,207

Downloads of v 14.0.17099.20170503:

4,070

Last Update:

03 May 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.

  • 1
  • 2
  • 3

14.0.17099.20170503 | Updated: 03 May 2017

Downloads:

3,446,207

Downloads of v 14.0.17099.20170503:

4,070

Maintainer(s):

Software Author(s):

  • Microsoft

SQL Server Management Studio 14.0.17099.20170503

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

Legal Disclaimer: Neither this package nor Chocolatey Software, Inc. are affiliated with or endorsed by Microsoft. The inclusion of Microsoft trademark(s), if any, upon this webpage is solely to identify Microsoft goods or services and not for commercial purposes.

  • 1
  • 2
  • 3

This Package Contains an Exempted Check

Not All Tests Have Passed


Validation Testing Passed


Verification Testing Exemption:

Exempted due to necessary KB update not being available.

Details

Scan Testing Exemption for this package version only:

Details
Learn More

Deployment Method: Individual Install, Upgrade, & Uninstall

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:

>

Deployment Method:

NOTE

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

1. Enter Your Internal Repository Url

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


2. Setup Your Environment

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

2. Get the package into your environment

  • 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://community.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. Copy Your Script

choco upgrade sql-server-management-studio -y --source="'INTERNAL REPO URL'" --version="'14.0.17099.20170503'" [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="'INTERNAL REPO URL'" --version="'14.0.17099.20170503'" 
$exitCode = $LASTEXITCODE

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

Exit $exitCode

- name: Install sql-server-management-studio
  win_chocolatey:
    name: sql-server-management-studio
    version: '14.0.17099.20170503'
    source: INTERNAL REPO URL
    state: present

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


chocolatey_package 'sql-server-management-studio' do
  action    :install
  source   'INTERNAL REPO URL'
  version  '14.0.17099.20170503'
end

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


cChocoPackageInstaller sql-server-management-studio
{
    Name     = "sql-server-management-studio"
    Version  = "14.0.17099.20170503"
    Source   = "INTERNAL REPO URL"
}

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


package { 'sql-server-management-studio':
  ensure   => '14.0.17099.20170503',
  provider => 'chocolatey',
  source   => 'INTERNAL REPO URL',
}

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


4. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

NOTE

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

Package Approved

This package was approved as a trusted package on 03 May 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/C/8/A/C8AE3D51-5AAD-4DCF-809C-667D691629E4/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      = '54692d0a38b44c6d0318c12c32ca69d3852c68116642914c8efdcba020c89dda'
  checksumType  = 'SHA256'
}

Install-ChocolateyPackage @packageArgs

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.

Add to Builder Version Downloads Last Updated Status
SQL Server Management Studio 20.1 20.1.10 109747 Friday, April 12, 2024 Approved
SQL Server Management Studio 20.0 20.0.70 29613 Friday, March 22, 2024 Approved
SQL Server Management Studio 19.3 19.3.4 84002 Friday, January 12, 2024 Approved
SQL Server Management Studio 19.2 19.2.56.2 69161 Thursday, November 16, 2023 Approved
SQL Server Management Studio 19.1 19.1.56 135863 Thursday, June 15, 2023 Approved
SQL Server Management Studio 19.0.2 19.0.20209.0 102181 Thursday, March 23, 2023 Approved
SQL Server Management Studio 19.0.1 19.0.20200.0 78406 Saturday, February 4, 2023 Approved
SQL Server Management Studio 18.12.1 15.0.18424.0 308609 Friday, June 24, 2022 Exempted
SQL Server Management Studio 18.11.1 15.0.18410.0 137854 Tuesday, March 15, 2022 Exempted
SQL Server Management Studio 18.10 15.0.18390.0 227128 Wednesday, October 13, 2021 Exempted
SQL Server Management Studio 18.9.2 15.0.18386.0 126710 Wednesday, July 21, 2021 Approved
SQL Server Management Studio 18.9.1 15.0.18384.0 142595 Friday, April 23, 2021 Approved
SQL Server Management Studio 18.8 15.0.18369.0 154892 Tuesday, December 22, 2020 Approved
SQL Server Management Studio 18.7.1 15.0.18358.0 82390 Friday, October 30, 2020 Approved
SQL Server Management Studio 18.6 15.0.18338.0 106633 Friday, July 24, 2020 Approved
SQL Server Management Studio 18.5.1 15.0.18333.0 47110 Wednesday, June 17, 2020 Approved
SQL Server Management Studio 18.5 15.0.18330.0 85133 Friday, April 10, 2020 Approved
SQL Server Management Studio 18.4 15.0.18206.0 110786 Tuesday, November 19, 2019 Approved
SQL Server Management Studio 18.3.1 15.0.18183.0 35865 Thursday, October 3, 2019 Approved
SQL Server Management Studio 18.2 15.0.18142.0 279 Thursday, October 3, 2019 Approved
SQL Server Management Studio 18.1 15.0.18131.0 99288 Friday, June 14, 2019 Approved
SQL Server Management Studio 18.0 15.0.18118.0 84890 Monday, April 29, 2019 Approved
SQL Server Management Studio 17.9.1 14.0.17289.1 349803 Wednesday, November 28, 2018 Approved
SQL Server Management Studio 17.9 14.0.17285.0 82168 Thursday, September 13, 2018 Approved
SQL Server Management Studio 17.8.1 14.0.17277.0 54543 Tuesday, July 10, 2018 Approved
SQL Server Management Studio 17.7 14.0.17254.0 48153 Friday, May 11, 2018 Approved
SQL Server Management Studio 17.6 14.0.17230.0 11676 Friday, March 30, 2018 Approved
SQL Server Management Studio 17.5 14.0.17224.0 28091 Friday, February 16, 2018 Approved
SQL Server Management Studio 17.4 14.0.17213.0 30676 Friday, December 8, 2017 Approved
SQL Server Management Studio 17.3 14.0.17199.0 24243 Thursday, October 12, 2017 Approved
SQL Server Management Studio 14.0.17177.0 32600 Tuesday, August 8, 2017 Approved
SQL Server Management Studio 14.0.17119.0 18579 Monday, May 29, 2017 Approved
SQL Server Management Studio 14.0.17099.20170503 4070 Wednesday, May 3, 2017 Approved
SQL Server Management Studio 14.0.17099.0 1463 Friday, April 28, 2017 Approved
SQL Server Management Studio 13.0.16106.4 15078 Saturday, January 28, 2017 Approved
SQL Server Management Studio 13.0.16105.4 833 Tuesday, January 24, 2017 Approved
SQL Server Management Studio 13.0.16100.1 1781 Tuesday, December 6, 2016 Approved
SQL Server Management Studio 13.0.16000.28 2056 Thursday, October 27, 2016 Approved
SQL Server Management Studio 13.0.15900.1 1050 Friday, September 30, 2016 Approved
SQL Server Management Studio 13.0.15800.18 1047 Wednesday, September 21, 2016 Approved
SQL Server Management Studio 13.0.15700.28 1763 Tuesday, August 16, 2016 Approved
SQL Server Management Studio 13.0.15600.2 1106 Monday, July 18, 2016 Approved
SQL Server Management Studio 13.0.15500.91 605 Thursday, July 7, 2016 Approved
SQL Server Management Studio 13.0.15000.23 686 Thursday, June 2, 2016 Approved
SQL Server Management Studio 13.0.14000.36-preview 609 Saturday, April 16, 2016 Exempted
SQL Server Management Studio 13.0.13000.55-preview 582 Saturday, April 2, 2016 Exempted
SQL Server Management Studio 13.0.12500.29-preview 603 Sunday, March 20, 2016 Exempted
SQL Server Management Studio 13.0.12000.65-preview 557 Tuesday, March 8, 2016 Exempted
SQL Server Management Studio 13.0.11000.78-preview 641 Tuesday, March 1, 2016 Exempted

(14.0.17099.20170503 update fixes download URLs to point to correct 17.0 release, thanks to @chucker)

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