SQL Server Management Studio - Changelog (SSMS)

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

This article provides details about updates, improvements, and bug fixes for the current and previous versions of SSMS. Download previous SSMS versions below.

SSMS 17.9

Build number: 14.0.17285.0
Release date: September 04, 2018

What's new

General SSMS

ShowPlan:

  • Graphical Showplan now shows the new row mode memory grant feedback attributes when the feature is activated for a specific plan: IsMemoryGrantFeedbackAdjusted and LastRequestedMemory added to the MemoryGrantInfo query plan XML element. For more on row mode memory grant feedback, see Adaptive query processing in SQL databases.

Azure SQL:

Bug fixes

General SSMS

Replication Monitor:

Import Flat File Wizard:

  • Fixed the link to the help page for "Flat File Wizard" dialog
  • Fixed issue where the wizard did not allow changing the destination table when the table already existed: this allows users to retry without having to exit the wizard, delete the failed table, and then reenter the information into the wizard (User Voice item: https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186).

Import/Export Data-Tier Application:

  • Fixed an issue (in DacFx) which was causing the import of a .bacpac could fail with a message like "Error SQL72014: .Net SqlClient Data Provider: Msg 9108, Level 16, State 10, Line 1 This type of statistics is not supported to be incremental. " when dealing with tables with partitions defined and no indexes on the table.

Intellisense:

  • Fixed an issue where intellisense completion was not working when using AAD with MFA.

Object Explorer:

  • Fixed an issue where the "Filter Dialog" was displayed on random monitors instead of the monitor where SSMS was running (multi-monitor systems).

Azure SQL:

  • Fixed an issue related to enumeration of databases in the "Available Databases" where "master" was not displayed in the dropdown when connected to a specific database.
  • Fixed an issue where trying to generate a script ("Data" or "Schema and Data") was failing then connected to the SQL Azure DB using AAD with MFA.
  • Fixed an issue in the View Designer (Views) where it was not possible to select "Add Tables" from the UI when connected to a SQL Azure DB.
  • Fixed an issue where SSMS Query Editor was silently closing and reopening connections during MFA token renewal. This will prevent side effects unbeknownst to the user (like closing a transaction and never reopening again) from happening. The change adds the token expiration time to the properties window.
  • Fixed an issue where SSMS was not enforcing password prompts for imported MSA accounts for AAD with MFA login.

Activity Monitor:

  • Fixed a an issue that was causing "Live Query Statistics" to hang when launched from Activity Monitor and SQL Authentication was used.

Microsoft Azure integration:

  • Fixed an issue where SSMS only shows the first 50 subscriptions (Always Encrypted dialogs, Backup/Restore from URL dialogs, etc…).
  • Fixed an issue where SSMS was throwing an exception ("Index out of range") while trying to log on to an Microsoft Azure account which did not have any storage account (in Restore Backup from URL dialog).

Object Scripting:

  • When scripting "Drop and Create", SSMS now avoids generating dynamic T-SQL.
  • When scripting a database object, SSMS now does not generate script to set database scoped configurations, if they are set to default values.

Help:

  • Fixed a long outstanding issue where "Help on Help" was not honoring the online/offline mode.
  • When clicking on "Help | Community Projects and Samples" SSMS now opens the default browser that points to a Git page and shows no errors/warnings due to old browser being used.

Known issues

  • There are currently no known issues in this release.

Previous SSMS releases

Download previous SSMS versions by clicking the title links in the following sections.

download SSMS 17.8.1

A bug was discovered in 17.8 related to provisioning SQL databases, so SSMS 17.8.1 replaces 17.8.

Build number: 14.0.17277.0
Release date: June 26, 2018

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new

General SSMS

Database Properties:

  • This improvement exposes the AUTOGROW_ALL_FILES configuration option for Filegroups. This new config option is added under the Database Properties > Filegroups window in the form of a new column (Autogrow All Files) of checkboxes for each available Filegroup (except for Filestream and Memory Optimized Filegroups). The user can enable/disable AUTOGROW_ALL_FILES for a particular Filegroup by toggling the corresponding Autogrow_All_Files checkbox. Correspondingly, the AUTOGROW_ALL_FILES option is properly scripted when scripting the database for CREATE / generating scripts for the database (SQL2016 and above).

SQL Editor:

  • Improved experience with Intellisense in Azure SQL Database when the user doesn't have master access.

Scripting:

  • General performance improvements, especially over high-latency connections.

Analysis Servics (AS)

  • Analysis Services client libraries and data providers updated to the latest version, which added support for the new Azure Government AAD authority (login.microsoftonline.us).

Bug fixes

General SSMS

Maintenance Plans:

  • Fixed an issue when editing maintenance plans with Sql Authentication where "Notify Operator Task" was failing when using SQL authentication.

