SQL Server Management Studio (SSMS) - Release Candidate

Welcome to the current release candidate (17.0 RC3) of SQL Server Management Studio! This release candidate of SQL Server Management Studio (SSMS) includes support for SQL Server vNext.

Download

SSMS release candidate 17.0 RC3 works side-by-side with our generally available release (16.x), but is not recommended for production use.

download Download SQL Server Management Studio 17.0 RC3.
download Download SQL Server Management Studio 17.0 RC3 Upgrade Package.

Enhancements

  • New Upgrade Package
    • Upgrades previous 17.x installations to the current version
    • Provides a smaller download size
    • See known issues below for issues specific to upgrading RC2 to RC3
  • Icon Updates
    • Final set of icon updates for SSMS 17.0
    • New SSMS and Profiler program icons to differentiate between 16.x and 17.x versions
  • 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
  • SQL PowerShell Module
    • Miscellaneous improvements around 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)
    • Colorization when the PowerShell command prompt is invoked from the "Start PowerShell" menu in Object Explorer
    • 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
  • SQL Server on Linux
    • General improvements and fixes for Log Shipping
  • Analysis Server DAX Query Editor with colorization and IntelliSense
  • 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 d - Support for interleaved execution
  • Removed Configuration Manager from Registered Servers explorer
  • Enable reading audit logs from Azure blob storage

Bug fixes

  • 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
  • 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 SQL database 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

Known issues

  • Upgrade from RC2 to RC3

    • Unable to access AS, RS, and IS menu options
    • Profiler and Database Tuning Engine Advisor missing from "Tools" menu
    • Workaround: re-run SSMS 17.0 RC3 Setup and choose to "Repair"
  • SQL on Linux support:

    • Support for native path on "SQL on Linux" will be in an upcoming update of SSMS
    • Currently some scenarios in SSMS may not work as expected. For example:
      • The path displayed in the "Backup Database" form will look like C:\var\opt... (instead of the native Linux path).
      • Clicking on the "Content" button on the Backup Database wizard will cause an error.

Feedback

need help SQL Client Tools Forum | Log an issue or suggestion at Microsoft Connect.

See Also

SQL Server Management Studio Tutorial
What's new in SQL Server vNext