Среда SQL Server Management Studio — это интегрированная среда для управления инфраструктурой SQL Server и базы данных SQL Azure.
Среда Management Studio предоставляет средства для настройки, наблюдения и администрирования экземпляров SQL Server.
Она также предоставляет средства для развертывания, отслеживания и обновления данных-уровня компонентов, таких как базы данных и хранилищ данных, используется приложениями, а также для создания запросов и скриптов.
- 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
- Add Transact-SQL Snippets
Поддерживаемые версии SQL Server
- Эта версия SSMS работает со всеми поддерживаемыми версиями SQL Server (SQL Server 2008–SQL Server 2017) и предоставляет превосходную поддержку новейших облачных функций базы данных SQL Azure и хранилища данных SQL Azure.
- SQL Server 2000 или SQL Server 2005 напрямую не блокируются, однако некоторые функции могут работать неправильно.
- Кроме того, SSMS 17.X можно установить одновременно с SSMS 16.X или SQL Server 2014 SSMS и более ранними версиями.
Поддерживаемые операционные системы
При использовании последнего пакета обновления этот выпуск SSMS поддерживает следующие платформы: 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 основана на изолированной оболочке Visual Studio 2015, которая была выпущена до Windows Server 2016.
Корпорация Майкрософт уделяет большое внимание совместимости приложений и гарантирует, что уже выпущенные приложения продолжат работать в последних выпусках Windows. Чтобы минимизировать проблемы с запуском SSMS в Windows Server 2016, убедитесь, что для SSMS установлены все последние обновления.
При возникновении каких-либо проблем с SSMS в Windows Server 2016, обратитесь в службу поддержки. Служба поддержки определит, связана ли проблема с SSMS, с Visual Studio или с совместимостью SSMS и Windows.
Затем ваш запрос будет перенаправлен соответствующей группе для дальнейшего изучения.
Доступные языки
SQL Server Management Studio для других языков:
Chinese (People’s Republic of China) |
Chinese (Taiwan) |
English (United States) |
French |
German |
Italian |
Japanese |
Korean |
Portuguese (Brazil) |
Russian |
Spanish
Ссылки для загрузки и информация о релизах SSMS
- GA — Стабильная версия
- PP — Предварительная версия
- Размер в мегабайтах для Английской версии
| Версия/Ссылка для загрузки | Примечание | Билд | Дата релиза | Размер, Мб |
|---|---|---|---|---|
| 18.9.2 GA Release | Latest GA | 15.0.18386.0 | 2021-07-15 | 642 |
| 18.9.1 GA Release | 15.0.18384.0 | 2021-04-20 | 635 | |
| 18.9 GA Release | 15.0.18382.0 | 2021-04-15 | 635 | |
| 18.8 GA Release | 15.0.18369.0 | 2020-12-17 | 640 | |
| 18.7.1 GA Release | 15.0.18358.0 | 2020-10-27 | 635 | |
| 18.7 GA Release | 15.0.18357.0 | 2020-10-20 | 635 | |
| 18.6 GA Release | 15.0.18338.0 | 2020-07-22 | 534 | |
| 18.5.1 GA Release | 15.0.18333.0 | 2020-06-09 | 535 | |
| 18.5 GA Release | 15.0.18183.0 | 2020-04-07 | 535 | |
| 18.4 GA Release | 15.0.18206.0 | 2019-11-04 | 539 | |
| 18.3.1 GA Release | 15.0.18183.0 | 2019-10-02 | 534 | |
| 18.3 GA Release | 15.0.18178.0 | 2019-09-23 | 534 | |
| 18.2 GA Release | 15.0.18142.0 | 2019-07-25 | 528 | |
| 18.1 GA Release | 15.0.18131.0 | 2019-06-11 | 527 | |
| 18.0 GA Release | 15.0.18118.0 | 2019-04-24 | 524 | |
| 18.0 RC1 Release | 15.0.18098.0 | 2019-03-28 | 484 | |
| 18.0 Preview 7 Release | 15.0.18092.0 | 2019-03-01 | 478 | |
| 18.0 Preview 6 Release | 15.0.18075.0 | 2018-12-18 | 457 | |
| 18.0 Preview 5 Release | 15.0.18068.0 | 2018-11-15 | 457 | |
| 18.0 Preview 4 Release | 15.0.18040.0 | 2018-09-24 | 456 | |
| 17.9.1 Release | Latest 17 | 14.0.17289.0 | 2018-11-21 | 807 |
| 17.9 Release | 14.0.17285.0 | 2018-09-04 | 807 | |
| 17.8.1 Release | 14.0.17277.0 | 2018-06-26 | 806 | |
| 17.8 Release | Deprecated | 14.0.17276.0 | 2018-06-21 | 806 |
| 17.7 Release | 14.0.17254.0 | 2018-05-09 | 803 | |
| 17.6 Release | 14.0.17230.0 | 2018-03-20 | 802 | |
| 17.5 Release | 14.0.17224.0 | 2018-02-15 | 802 | |
| 17.4 Release | 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 | Latest 16 | 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 |
SQL Server 2014 RTM Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86
SQL Server 2012 SP1 Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86
SQL Server 2008 R2 Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86
Microsoft SQL Server Management Studio (SSMS) is an all-in-one place for you to go if you want to manage your databases. SSMS gives you a graphical interface so you can manage your SQL databases from a local SQL server to an on-cloud database stack.
The SQL Server Management Studio can be used to deploy, monitor, and upgrade existing SQL databases. Some might even consider it an all-in-one solution.
This article gives you direct download links for all available SSMS versions that you can use to meet your requirements. But before we begin, let us give you a little insight into the different requirements and prerequisites.
Table of contents
- What is SQL Server Management Studio
- SQL Server Management Studio System Requirements
- SQL Server Management Studio Download Links
- How to Install SQL Server Management Studio
- SQL Server Management Studio Available Languages
- Uninstall SQL Server Management Studio
- FAQs
- Is SQL Server the same as SSMS?
- Can I use SSMS without SQL Server?
As mentioned above, SQL Server Management Studio, or SSMS, is an integrated management environment for a SQL Server architecture. It offers a user interface, a set of tools, and sophisticated script editors that communicate with SQL Server.
The user-friendly interface and convenient manageability of the SSMS make it easier for the developers to manage the many SQL databases, perform maintenance works, and access them when required.
SQL Server Management Studio System Requirements
Before you begin installing SSMS on your device, you’ll need to meet these minimum hardware requirements:
- Processor: 1.8 GHz or faster x86 (Intel, AMD) processor
- RAM: 2GB (2.5GB if running on a virtual machine)
- Storage: Minimum of 2 GB (Can go up to 10 GB depending upon installed features)
Apart from the hardware requirements, you also need to ensure that you have the right operating system. The following operating systems are currently supported:
- Windows Server 2022 (64-bit)
- Windows 11 (64-bit)
- Windows 10 (64-bit) version 1607 (10.0.14393) or later
- Windows 8.1 (64-bit)
- Windows Server 2019 (64-bit)
- Windows Server 2016 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2012 (64-bit)
- Windows Server 2008 R2 (64-bit)
Download all versions of Windows Server.
SQL Server Management Studio Download Links
Here’s the list of the latest builds of SQL Server Management Studio. Click the Download button to immediately begin downloading the tool.
| Version | Latest version | Release | Download link |
|---|---|---|---|
| SQL Server Management Studio 18 | 18.1 (Build 15.0.18390.0) | 2019 | Download |
| SQL Server Management Studio 17 | 17.9.1 (Build 14.0.17289.0) | 2017 | Download |
| SQL Server Management Studio 16 | 16.5.3 (Build 13.0.16106.4) | 2016 | Download |
| SQL Server Management Studio 14 | 2014 SP3 (Build 12.0.6024.0) | 2014 | Download |
| SQL Server Management Studio 12 | 2012 SP4 (Build 11.0.7001.0) | 2012 | Download |
| SQL Server Management Studio 2008 R2 | 2008 R2 SP2 (Build 10.50.4000.0) | 2010 | Download |
| SQL Server Management Studio 2008 | 2008 | 2008 | Download |
| SQL Server Management Studio 2005 | 2005 | 2005 | Download |
You can also download a specific version if you don’t want the latest build of SSMS:
| Version | Build | Download link | Release date |
|---|---|---|---|
| 18.10 | 15.0.18390.0 | SQL Server Management Studio (SSMS) 18.10 | 5 Oct 2021 |
| 18.9.2 | 15.0.18386.0 | SQL Server Management Studio (SSMS) 18.9.2 | 15 Jul 2021 |
| 18.9.1 | 15.0.18384.0 | SQL Server Management Studio (SSMS) 18.9.1 | 20 Apr 2021 |
| 18.9 | 15.0.18382.0 | SQL Server Management Studio (SSMS) 18.9 | 15 Apr 2021 |
| 18.8 | 15.0.18369.0 | SQL Server Management Studio (SSMS) 18.8 | 17 Dec 2020 |
| 18.7.1 | 15.0.18358.0 | SQL Server Management Studio (SSMS) 18.7.1 | 27 Oct 2020 |
| 18.7 | 15.0.18357.0 | SQL Server Management Studio (SSMS) 18.7 | 20 Oct 2020 |
| 18.6 | 15.0.18338.0 | SQL Server Management Studio (SSMS) 18.6 | 22 Jul 2020 |
| 18.5.1 | 15.0.18333.0 | SQL Server Management Studio (SSMS) 18.5.1 | 9 Jun 2020 |
| 18.5 | 15.0.18330.0 | SQL Server Management Studio (SSMS) 18.5 | 7 Apr 2020 |
| 18.4 | 15.0.18206.0 | SQL Server Management Studio (SSMS) 18.4 | 4 Nov 2019 |
| 18.3.1 | 15.0.18183.0 | SQL Server Management Studio (SSMS) 18.3.1 | 2 Oct 2019 |
| 18.2 | 15.0.18142.0 | SQL Server Management Studio (SSMS) 18.2 | 25 Jul 2019 |
| 18.1 | 15.0.18131.0 | SQL Server Management Studio (SSMS) 18.1 | 11 Jun 2019 |
| 18.0 | 15.0.18118.0 | SQL Server Management Studio (SSMS) 18.0 | 24 Apr 2019 |
| 17.9.1 | 14.0.17289.0 | SQL Server Management Studio (SSMS) 17.9.1 | 21 Nov 2018 |
| 17.9 | 14.0.17285.0 | SQL Server Management Studio (SSMS) 17.9 | 4 Sep 2018 |
| 17.8.1 | 14.0.17277.0 | SQL Server Management Studio (SSMS) 17.8.1 | 26 Ju 2018 |
| 17.7 | 14.0.17254.0 | SQL Server Management Studio (SSMS) 17.7 | 9 May 2018 |
| 17.6 | 14.0.17230.0 | SQL Server Management Studio (SSMS) 17.6 | 20 Mar 2018 |
| 17.5 | 14.0.17224.0 | SQL Server Management Studio (SSMS) 17.5 | 15 Feb 2018 |
| 17.4 | 14.0.17213.0 | SQL Server Management Studio (SSMS) 17.4 | 7 Dec 2017 |
| 17.3 | 14.0.17199.0 | SQL Server Management Studio (SSMS) 17.3 | 9 Oct 2017 |
| 17.2 | 14.0.17177.0 | SQL Server Management Studio (SSMS) 17.2 | 7 Aug 2017 |
| 17.1 | 14.0.17119.0 | SQL Server Management Studio (SSMS) 17.1 | 27 Jun 2017 |
| 17.0 | 14.0.17099.0 | SQL Server Management Studio (SSMS) 17.0 | 25 Apr 2017 |
| 16.5.3 | 13.0.16106.4 | SQL Server Management Studio (SSMS) 16.5.3 | 30 Jan 2017 |
| 16.5.1 | 13.0.16100.1 | SQL Server Management Studio (SSMS) 16.5.1 | 5 Dec 2016 |
| 16.5 | 13.0.16000.28 | SQL Server Management Studio (SSMS) 16.5 | 26 Oct 2016 |
| 16.4.1 | 13.0.15900.1 | SQL Server Management Studio (SSMS) 16.4.1 | 23 Sep 2016 |
| 16.3 | 13.0.15700.28 | SQL Server Management Studio (SSMS) 16.3 | 20 Aug 2016 |
There have also been preview releases for some of these versions that have not been mentioned in the table above.
To download any SSMS version in any other language, please visit Microsoft’s Release Notes page for direct download links.
How to Install SQL Server Management Studio
Once you have downloaded the SSMS, here is how to install it:
-
Download the setup file for the SSMS version from the given links above.
-
Run the downloaded file.
The installation wizard will then run.
-
Click Install.
Begin SQL Server Management Studio installation SSMS will now begin installing on your PC. The process should take about 5 minutes but can vary depending on your system’s specifications.
-
Once installed, click Close.
Close the installation wizard
You can now launch SSMS by searching for it through the Windows Search bar and begin using it.
SQL Server Management Studio Available Languages
SSMS can be downloaded and installed in the following languages:
- English (US)
- Chinese (Simplified)
- Chinese (Traditional)
- French
- German
- Italian
- Japanese
- Korean
- Portuguese (Brazil)
- Russian
- Spanish
Uninstall SQL Server Management Studio
If you ever want to uninstall the SSMS, here is how to do it:
-
Run the downloaded setup file for SSMS previously used for installation.
If you don’t already have it, you can download the setup file from the direct download links shared above.
-
Click Uninstall from the wizard.
Uninstall SSMS The wizard will then remove SSMS from your device.
-
Click Close when it is finished.
Close the uninstallation wizard
FAQs
Is SQL Server the same as SSMS?
SQL Server Management Studio (SSMS) is a tool that allows you to create and manage SQL databases, whereas an SQL Server is a database designed to manage and store information. SSMS is included in Microsoft SQL Servers.
Can I use SSMS without SQL Server?
Yes, you can use SQL Server Management Studio without the server itself. This way you can manage and control on-premises SQL databases as well as on-cloud databases.
Also see:
Subhan Zafar is an established IT professional with interests in Windows and Server infrastructure testing and research, and is currently working with Itechtics as a research consultant. He has studied Electrical Engineering and is also certified by Huawei (HCNA & HCNP Routing and Switching).
Each software is released under license type that can be found on program pages as well as on search or category pages. Here are the most common license types:
Freeware
Freeware programs can be downloaded used free of charge and without any time limitations. Freeware products can be used free of charge for both personal and professional (commercial use).
Open Source
Open Source software is software with source code that anyone can inspect, modify or enhance. Programs released under this license can be used at no cost for both personal and commercial purposes. There are many different open source licenses but they all must comply with the Open Source Definition — in brief: the software can be freely used, modified and shared.
Free to Play
This license is commonly used for video games and it allows users to download and play the game for free. Basically, a product is offered Free to Play (Freemium) and the user can decide if he wants to pay the money (Premium) for additional features, services, virtual or physical goods that expand the functionality of the game. In some cases, ads may be show to the users.
Demo
Demo programs have a limited functionality for free, but charge for an advanced set of features or for the removal of advertisements from the program’s interfaces. In some cases, all the functionality is disabled until the license is purchased. Demos are usually not time-limited (like Trial software) but the functionality is limited.
Trial
Trial software allows the user to evaluate the software for a limited amount of time. After that trial period (usually 15 to 90 days) the user can decide whether to buy the software or not. Even though, most trial software products are only time-limited some also have feature limitations.
Paid
Usually commercial software or games are produced for sale or to serve a commercial purpose.
Файлы продукта SQL Management Studio for MySQL
| Название | Версия | Дата | Размер | Ссылка |
|---|---|---|---|---|
| SQL Management Studio for MySQL (полный инсталляционный пакет) | 1.3.0 | 2022-02-24 | 181.75 Mb | Скачать |
| Руководство Пользователя (en, pdf) | 1.55 Mb | Скачать | ||
| Руководство Пользователя (ru, pdf) | 3.32 Mb | Скачать | ||
| Техническое описание (en, pdf) | 1.01 Mb | Скачать | ||
| Техническое описание (de, pdf) | 147.74 Kb | Скачать | ||
| Техническое описание (fr, pdf) | 146.56 Kb | Скачать | ||
| Техническое описание (ru, pdf) | 191.83 Kb | Скачать |
This how-to guide explains how to download and install Microsoft SQL Server Management Studio or SSMS. The latest version of SSMS is now 18.2. You can use this connect to the SQL Server versions 2019, 2017, 2016, 2014, 2008 & 2008 R2
Table of Contents
- What is SQL Server Management Studio (SSMS)
- Download SQL Server Management Studio
- Direct Download links
- Official Download Page
- System Requirements
- Supported SQL Server Editions
- Supported OS
- Install SQL Server Management Studio
- Select Install Location
- Installation Begins
- Installation in Progress
- Installation Complete
- References
- Summary
SQL Server Management Studio (SSMS) is a GUI tool, which helps us to manage our SQL Server Installations. You can use this tool to design and manage the database and query its data. You can use this to manage the database, which is located in your PC or somewhere in the cloud.
Using SSMS 18.2, you can not only manage the SQL Server 2017, but the previous versions of the SQL Server starting from 2008. The list of supported versions is mentioned below.
Download SQL Server Management Studio
The latest version is available for download from the following link. The Current Version is 18.5
Direct Download links
| Edition | Build/Version No |
Applicable to | |
|---|---|---|---|
| SQL Server Management Studio 18 | Version 18.5 Build No. 15.0.18330.0 |
SQL SERVER 2008, 2008R2 to 2019 | Download |
| SQL Server Management Studio 17 | Version 17.9.1 Build No. 14.0.17289.0 |
SQL SERVER 2008, 2008R2 to 2019 | Download |
| SQL Server Management Studio 16 | Version 16.5.3 Build No. 13.0.16106.4 |
SQL SERVER 2008, 2008R2 to 2019 | Download |
Official Download Page
Click the following page to go to Microsoft Official Download link.
System Requirements
The SSMS can be used to connect to the older versions of SQL Server. The following are supported. Also, scroll down to find the list of Supported OS
Supported SQL Server Editions
| SQL Server Edition | Version No |
| SQL Server 2008 | 10.0 |
| SQL Server 2008 R2 | 10.5 |
| SQL Server 2012 | 11.0 |
| SQL Server 2014 | 12.0 |
| SQL Server 2016 | 13.0 |
| SQL Server 2017 | 14.0 |
| SQL Server 2019 Preview |
Supported OS
- Windows 10 (64-bit) *
- Windows 8.1 (64-bit)
- Windows Server 2019 (64-bit)
- Windows Server 2016 (64-bit) *
- Windows Server 2012 R2 (64-bit)
- Windows Server 2012 (64-bit)
- Windows Server 2008 R2 (64-bit)
Install SQL Server Management Studio
Download from the link given above and double click on the downloaded file to start the installation.
Select Install Location
Say yes, when prompted for “Do you want to allow the following to make a change this computer? “. You will be taken to the Welcome screen.
You can change the installation location if you wish to. Click on the Install button to continue
Installation Begins
Installation in Progress
The installation will take time as it downloads the required packages from the internet.
Installation Complete
Installation completes. You may be asked to restart the PC.
References
- Release notes
Summary
In this tutorial, we learned how to install the SQL Server Management Studio. In the next article learn how to connect to the SQL Server using SSMS.
Всем привет! В этом материале, специально для начинающих, подробно рассмотрен процесс установки среды SQL Server Management Studio (SSMS) на операционную систему Windows 10.
Заметка! Обзор инструментов для работы с Microsoft SQL Server.
Содержание
- Что такое SQL Server Management Studio
- Где скачать SQL Server Management Studio
- Системные требования для установки SSMS
- Описание процесса установки SQL Server Management Studio
- Запуск установки SSMS
- Завершение установки SSMS
- Подключение к Microsoft SQL Server с помощью SSMS
- Удаление SQL Server Management Studio
SQL Server Management Studio (SSMS) – это бесплатная графическая среда, включающая набор инструментов для разработки сценариев на T-SQL и управления инфраструктурой Microsoft SQL Server.
Среда SQL Server Management Studio – это основной, стандартный и полнофункциональный инструмент для работы с Microsoft SQL Server, разработанный компанией Microsoft, который предназначен как для разработчиков, так и для администраторов SQL Server.
С помощью SSMS Вы можете разрабатывать базы данных, выполнять инструкции T-SQL, а также администрировать Microsoft SQL Server.
Подробно функционал и возможности SQL Server Management Studio были рассмотрены в отдельном материале – Обзор SQL Server Management Studio.
Где скачать SQL Server Management Studio
Скачать актуальную версию среды SQL Server Management Studio можно на странице загрузки официального сайта Microsoft, вот эта страница
Страница загрузки SQL Server Management Studio.
После перехода на страницу необходимо в разделе «Скачать SSMS» нажать на ссылку «Скачать SQL Server Management Studio (SSMS)».
В итоге у Вас должен загрузиться установочный файл SSMS-Setup-RUS.exe размером около 600 мегабайт.
Кроме этого в программе «Центр установки SQL Server» в разделе «Установка», если нажать на пункт «Установка средства управления SQL Server», то у Вас в браузере откроется ровно та же самая страница, которая указана чуть выше.
Актуальная версия SQL Server Management Studio поддерживает работу со всеми версиями Microsoft SQL Server начиная с 2008 версии, а также предоставляет поддержку облачных функций баз данных SQL Azure.
Заметка! Установка Microsoft SQL Server 2019 в редакции Express.
Системные требования для установки SSMS
SQL Server Management Studio можно установить не на все версии Windows, при этом поддерживается установка только на 64-разрядные версии.
Windows 8.1
Windows 10
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Кроме этого к оборудованию компьютера также предъявляются определенные требования.
Процессор с тактовой частотой не ниже 1,8 ГГц.
Рекомендуется как минимум двухъядерный процессор
Оперативной памяти как минимум 2 ГБ, рекомендовано 4 ГБ
Свободного места на жестком диске от 2 до 10 ГБ
Описание процесса установки SQL Server Management Studio
Давайте перейдем к процессу установки SQL Server Management Studio, он достаточно простой, но мы все равно рассмотрим все шаги, которые необходимо выполнить, чтобы установить SSMS на операционную систему Windows 10.
Примечание! Процесс установки SSMS на другие версии Windows ничем не отличается.
Запуск установки SSMS
После того как установщик мы скачали, нам необходимо его запустить. В результате запустится программа, где нам нужно нажать на кнопку «Установить».
В случае необходимости Вы можете изменить каталог, в который будет установлена среда SQL Server Management Studio.
Заметка! Ошибка «Сохранение изменений запрещено» в среде SSMS. Причины и способы устранения.
Процесс установки сразу же начнётся.
Завершение установки SSMS
Процесс установки среды SQL Server Management Studio будет завершен, когда программа выдаст соответствующее сообщение.
Нажимаем «Закрыть».
Среда SQL Server Management Studio установлена, больше никаких дополнительных действий, связанных с установкой, выполнять не требуется.
Заметка! Сравнение Azure Data Studio с SQL Server Management Studio (SSMS).
Подключение к Microsoft SQL Server с помощью SSMS
После установки SQL Server Management Studio в меню «Пуск» в разделе «Microsoft SQL Server Tools» будет ярлык на запуск среды.
Чтобы подключиться к Microsoft SQL Server, запускаем среду SSMS и в окне «Соединение с сервером» вводим данные для подключения.
Заметка! Не удается подключиться к Microsoft SQL Server по сети.
Удаление SQL Server Management Studio
Удалить SQL Server Management Studio можно точно так же, как и любую другую программу в Windows, например, используя функционал в разделе «Приложения» в параметрах Windows 10.
Стоит отметить, что в случае удаления SQL Server Management Studio некоторые компоненты, которые требуются для работы SSMS и которые, вполне возможно, устанавливались в процессе установки среды, удалены не будут, так как они могут использоваться другими приложениями, т.е. являются общими.
К ним относятся:
- Microsoft .NET Framework
- Драйвер Microsoft OLE DB для SQL Server
- Microsoft ODBC Driver for SQL Server
- Распространяемый компонент Microsoft Visual C++
- Microsoft Visual Studio Tools for Applications
Заметка! Если Вас интересует язык SQL, то рекомендую почитать книгу «SQL код» – это самоучитель по языку SQL для начинающих программистов. В ней язык SQL рассматривается как стандарт, чтобы после прочтения данной книги можно было работать с языком SQL в любой системе управления базами данных.
На сегодня это все, надеюсь, материал был Вам полезен, пока!
Microsoft SQL Server Management Studio (SSMS or S.S.M.S.) is the integrated environment for managing your SQL Server infrastructure. SQL Server Management Studio presents a graphical interface for configuring, monitoring, and administering instances of SQL Server. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. SQL Server Management Studio also provides Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Management Studio is a completely standalone product, not tied to any specific version or edition of SQL Server, and no longer requires licensing of any kind.
Quick Summary:
| Version | Alternative names | Build number | Release year | Download latest |
|---|---|---|---|---|
| SQL Server Management Studio 19 | SSMS 19 SSMS19 SSMS 2019 SSMS2019 SSMS 19.x |
19.0.x.x | 2023 | Direct download 19.0 |
| SQL Server Management Studio 18 | SSMS 18 SSMS18 SSMS 2018 SSMS2018 SSMS 18.x |
15.0.x.x | 2019 | Direct download 18.12.1 |
| SQL Server Management Studio 17 | SSMS 17 SSMS17 SSMS 2017 SSMS2017 SSMS 17.x |
14.0.x.x | 2017 | Direct download 17.9.1 |
| SQL Server Management Studio 16 | SSMS 16 SSMS16 SSMS 2016 SSMS2016 SSMS 16.x |
13.0.x.x | 2016 | Direct download 16.5.3 |
| Not standalone (integral part of SQL Server): | ||||
| SQL Server Management Studio 2014 | SSMS 2014 SSMS2014 SSMS 12 SSMS12 SSMS 12.x |
12.0.x.x | 2014 | Download 2014 |
| SQL Server Management Studio 2012 | SSMS 2012 SSMS2012 SSMS 11 SSMS11 SSMS 11.x |
11.0.x.x | 2012 | Download 2012 |
| SQL Server Management Studio 2008 R2 | SSMS 2008 R2 SSMS2008R2 SSMS 10.5 SSMS10.50 |
10.50.x.x | 2010 | Download 2008 R2 |
| SQL Server Management Studio 2008 | SSMS 2008 SSMS2008 SSMS 10 SSMS10 SSMS 10.x |
10.0.x.x | 2008 | Download 2008 |
| SQL Server Management Studio 2005 | SSMS 2005 SSMS2005 SSMS 9 SSMS9 SSMS 9.x |
9.0.x.x | 2005 |
SSMS 18 can be installed side-by-side with SSMS 17 / 16 or SQL Server 2014 SSMS and earlier.
Build numbers:
| Version | Build | Description | Release date |
|---|---|---|---|
| 19.0 | 19.0.20196.0 | SQL Server Management Studio (SSMS) 19.0 Latest Direct download 19.0 | 2023-01-26 *new |
| 19.0 | 19.0.20179.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 4) Beta | 2022-12-15 |
| 19.0 | 16.0.19061.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 3) Beta | 2022-08-11 |
| 19.0 | 16.0.19056.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 2) Beta | 2022-05-24 |
| 18.12.1 | 15.0.18424.0 | SQL Server Management Studio (SSMS) 18.12.1 | 2022-06-21 |
| 18.12 | 15.0.18420.0 | SQL Server Management Studio (SSMS) 18.12 | 2022-06-09 |
| 18.11.1 | 15.0.18410.0 | SQL Server Management Studio (SSMS) 18.11.1 | 2022-03-08 |
| 18.11 | 15.0.18404.0 | SQL Server Management Studio (SSMS) 18.11 | 2022-02-24 |
| 18.10 | 15.0.18390.0 | SQL Server Management Studio (SSMS) 18.10 | 2021-10-05 |
| 18.9.2 | 15.0.18386.0 | SQL Server Management Studio (SSMS) 18.9.2 | 2021-07-15 |
| 18.9.1 | 15.0.18384.0 | SQL Server Management Studio (SSMS) 18.9.1 | 2021-04-20 |
| 18.9 | 15.0.18382.0 | SQL Server Management Studio (SSMS) 18.9 | 2021-04-15 |
| 18.8 | 15.0.18369.0 | SQL Server Management Studio (SSMS) 18.8 | 2020-12-17 |
| 18.7.1 | 15.0.18358.0 | SQL Server Management Studio (SSMS) 18.7.1 | 2020-10-27 |
| 18.7 | 15.0.18357.0 | SQL Server Management Studio (SSMS) 18.7 | 2020-10-20 |
| 18.6 | 15.0.18338.0 | SQL Server Management Studio (SSMS) 18.6 | 2020-07-22 |
| 18.5.1 | 15.0.18333.0 | SQL Server Management Studio (SSMS) 18.5.1 | 2020-06-09 |
| 18.5 | 15.0.18330.0 | SQL Server Management Studio (SSMS) 18.5 | 2020-04-07 |
| 18.4 | 15.0.18206.0 | SQL Server Management Studio (SSMS) 18.4 | 2019-11-04 |
| 18.3.1 | 15.0.18183.0 | SQL Server Management Studio (SSMS) 18.3.1 | 2019-10-02 |
| 18.3 | 15.0.18178.0 | SQL Server Management Studio (SSMS) 18.3 Withdrawn | 2019-09-23 |
| 18.2 | 15.0.18142.0 | SQL Server Management Studio (SSMS) 18.2 | 2019-07-25 |
| 18.1 | 15.0.18131.0 | SQL Server Management Studio (SSMS) 18.1 | 2019-06-11 |
| 18.0 | 15.0.18118.0 | SQL Server Management Studio (SSMS) 18.0 | 2019-04-24 |
| 18.0 | 15.0.18116.0 | SQL Server Management Studio (SSMS) 18.0 Private Beta | 2019-04-18 |
| 18.0 | 15.0.18098.0 | SQL Server Management Studio (SSMS) 18.0 Release Candidate 1 (RC1) Beta | 2019-03-28 |
| 18.0 | 15.0.18092.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 7) Beta | 2019-03-01 |
| 18.0 | 15.0.18075.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 6) Beta | 2018-12-18 |
| 18.0 | 15.0.18068.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 5) Beta | 2018-11-15 |
| 18.0 | 15.0.18040.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 4) Beta | 2018-09-24 |
| 17.9.1 | 14.0.17289.0 | SQL Server Management Studio (SSMS) 17.9.1 | 2018-11-21 |
| 17.9 | 14.0.17285.0 | SQL Server Management Studio (SSMS) 17.9 | 2018-09-04 |
| 17.8.1 | 14.0.17277.0 | SQL Server Management Studio (SSMS) 17.8.1 | 2018-06-26 |
| 17.8 | 14.0.17276.0 | SQL Server Management Studio (SSMS) 17.8 Withdrawn | 2018-06-21 |
| 17.7 | 14.0.17254.0 | SQL Server Management Studio (SSMS) 17.7 | 2018-05-09 |
| 17.6 | 14.0.17230.0 | SQL Server Management Studio (SSMS) 17.6 | 2018-03-20 |
| 17.5 | 14.0.17224.0 | SQL Server Management Studio (SSMS) 17.5 | 2018-02-15 |
| 17.4 | 14.0.17213.0 | SQL Server Management Studio (SSMS) 17.4 | 2017-12-07 |
| 17.3 | 14.0.17199.0 | SQL Server Management Studio (SSMS) 17.3 | 2017-10-09 |
| 17.2 | 14.0.17177.0 | SQL Server Management Studio (SSMS) 17.2 | 2017-08-07 |
| 17.1 | 14.0.17119.0 | SQL Server Management Studio (SSMS) 17.1 | 2017-06-27 |
| 17.0 | 14.0.17099.0 | SQL Server Management Studio (SSMS) 17.0 | 2017-04-25 |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 3 (RC3) | 2017-03-09 |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 2 (RC2) | 2017-01-30 |
| 17.0 | 14.0.16000.64 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 1 (RC1) | 2016-11-16 |
| 16.5.3 | 13.0.16106.4 | SQL Server Management Studio (SSMS) 16.5.3 | 2017-01-30 |
| 16.5.2 | 13.0.16105.4 | SQL Server Management Studio (SSMS) 16.5.2 Withdrawn | 2017-01-18 |
| 16.5.1 | 13.0.16100.1 | SQL Server Management Studio (SSMS) 16.5.1 | 2016-12-05 |
| 16.5 | 13.0.16000.28 | SQL Server Management Studio (SSMS) 16.5 | 2016-10-26 |
| 16.4.1 | 13.0.15900.1 | SQL Server Management Studio (SSMS) 16.4.1 | 2016-09-23 |
| 16.4 | 13.0.15800.18 | SQL Server Management Studio (SSMS) 16.4 Withdrawn | 2016-09-20 |
| 16.3 | 13.0.15700.28 | SQL Server Management Studio (SSMS) 16.3 | 2016-08-20 |
| 13.0.15600.2 | SQL Server Management Studio (SSMS) July 2016 Hotfix Update | 2016-07-13 | |
| 13.0.15500.91 | SQL Server Management Studio (SSMS) July 2016 Withdrawn | 2016-07-01 | |
| 13.0.15000.23 | SQL Server Management Studio (SSMS) June 2016 | 2016-06-01 | |
| 13.0.14000.36 | SQL Server Management Studio (SSMS) April 2016 Preview | 2016-04-15 | |
| 13.0.13000.55 | SQL Server Management Studio (SSMS) March 2016 Preview Refresh | 2016-04-01 | |
| 13.0.12500.29 | SQL Server Management Studio (SSMS) March 2016 Preview Withdrawn | 2016-03-18 | |
| 13.0.12000.65 | SQL Server Management Studio (SSMS) February 2016 Preview | 2016-03-07 | |
| 13.0.11000.78 | SQL Server Management Studio (SSMS) January 2016 Preview | 2016-02-03 | |
| 13.0.900.73 | SQL Server Management Studio (SSMS) December 2015 Preview | 2015-12-17 | |
| 13.0.800.111 | SQL Server Management Studio (SSMS) November 2015 Preview | 2015-11-30 | |
| 13.0.700.242 | SQL Server Management Studio (SSMS) October 2015 Preview | 2015-10-28 | |
| 13.0.600.65 | SQL Server Management Studio (SSMS) September 2015 Preview | 2015-09-30 | |
| 13.0.500.53 | SQL Server Management Studio (SSMS) August 2015 Preview | 2015-09-01 | |
| 13.0.400.91 | SQL Server Management Studio (SSMS) July 2015 Preview | 2015-07-22 | |
| 13.0.300.44 | SQL Server Management Studio (SSMS) June 2015 Preview | 2015-06-24 |
You can comment here. If you know of a SSMS version that we don’t have listed here, please use the comments.
I work on this site continuously and keep the information up to date. If it helps you, you can support me:
Buy me a coffee Support me in another way
© 2007–2023 SqlServerBuilds.blogspot.com · Contact · Privacy policy
Other useful sites › SQL Server Versions List ⁞ Exchange Server Versions List ⁞ SharePoint Servers Version List ⁞ Microsoft Knowledge Base Monitoring
SQL Server Management Studio
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 Guides
- 40 SSMS Tips (by Konstantin Taranov)
- 36 SSMS Addins (by Konstantin Taranov)
- SSMS Snippets
- SSMS Shortcuts (by Konstantin Taranov)
- A month of SSMS tips and tricks (by Wayne Sheffield)
- SSMS Tricks & Shortcuts (by George Squillace)
- SSMS Tricks and Tips Ebook (by Greg Low)
Useful Resources
- 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
- Add Transact-SQL Snippets
Supported SQL Server versions
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.
Supported Operating systems
This release of SSMS 17.x Version 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 18.x is not supported on Windows 8. Windows 10 / Windows Server 2016 requires version 1607 (10.0.14393) or later:
Due to the new dependency on NetFx 4.7.2, SSMS 18.0 does not install on Windows 8, older versions of Windows 10, and Windows Server 2016. SSMS setup will block on those operating systems. Windows 8.1 is still supported.
SSMS Version Notes
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.
SSMS 18.x is based on the new Visual Studio 2017 Isolated Shell: The new shell unlocks all the accessibility fixes that went in to both SSMS and Visual Studio.
Available Languages
SQL Server Management Studio 18.9.2 GA:
Chinese (People’s Republic of China) |
Chinese (Taiwan) |
English (United States) |
French |
German |
Italian |
Japanese |
Korean |
Portuguese (Brazil) |
Russian |
Spanish
SQL Server Management Studio Download Links and Release Info
- GA — General Availability
- PP — Public Preview
- Size in Megabytes for English version
| Version/Download Link | Info | Build | Release Date | Size, Mb |
|---|---|---|---|---|
| 18.9.2 GA Release | Latest GA | 15.0.18386.0 | 2021-07-15 | 642 |
| 18.9.1 GA Release | 15.0.18384.0 | 2021-04-20 | 635 | |
| 18.9 GA Release | 15.0.18382.0 | 2021-04-15 | 635 | |
| 18.8 GA Release | 15.0.18369.0 | 2020-12-17 | 640 | |
| 18.7.1 GA Release | 15.0.18358.0 | 2020-10-27 | 635 | |
| 18.7 GA Release | 15.0.18357.0 | 2020-10-20 | 635 | |
| 18.6 GA Release | 15.0.18338.0 | 2020-07-22 | 534 | |
| 18.5.1 GA Release | 15.0.18333.0 | 2020-06-09 | 535 | |
| 18.5 GA Release | 15.0.18183.0 | 2020-04-07 | 535 | |
| 18.4 GA Release | 15.0.18206.0 | 2019-11-04 | 539 | |
| 18.3.1 GA Release | 15.0.18183.0 | 2019-10-02 | 534 | |
| 18.3 GA Release | 15.0.18178.0 | 2019-09-23 | 534 | |
| 18.2 GA Release | 15.0.18142.0 | 2019-07-25 | 528 | |
| 18.1 GA Release | 15.0.18131.0 | 2019-06-11 | 527 | |
| 18.0 GA Release | 15.0.18118.0 | 2019-04-24 | 524 | |
| 18.0 RC1 Release | 15.0.18098.0 | 2019-03-28 | 484 | |
| 18.0 Preview 7 Release | 15.0.18092.0 | 2019-03-01 | 478 | |
| 18.0 Preview 6 Release | 15.0.18075.0 | 2018-12-18 | 457 | |
| 18.0 Preview 5 Release | 15.0.18068.0 | 2018-11-15 | 457 | |
| 18.0 Preview 4 Release | 15.0.18040.0 | 2018-09-24 | 456 | |
| 17.9.1 Release | Latest 17 | 14.0.17289.0 | 2018-11-21 | 807 |
| 17.9 Release | 14.0.17285.0 | 2018-09-04 | 807 | |
| 17.8.1 Release | 14.0.17277.0 | 2018-06-26 | 806 | |
| 17.8 Release | Deprecated | 14.0.17276.0 | 2018-06-21 | 806 |
| 17.7 Release | 14.0.17254.0 | 2018-05-09 | 803 | |
| 17.6 Release | 14.0.17230.0 | 2018-03-20 | 802 | |
| 17.5 Release | 14.0.17224.0 | 2018-02-15 | 802 | |
| 17.4 Release | 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 | Latest 16 | 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 |
SQL Server 2014 RTM Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86
SQL Server 2012 SP1 Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86
SQL Server 2008 R2 Management Studio download links
- SQL Management Studio x64
- SQL Management Studio x86