Scripting:

  • Fixed an issue where PostProcess actions in SMO lead to resource exhaustion and SQL login failures

SMO:

Always Encrypted:

  • Fixed an issue (in DacFx) which was causing a lock timeout error when enabling Always Encrypted on a partitioned table

Analysis Services (AS)

  • Fixed an issue that occurred when modifying an OAuth datasource in a Tabular Analysis Services 1400-level compatibility model, which caused the changes in the OAuth tokens to not get updated in the data source.
  • Fixed a crash in SSMS that may have occurred when using some invalid data source credentials or editing data sources that didn't support Change Data Source migration in Power Query (for example, Oracle) in Analysis Services Tabular 1400-level compatibility models.

Known issues

  • Clicking the Script button after modifying any filegroup property in the Properties window, generates two scripts – one script with a USE statement, and a second script with a USE master statement. The script with USE master is generated in error and should be discarded. Run the script that contains the USE statement.
  • Some dialogs display an invalid edition error when working with new General Purpose or Business Critical Azure SQL Database editions.
  • Some latency in XEvents viewer may be observed. This is a known issue in the .Net Framework. Please, consider upgrading to NetFx 4.7.2.

download SSMS 17.7

Build number: 14.0.17254.0
Release date: May 09, 2018

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new

General SSMS

Replication Monitor:

  • Replication monitor now supports registering a listener for scenarios where publisher database and/or distributor database is part of Availability Group. You can now monitor replication environments where publisher database and/or distribution database is part of Always On.

Azure SQL Data Warehouse:

  • Add Rejected Row Location support for External Tables in Azure SQL Data Warehouse.

Integration Services (IS)

  • Added a scheduling feature for SSIS packages deployed to Azure SQL Database. Unlike SQL Server on premises and SQL Database Managed Instance, which have SQL Server Agent as a first-class job scheduler, SQL Database does not have a built-in scheduler. This new SSMS feature provides a familiar user interface that's similar to SQL Server Agent for scheduling packages deployed to SQL Database. If you're using SQL Database to host the SSIS catalog database, SSISDB, you can use this SSMS feature to generate the Data Factory pipelines, activities, and triggers required to schedule SSIS packages. You can then edit and extend these objects in Data Factory. For more info, see Schedule SSIS package execution on Azure SQL Database with SSMS. To learn more about Azure Data Factory pipelines, activities, and triggers, see Pipelines and activities in Azure Data Factory and Pipeline execution and triggers in Azure Data Factory.
  • Support for SSIS package scheduling in SQL Agent on SQL Managed instance. It is now possible to create SQL Agent jobs to execute SSIS packages on the managed instance.

Bug fixes

General SSMS

Maintenance Plan:

Always On:

  • Fixed an issue where Always On Latency Dashboard was not working with SQL Server 2012.

Scripting:

  • Fixed an issue where scripting stored procedure against Azure SQL Data Warehouse, is not working for non-admin user.
  • Fixed an issue where scripting a database against Azure SQL Database was not scripting the SCOPED CONFIGURATION properties.

Telemetry:

  • Fixed issue where SSMS crashes then trying to connect to a server, after opting out of sending telemetry.

Azure SQL Database:

  • Fixed an issue where the user was not able to set or change compatibility level (the drop-down from empty). Note: in order to set the compatibility level to 150, the user still needs to use the Script button and manually edit the script.

SMO:

Intellisense:

  • Perf improvement: reduced volume of intellisense queries for column data. This is especially beneficial when working on tables with huge number of columns.

SSMS User settings:

  • Fixed an issue where the options page was not resizing properly.

Misc:

  • Improved how text is displayed on Statistics details page.

Integration Services (IS)

  • Better support for Azure SQL Database Managed Instance.
  • Fixed an issue where the user was unable to create a catalog for SQL Server 2014 or before.
  • Fixed two issues with reports:
    • Removed the machine name for Azure servers.
    • Improved handling of localized object name.

Known issues

Some dialogs display an invalid edition error when working with new General Purpose or Business Critical Azure SQL Database editions.

download SSMS 17.6

Build number: 14.0.17230.0
Release date: March 20, 2018

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new

General SSMS

SQL Database Managed Instance:

  • Added a support for Azure SQL Database Managed Instance. Azure SQL Database Managed Instance is a new flavor of Azure SQL Database, providing near 100% compatibility with SQL Server on-premises, a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers.
  • Support for common management scenarios like:
    • Create and alter databases.
    • Backup and restore databases.
    • Importing, exporting, extracting and publishing Data-tier Applications.
    • Viewing and altering Server properties.
    • Full Object Explorer support.
    • Scripting database objects.
    • Support for SQL Agent jobs.
    • Support for Linked Servers.
  • Learn more about Managed Instances here.

