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.
Обновлено
2019-09-12 14:12:36
Совместимость
Windows 2000, Windows XP, Windows 2003
Описание
Microsoft SQL Server 2005 Management Studio Express — простое графическое средство для управления базами данных.
О программе
Перед вами программа, предназначенная для работы с SQL Server 2005 Express Edition и SQL Server 2005 Express Edition с расширенными службами. Позволяет также управлять экземплярами ядра СУБД SQL Server, которые были созданы при помощи SQL Server 2005 любой версии.
Обратите внимание, что Microsoft SQL Server 2005 Management Studio Express не может быть использована для управления службами SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, а также агентом сервера SQL или SQL Server 2005 Mobile Edition.
Совместимость
Программа совместима с версиями операционной системы Windows 2000 Service Pack 4, Windows Server 2003 Service Pack 1 и Windows XP Service Pack 2 .
Для работы SSMSE потребуется:
- Компьютер с процессором Intel Pentium III 600
МГц или более мощным (рекомендуется
процессор с тактовой частотой не менее 1 ГГц). - Не менее 192 МБ ОЗУ, (рекомендуется не менее 512 МБ).
- Как минимум 100 МБ дискового пространства.
Обратите внимание, что для установки программы необходимо обладать правами администратора и установить Microsoft Core XML Services (MSXML) 6.0. Кроме того, для 32-разрядных платформ, вам потребуется установить Microsoft .NET Framework 2.0.
Версии
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).
Download offers the opportunity to buy software and apps. When you buy through our links, we may get a commission.
- Home
- Windows
- Developer Tools
- Database Software
- Microsoft SQL Server Management Studio Express (64-bit)
Developer’s Description
Microsoft SQL Server Management Studio Express (64-bit) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.
Full Specifications
What’s new in version 1.0
General
Release June 22, 2011
Date Added April 18, 2006
Version 1.0
Operating Systems
Operating Systems Windows, Windows 2000, Windows XP, Windows 2003
Additional Requirements None
Popularity
Total Downloads 157,943
Downloads Last Week 87
Report Software
Related Software
xSQL Script Executor
Free
Execute multiple T-SQL scripts against multiple SQL Server, DB2, and MySQL databases.
xSQL Script Executor
Microsoft Access 2010 Runtime (32-bit)
Free
Enable you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers.
Microsoft Access 2010 Runtime (32-bit)
Get the best price on everything
Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.
Среда 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