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.
|Download SQL Server Management Studio (SSMS)|
|Download SQL Server Management Studio (16.5.3)||Current release for production use.|
|Download SQL Server Management Studio - Release Candidate (17.0 RC3)||Includes support for SQL Server vNext CTP1.3, and works side-by-side with 16.x, but not recommended for production use.|
SSMS releases are now branded numerically, not by months. SSMS is free! It does not require a license to install and use.
SQL Server Management Studio
The release number: 16.5.3
The build number for this release: 13.0.16106.4
Supported SQL Server versions
- This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2016), 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, one SSMS 16.x release or SSMS 2016 can be installed side by side with previous versions of SSMS 2014 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)
Non-English localized releases of SSMS require the KB 2862966 security update package if installing on: Windows 8, Windows 7, Windows Server 2012, and Windows Server 2008 R2.
This release of SSMS can be installed in the following languages:
Chinese (People's Republic of China) | Chinese (Taiwan) | 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"
For the full list of features, see
SQL Server Management Studio - Changelog (SSMS)
To see the list of known issues and work arounds, see
SQL Server Management Studio - Release Notes
For information about user data collection, see
SQL Server Privacy Statement.