Object Explorer:

  • Added settings to not force brackets around names when dragging & dropping from Object Explorer to Query Window. (User suggestions 32911933, and 32671051.)

Data Classification:

  • General improvements and bug fixes.

Integration Services (IS)

Bug fixes

General SSMS

Data Classification:

  • Fixed an issue in Data Classification which was causing newly added classifications to be displayed with stale information type and sensitivity label.
  • Fixed an issue where Data Classification was not working when targeting a server set to a case-sensitive collation.

Always On:

  • Fixed an issue in AG Show Dashboard where clicking on Collect Latency Data could result in an error when the server was set to a case-sensitive collation.
  • Fixed an issue where SSMS was incorrectly reporting an AG as Distributed when the Cluster service shuts down.
  • Fixed an issue when creating AG using Create Availability Group dialog the ReadOnlyRoutingUrl is required.
  • Fixed an issue when the primary is down and manually failover to secondary, a NullReferenceException will be thrown.
  • Fixed an issue when creating Availability Group using backup/restore to initialize a database, on the secondary replicas, the database files will be created in the default directory. The fix includes:
    • Add the data/log directory validator.
    • Only do the file relocation when the replica is on a different OS to the primary replica.
  • Fixed an issue where SSMS wizard doesn't generate CLUSTER_TYPE option, causing secondary join to fail.

Setup:

  • Fixed issue where trying to upgrade SSMS by installing the "upgrade package" was failing when SSMS was installed in a non-default location.

