Download SQL Server Management Studio (SSMS)

 

Updated: December 5, 2016

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 Download SQL Server Management Studio (SSMS)
Download SQL Server Management Studio (16.5.1)Current GA release for production use.
Download SQL Server Management Studio (17.0 RC1)Includes support for SQL Server vNext CTP1, and works side-by-side with 16.x, but not recommended for production use.
System_CAPS_ICON_note.jpg Note

  • SSMS releases are now branded numerically, not by months.
  • This generally available release of SSMS is free and does not require a SQL Server license to install and use.

Version Information

The release number: 16.5.1
The build number for this release: 13.0.16100.1

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)

Available Languages

System_CAPS_ICON_note.jpg Note


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

16.5.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.

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.

Previous SQL Server Management Studio Releases

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

Tutorial: SQL Server Management Studio
SQL Server Management Studio documentation
Microsoft SQL Server
Additional updates and service packs
Download SQL Server Data Tools (SSDT)

Show: