SQL Server Management Studio is an integrated environment for managing your SQL Server infrastructure and Azure SQL Database. Management Studio provides tools to configure, monitor, and administer instances of SQL Server. It also provides tools to deploy, monitor, and upgrade the data-tier components, such as databases and data warehouses used by your applications, and to build queries and scripts.
- SSMS Tips
- SSMS Addins
- SSMS Snippets
- SSMS Shortcuts
- Download SQL Server Management Studio (SSMS)
- SQL Server Management Studio - Changelog (SSMS)
- SQL Server Management Studio (SSMS) - Release Candidate
- Previous SQL Server Management Studio Releases
- SQLSentry Latest Builds of Management Studio
- SQL Server Tools
- SQL Server Management Studio (SSMS)
- Microsoft Download Center SSMS
- MSDN Code Snippets Schema Reference
- MSDN Add Transact-SQL Snippets
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.
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 2016
- Windows Server 2012 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2008 R2 (64-bit)
SSMS 17.X 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.
SQL Server Management Studio for another languages:
- Chinese (People's Republic of China)
- Chinese (Taiwan)
- English (United States)
- French
- German
- Italian
- Japanese
- Korean
- Portuguese (Brazil)
- Russian
- Spanish
SQL Server Management Studio 17.3 Upgrade Package (upgrades 17.x to 17.3):
- Chinese (People's Republic of China)
- Chinese (Taiwan)
- English (United States)
- French
- German
- Italian
- Japanese
- Korean
- Portuguese (Brazil)
- Russian
- Spanish
| Version/Download Link | Build | Release Date | Size, Mb |
|---|---|---|---|
| 17.4 Release Latest | 14.0.17213.0 | 2017-12-07 | 802 |
| 17.3 Release | 14.0.17199.0 | 2017-10-09 | 801 |
| 17.2 Release | 14.0.17177.0 | 2017-08-07 | 819 |
| 17.1 Release | 14.0.17119.0 | 2017-05-24 | 784 |
| 17.0 Release | 14.0.17099.0 | 2017-04-25 | 729 |
| 17.0 RC3 Release | 14.0.17028.0 | 2017-03-09 | 677 |
| 17.0 RC2 Release | 14.0.16150.0 | 2017-02-01 | 682 |
| 17.0 RC1 Release | 14.0.16000.64 | 2016-11-16 | 687 |
| 16.5.3 Release | 13.0.16106.4 | 2017-01-26 | 898 |
| 16.5.2 Release Deprecated | 13.0.16105.4 | 2017-01-18 | 898 |
| 16.5.1 Release | 13.0.16100.1 | 2016-12-05 | 894 |
| 16.5 Release | 13.0.16000.28 | 2016-10-26 | 894 |
| 16.4.1 Release | 13.0.15900.1 | 2016-09-23 | 894 |
| 16.4 Release Deprecated | 13.0.15800.18 | 2016-09-20 | |
| 16.3 Release | 13.0.15700.28 | 2016-08-15 | 806 |
| July 2016 Hotfix Update | 13.0.15600.2 | 2016-07-13 | 825 |
| July 2016 Release Deprecated | 13.0.15500.91 | 2016-07-01 | |
| June 2016 Release | 13.0.15000.23 | 2016-06-01 | 825 |
| SQL Server 2014 SP1 | 12.0.4100.1 | 2015-05-14 | 815 |
| SQL Server 2012 SP3 | 11.0.6020.0 | 2015-11-21 | 964 |
| SQL Server 2008 R2 | 10.50.4000 | 2012-07-02 | 161 |