SMO:

  • Fixed performance issue where scripting tables on SQL Server 2016 and above could take up to 30 seconds (now, it's down to less than 1 second).

Object Explorer:

  • Fixed an issue where SSMS could throw an exception like "Object cannot be cast from DBNull to other types" when trying to expand Management node in Object Explorer.
  • Fixed an issue where Start PowerShell was not detecting the SQLServer module when user-defined PS profile emitted output.
  • Fixed an intermittent hang that could occur when right-clicking a Table or Index node in Object Explorer.

Database Mail:

  • Fixed an issue where Database Mail Configuration Wizard was throwing an exception when trying to display/manage more than 16 profiles.

Analysis Services (AS)

  • Fixed as issue where modifying a data source on a 1400 compatibility level model in SSMS the changes are not saved to the server.

Integration Services (IS)

  • Fixed an issue where SSMS did not show SSIS catalog node and reports when connected to SQL Database Managed Instance

Known issues

Warning

There is a known issue where SSMS 17.6 becomes unstable and crashes when using Maintenance Plans. If you use Maintenance Plans, do not install SSMS 17.6. Downgrade to SSMS 17.5 if you already installed 17.6 and this issue is affecting you.

download SSMS 17.5

Generally available | Build number: 14.0.17224.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new

General SSMS

Data Discovery & Classification:

  • Added a new SQL Data Discovery & Classification feature for discovering, classifying, labeling & reporting sensitive data in your databases.
  • Auto-discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role in your organizational information protection stature.
  • Learn more at SQL Data Discovery & Classification.

Query Editor:

  • Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW. This capability allows users to skip a specified number of rows when loading delimited text files into SQL DW. Also added the corresponding intellisense/SMO support for the FIRST_ROW keyword.

Showplan:

Bug fixes

General SSMS

Showplan:

  • Fixed Live Query Statistics elapsed time, to show engine execution time instead of time elapsed for LQS connection.
  • Fixed an issue where showplan was not able to recognize Apply logical operators like GbApply and InnerApply.
  • Fixed an issue related to ExchangeSpill.

Query Editor:

  • Fixed on issue related to SPIDs where SSMS could throw an error like "Input string was not in a correct format. (mscorlib)" when executing a simple query preceded by a "SET SHOWPLAN_ALL ON".

SMO:

  • Fixed an issue where SMO was not able to fetch AvailabilityReplica properties in case the server collation happened to be case-sensitive (as a result, SSMS could display an error message like "The multi-part identifier "a.delimited" could not be bound."
  • Fixed an issue in DatabaseScopedConfigurationCollection class, where incorrectly handling collations (as a result, an SSMS running on an ma machine with a Turkish locale could display an error like "legacy cardinality estimation is not valid scoped configuration" when right clicking on a database running on a server with a case-sensitive collation).
  • Fixed an issue in JobServer class, where SMO was not able to fetch SQL Agent properties on a SQL 2005 server (as a result, SSMS was throwing an error like "Cannot assign a default value to a local variable. Must declare the scalar variable "@ServiceStartMode" and, ultimately, was not displaying the SQL Agent node in Object Explorer).

Templates:

Object Explorer:

Auditing:

  • Fixed an issue with the Merge Audit Files feature.

Known issues

Data classification:

  • Removing a classification and then manually adding a new classification for the same column results in the old information type and sensitivity label being assigned to the column in the main view.
    Workaround: Assign the new information type and sensitivity label after the classification was added back to the main view and before saving.

download SSMS 17.4

Generally available | Build number: 14.0.17213.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new

General SSMS

Vulnerability Assessment:

  • Added a new SQL Vulnerability Assessment service to scan your databases for potential vulnerabilities and deviations from best practices, such as misconfigurations, excessive permissions, and exposed sensitive data.
  • Results of the assessment include actionable steps to resolve each issue and customized remediation scripts where applicable. The assessment report can be customized for each environment and tailored to specific requirements. Learn more at SQL Vulnerability Assessment.

SMO:

  • Fixed issue where HasMemoryOptimizedObjects was throwing exception on Azure.
  • Added support for new CATALOG_COLLATION feature.

Always On Dashboard:

  • Improvements for latency analysis in Availability Groups.
  • Added two new reports: AlwaysOn_Latency_Primary and AlwaysOn_Latency_Secondary.

Showplan:

  • Updated links to point to correct documentation.
  • Allow single plan analysis directly from actual plan produced.
  • New set of icons.
  • Added support for recognize "Apply logical operators" like GbApply, InnerApply.

XE Profiler:

  • Renamed to XEvent Profiler.
  • Stop/Start menu commands now stop/start the session by default.
  • Enabled keyboard shortcuts (for example, CTRL-F to search).
  • Added database_name and client_hostname actions to appropriate events in XEvent Profiler sessions. For the change to take effect, you may need to delete existing QuickSessionStandard or QuickSessionTSQL session instances on the servers - Connect 3142981

Command line:

  • Added a new command line option ("-G") that can be used to automatically have SSMS connect to a server/database using Active Directory Authentication (either 'Integrated' or 'Password'). For details, see Ssms utility.

Import Flat File Wizard:

  • Added a way to pick a schema name other than the default ("dbo") when creating the table.

Query Store:

  • Restored the "Regressed Queries" report when expanding the Query Store available reports list.

Integration Services (IS)

  • Added package validation function in Deployment Wizard, which helps the user figure out components inside SSIS packages that are not supported in Azure-SSIS IR.

Bug fixes

General SSMS

  • Object Explorer:
    • Fixed an issue where Table-Valued Function node was not showing up for database snapshots - Connect 3140161.
    • Improved performance when expanding Databases node when the server has autoclose databases.
  • Query Editor:
    • Fixed an issue where IntelliSense was failing for users that don't have access to the master database.
    • Fixed an issue that was causing SSMS to crash in some cases when the connection to a remote machine was closed - Connect 3142557.
  • XEvent Viewer:
    • Re-enabled functionality to export to XEL.
    • Fixed issues where in some cases the user was not able to load an entire XEL file.
  • XEvent Profiler:
    • Fixed an issue that was causing SSMS to crash when the user did not have VIEW SERVER STATE permissions.
    • Fixed an issue where closing the XE Profiler Live Data window did not stop the underlying session.
  • Registered Servers:
  • SMO:
    • Fixed an issue where the TransferData method on the Transfer object was not working.
    • Fixed an issue where Server databases throws exception for paused SQL DW databases.
    • Fixed an issue where scripting SQL database against SQL DW generated incorrect T-SQL parameter values.
    • Fixed an issue where scripting of a stretched DB incorrectly emitting the DATA_COMPRESSION option.
  • Job Activity Monitor:
    • Fixed an issue where the user was getting an "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (System.Windows.Forms)" error when trying to filter by Category - Connect 3138691.
  • Connection Dialog:
    • Fixed an issue where domain users without access to a Read/Write domain controller could not log in to a SQL Server using SQL Authentication - Connect 2373381.
  • Replication:
    • Fixed an issue where an error similar to "Cannot apply value 'null' to property ServerInstance" was displayed when looking at properties of a pull subscription in SQL Server.
  • SSMS Setup:
    • Fixed an issue where SSMS setup was incorrectly causing all the installed products on the machine to be reconfigured.
  • User Settings:
    • With this fix, US Government sovereign cloud users will have uninterrupted access to their Azure SQL Database and ARM resources with SSMS via Universal authentication and Azure Active Directory login. Users of prior versions of SSMS would need to open Tools|Options|Azure Services and under Resource Management change the configuration of the "Active Directory Authority" property to https://login.microsoftonline.us.

Analysis Services (AS)

  • Profiler: fixed an issue when trying to connect using Window Authentication against Azure AS.
  • Fixed an issue that could cause a crash when canceling connection details on a 1400 model.
  • When setting an Azure blob key in the connection properties dialog when refreshing credentials, it will now be visually masked.
  • Fixed an issue in the Azure Analysis Services User selection dialog to show the Application ID guid instead of the Object ID when searching.
  • Fixed an issue in the Browse Database\MDX query designer toolbar that caused the icons to be incorrectly mapped for some buttons.
  • Fixed an issue that prevented connecting to SSAS using msmdpump IIS http/https addresses.
  • Several strings in the Azure Analysis Services User Picker dialog have now been translated for additional languages.
  • MaxConnections property is now visible for data sources in tabular models.
  • Deployment Wizard will now generate correct JSON definitions for Azure AS role members.
  • Fixed an issue in SQL Profiler where selecting Windows Authentication against Azure AS would still prompt for login.

download SSMS 17.3

Generally available | Build number: 14.0.17199.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Enhancements

  • New "Import Flat File" wizard added to streamline the import experience of CSV files with an intelligent framework, requiring minimal user intervention or specialized domain knowledge. For details, see Import Flat File to SQL Wizard.
  • Added "XEvent Profiler" node to Object Explorer. For details, see Use the SSMS XEvent Profiler.
  • Updated waits filtering and categorization in Performance Dashboard historical waits report.
  • Added the syntax check of the "Predict" function.
  • Added the syntax check of the External Library Management queries.
  • Added SMO support for External Library Management.
  • Added "Start PowerShell" support to "Registered Servers" window (requires a new SQL PowerShell module).
  • Always On: added read-only routing support for availability groups.
  • Added an option to send tracing details to the Output Window for "Active Directory - Universal with MFA support" logins (off by default; needs to be turned on in user settings under "Tools > Options > Azure Services > Azure Cloud > ADAL Output Window Trace Level").
  • Query Store:
    • Query Store UI will be accessible even when QDS is OFF as long as QDS have recorded any data.
    • Query Store UI now exposes waits categorization in all the existing reports. This will let customers unlock the scenarios of Top Waiting Queries and many more.
  • Made inclusion of the scripting parameters headers optional (off by default; can be enabled in user settings under "Tools > Options > SQL Server Object Explorer > Scripting > Include scripting parameters header") - Connect item 3139199.
  • Removed "RC" branding.

Bug Fixes

General SSMS

  • XEvent:
    • Fixed issue where SSMS opens only part of the events in .xel file.
    • Improved “Watch Live Data” experience when default database is not 'master' - Connect item 1222582.
  • Always On: Fixed issue where "Restore log backups" may fail with error "The log in this backup set terminates at LSN x, which is too early to apply to the database".
  • Job Activity Monitor: fixed inconsistent icons - Connect item 3133100.
  • Query Store: Fixed Issue where user cannot choose "custom" date range for Query Store reports. Linked to below connect items.
  • Fixed issue where connection dialog doesn't "clear" the most recently used database when saved info has named database and user selects .
  • Object Scripting:
    • Fixed an issue where "Generate database script" not working and throwing an error when the user has a paused DW database on the server, but selected another non-DW database and tried t script it.
    • Fixed issue where the header for scripted Stored Procedures was not matching the script settings, resulting in a misleading script - Connect item 3139784.
    • Re-enabled the "Script button" when targeting SQL Azure objects.
    • Fixed issue where SSMS was not allowing scripting for "Alter" or "Execute" on some objects (UDF, View, SP, Trigger) when connected to an Azure SQL database - Connect item 3136386.
  • Query editor:
    • Improved intellisense when targeting Azure SQL databases.
    • Fixed an issue where queries failed due to an expired authentication token (Universal Authentication).
    • Improved intellisense when working against Azure SQL databases (particularly, when connecting to Azure SQL Database, the latest T-SQL grammar (140) will be used).
    • Fixed issue where open a query window with a connection to a non-DataWarehouse database on a server would cause all subsequent query windows for that server to DataWarehouse databases to throw various errors about unsupported types/options.
  • Always On:
    • Added seeding mode column to Always On dashboard and AG properties page.
    • Fixed issue where it was not possible to create a Linux AG when primary is on Windows - Connect item 3139856.
  • Fixed several "Out of Memory" issues in SSMS when running queries - Connect item 2845190, Connect item 3123864.
  • Profiler:
    • Fixed issue were Profiler was not working when targeting SQL 2005.
    • Fixed issue where Profiler was not honoring the "trust server certificate" connection option.
  • Activity Monitor: fixed an issue where Activity Monitor does not work when pointed at SQL Server running on Linux.
  • Fixed an issue with the SMO Transfer class where it wouldn’t transfer External Data Source or External File Format objects, objects of those types should now correctly be included in the transfer.
  • Registered Servers:
    • Enabled multiserver query for UA servers (it will try to use the same token for every UA server in the group).
  • AD Universal Authentication:
    • Fixed issue where Azure AD authentication was not supported.
    • Fixed issue where table/view designer was not working.
    • Fixed issue where "Select Top 1000 rows" and "Edit Top 200 rows" were not working.
  • Database restore: fixed an issue where restore omits the last folder in the path when moving files to an alternate location.
  • Compress wizard:
  • Showplan:
    • Fixed issue where PDW operators were not recognized.
  • Server Properties:
    • Fixed issue with not being able to modify server processor affinity.

Analysis Services (AS)

  • Fixed a number of issues with Deployment Wizard to support tabular 1400 compat-level models and Power Query data sources.
  • Deployment Wizard can now deploy to AS Azure when running from Command line.
  • When using Windows Auth in AS Azure the user will now see the name of the user account in Object Explorer correctly.

Known issues in this 17.3 release:

General SSMS

  • The following SSMS functionality is not supported for Azure AD auth using UA with MFA:
    • Database Engine Tuning Advisor is not supported for Azure AD auth; there is a known issue where the error message presented to the user is a bit cryptic "Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,…" instead of the expected "Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient)".
  • Trying to analyze a query in DTA results in an error: "Object must implement IConvertible. (mscorlib)".
  • Regressed Queries is missing from the Query Store list of reports in Object Explorer.
    • Workaround: Right-click the Query Store node and select View Regressed Queries.

Integration Services (IS)

  • The [execution_path] in [catalog].[event_messagea] is not correct for package executions in Scale Out. The [execution_path] starts with “\Package” instead of the object name of the package executable. When viewing the overview report of package executions in SSMS, the link of “Execution Path” in Execution Overview cannot work. The workaround is to click “View Messages” on overview report to check all event messages.

download SSMS 17.2

Generally available | Build number: 14.0.17177.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Enhancements

  • Multi-Factor Authentication (MFA)
    • Multiple-user Azure AD authentication for Universal authentication with Multi-factor authentication (UA with MFA)
    • A new user credential input field was added for Universal Authentication with MFA to support multi-user authentication.
  • The connection dialog box now supports the following 5 authentication methods:

    • Windows Authentication
    • SQL Server Authentication
    • Active Directory - Universal with MFA support
    • Active Directory - Password
    • Active Directory - Integrated
  • Database export/import for DacFx wizard using Universal Authentication with MFA.

  • For API support, see IUniversalAuthProvider Interface.
  • ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to 3.13.9 version.
  • In addition a new CLI interface was delivered supporting Azure AD admin setting for SQL Database and SQL Data Warehouse.

    For more information on the Active Directory authentication methods, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA) and Configure Azure SQL Database multi-factor authentication for SQL Server Management Studio.

  • Output window has entries for queries run during expansion of Object Explorer nodes

  • Enabled View designer Azure SQL Databases
  • The default scripting options for scripting objects from Object Explorer in SSMS have changed:

    • Previously, the default on a new install was to have the generated script target the latest version of SQL Server (currently SQL Server 2017).
    • In SSMS 17.2 a new option has been added: Match Script Settings to Source. When set to True, the generated script targets the same version, engine type, and engine edition as the server the object being scripted is from.
    • The Match Script Settings to Source value is set to True by default, so new installs of SSMS will automatically default to always scripting objects to the same target as the original server.
    • When the Match Script Settings to Source value is set to False, the normal scripting target options will be enabled and function as they did previously.
      • Additionally, all the scripting options have been moved to their own section - Version Options. They are no longer under General Scripting Options.
  • Added support for National Clouds in "Restore from URL"

  • QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats.
  • IntelliSense is now supported for Azure SQL Database
  • Security: connection dialog will default to not trusting server certificates and to requesting encryption for Azure SQL DB connections
  • General improvements around support for SQL Server on Linux:
    • Database Mail node is back
    • Addressed misc issues related to paths
    • Activity Monitor is more stable
    • Connection Properties dialog displays correct platform
  • Performance Dashboard server report now available as a default report:
    • Can connect to SQL Server 2008 and newer versions.
    • Missing indexes sub-report uses scoring to assist in identifying most useful indexes.
    • Historical wait stats sub-report now aggregates waits be category. Idle and sleep waits filtered out by default.
    • New Historical latches sub-report.
  • Showplan node search allows searching in plan properties. Easily look for any operator property such as table name. To use this option when viewing a plan:
    • Right-click on plan, and in the context menu click on Find Node option
    • Use CTRL+F

Analysis Services (AS)

  • New AAD role member selection for users without email addresses in AS Azure models in SSMS

Integration Services (IS)

  • Added new column ("Executed Count") to the execution report for SSIS

Known issues in this release:

  • Query windows using "Active Directory - Universal with MFA Support" authentication may experience an error similar to the following, when attempting to execute a query after being open for one hour:

    Msg 0, Level 11, State 0, Line 0 The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

    Re-running the query should get past the error and succeed.

  • The following SSMS functionality is not supported for Azure AD auth using Universal Authentication with MFA:

    • The New Table/View designer shows the old-style login prompt, and does not work for Azure AD authentication.
    • The Edit Top 200 Rows feature doesn't support Azure Ad authentication.
    • The Registered Server component does not support Azure AD authentication.
    • The Database Engine Tuning Advisor is not supported for Azure AD authentication. There is a known issue where the error message presented to the user is less than helpful: Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,… instead of the expected Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).

Analysis Services (AS)

  • Object Explorer in SSAS will not show the Windows Auth username in AS Azure connection properties.

Bug fixes

Analysis Services (AS)

  • Fixed an issue where AS Restore Database would fail with an error if the DB had a different Name than ID
  • Fixed an issue causing the DAX query window to disregard the menu option for toggling IntelliSense Enabled
  • Fixed an issue that prevented connecting to SSAS through msmdpump IIS http/https addresses
  • Allow connecting to AS Azure using a password that contain a semi-colon
  • Scripting out AS Restore Database command with "Skip Membership" option will include the new corresponding JSON option when used with SQL Server 2017 AS server or AS Azure
  • Fixed an extremely rare issue that could cause the delete database dialog to raise an error when loading
  • Fixed an issue that may occur when attempting to view partitions in 1400-compat level model containing a mix of SQL query and M partition definitions

Integration Services (IS)

  • Fixed issue where the execution information reports of SSISDB catalog can't be displayed
  • Addressed issues in SSMS related to poor performance with large number of projects/packages

download SSMS 17.1

Generally available | Build number: 14.0.17119.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Enhancements

  • Profiler: Help > About now displays release version number (e.g 17.1)
  • Analysis Service users can refresh credentials for their datasources for 1200 TM models and above from the context menu on the datasource
  • Built-in SSIS reports now show logs from SSIS scale-out execution in CTP 2.1
  • SSIS scale-out management application
    • View basic information about scale-out master.
    • Easily add a Worker to the scale-out deployment.
    • View all the scale-out workers and basic information about them, and can also enable or disable them easily.

Bug fixes

  • Always On:
    • Fixed an issue where the properties of an Availability Replica was always displayed as "Automatic failover" mode for WSFC AGs.
    • Fixed an issue where the read-only routing list was overwritten when updating the Availability Group
  • Always Encrypted: fixed an issue where log file generated was missing the information generated by DacFx.
  • ShowPlan: fixed in issue where the UI was always showing the Actual join type attribute for non Adaptive join operators.
  • Setup:
    • Fixed an issue where SSMS 17.0 was breaking SSDT on Visual Studio 2013 [Connect Item 3133479]
    • Fixed an issue where clicking on "Restart" at the end of setup was not restarting the machine
  • Scripting: temporarily preventing SSMS from accidentally deleting Azure database objects when trying to script the deletion by disabling that option. Proper fix will be in an upcoming release of SSMS.
  • Object Explorer: fixed an issue where "Databases" node was not expanded when connected to an Azure database created using "AS COPY"

download SSMS 17.0

Generally available | Build number: 14.0.17099.0

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

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

download SSMS 16.5.3

Generally available | Build number: 13.0.16106.4

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

The following issues were fixed this release:

  • Fixed an issue introduced in SSMS 16.5.2 which was causing the expansion of the 'Table' node when the table had more than one sparse column.

  • Users can deploy SSIS packages containing OData Connection Manager which connect to a Microsoft Dynamics AX/CRM Online resource to SSIS catalog. For more information, see OData Connection Manager.

  • Configuring Always Encrypted on an existing table fails with errors on unrelated objects. Connect ID 3103181

  • Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect ID 3109591

  • The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect ID 3111925

  • When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.

  • Open recent menu doesn't show recently saved files. Connect ID 3113288

  • SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection). Connect ID 3114074

  • Fixed an issue with the SQL Designer scrollbar. Connect ID 3114856

  • Context menu for tables momentarily hangs

  • SSMS occasionally throws exceptions in Activity Monitor and crashes. Connect ID 697527

  • SSMS 2016 crashes with error "The process was terminated due to an internal error in the .NET Runtime at IP 71AF8579 (71AE0000) with exit code 80131506"

SSMS 16.5.1

Generally available | Build number: 13.0.16100.1

  • Fixed an issue where Invoke-Sqlcmd erroneously inserts multiple rows when check constraint occurs. Microsoft Connect Item: 811560

  • Fixed an issue where non-ENU language versions do not work completely when creating Availability Groups.

  • Fixed an issue where clicking query plan XML does not open the proper SSMS UI.

download SSMS 16.5

Generally available | Build number: 13.0.16000.28

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

  • Fixed an issue where a crash could occur when a database with table name containing “;:” was clicked on.
  • Fixed an issue where changes made to the Model page in AS Tabular Database Properties window would script out the original definition. Microsoft Connect Item: 3080744
  • Fixed the issue that temporary files are added to the “Recent Files” list.
    Microsoft Connect Item: 2558789
  • Fixed the issue that “Manage Compression” menu item is disabled for the user table nodes in object explorer tree.
    Microsoft Connect Item: 3104616

  • Fixed the issue that user is not able to set the font size for object explorer, registered server explorer, template explorer as well as object explorer details. Font for the explorers will be using the Environment font.
    Microsoft Connect Item: 691432

  • Fixed the issue that SSMS always reconnect to the default database when connection is lost.
    Microsoft Connect Item: 3102337

  • Fixed many of high dpi issues in policy management and query editor window including the execution plan icons.

  • Fixed the issue that option to config font and color for Extended Event is missing.

  • Fixed the issue of SSMS crashes that occur when closing the application or when it is trying to show the error dialog.

download SSMS 16.4.1 (September 2016)

Generally available | Build number: 13.0.15900.1

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

download SSMS 16.3 (August 2016)

Generally available | Version number: 13.0.15700.28

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish


download SSMS July 2016 hotfix update

Generally available | Version number: 13.0.15600.2

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish


SSMS July 2016 (install the July 2016 hotfix)

Generally available | Version number: 13.0.15500.91

  • Edit, July 5: Improved support for SQL Server 2016 (1200 compatibility level) tabular databases in the Analysis Services Process dialog and the Analysis Services deployment wizard.

  • Edit, July 5: New option in SSMS 'query execution options' dialog to set 'XACT_ABORT'. This option is enabled by default in this release of SSMS and instructs SQL Server to roll back the entire transaction and abort the batch if a run-time error occurs.

  • Support for Azure SQL Data Warehouse in SSMS.

  • Significant updates to the SQL Server PowerShell module. This includes a new SQL PowerShell module and new CMDLETs for Always Encrypted, SQL Agent, and SQL Error Logs.

  • Support for PowerShell script generation in the Always Encrypted wizard.

  • Significantly improved connection times to Azure SQL databases.

  • New "Backup to URL" dialog to support the creation of Azure storage credentials for SQL Server 2016 database backups. This dialog provides a more streamlined experience for storing database backups in an Azure storage account.

  • New Restore dialog to streamline restoring a SQL Server 2016 database backup from the Microsoft Azure storage service.

  • Bug fix in SSMS query designer to allow adding tables to the designer if a user doesn’t have SELECT permissions on them.

  • Bug fix to add IntelliSense support for 'TRY_CAST()', and 'TRY_CONVERT()' functions.
    Linked customer bug requests:
    Microsoft Connect item #2453461.

  • Bug fix in PowerShell module to enable loading of ‘SQLAS’ Analysis Services extension.
    Linked customer bug requests:
    Microsoft Connect item #2544902.

  • Bug fix in the SSMS editor window to allow drag-and-drop open of Sql files.
    Linked customer bug requests:
    Microsoft Connect item #2690658.

  • Bug fix in Profiler to fix Profiler crash when exiting.
    Linked customer bug requests:
    Microsoft Connect item #2616550.
    Microsoft Connect item #2319968.

  • Bug fix in SSMS to prevent crash when trying to edit a join link in the SSMS table designer.
    Linked customer bug requests:
    Microsoft Connect item #2721052.

  • Bug fix in SSMS to enable database script generation for db_owner role members.
    Linked customer bug requests:
    Microsoft Connect item #2869241.

  • Bug fix in SSMS editor to remove the delay in closing a query tab if the server has gone offline.
    Linked customer bug requests:
    Microsoft Connect item #2656058.

  • Bug fix to enable Backup option in SQL Server Express databases. Linked customer bug requests:
    Microsoft Connect item #2801910.
    Microsoft Connect item #2874434.

  • Bug fix in Analysis Services to correctly show the Data Feed provider for multi-dimensional Analysis Services models.


download SSMS June 2016

Generally available | Version number: 13.0.15000.23

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Additional Downloads

For a list of all SQL Server Management Studio downloads, search the Microsoft Download Center.

For the latest release of SQL Server Management Studio, see Download SQL Server Management Studio (SSMS).