In this article

Applies to:

*
SQL Server (all supported versions)
*
Azure Squốc lộ Database
*
Azure SQL Managed Instance
*
Azure Synapse Analytics

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to lớn Azure Squốc lộ Database. SSMS provides tools to configure, monitor, và administer instances of SQL Server and databases. Use SSMS to deploy, monitor, và nâng cấp the data-tier components used by your applications, và build queries & scripts.

Bạn đang xem: Download microsoftâ® sql serverâ® 2012 service pack 3 (sp3) express from official microsoft download center

Use SSMS to query, thiết kế, and manage your databases & data warehouses, wherever they are - on your local computer, or in the cloud.

Download SSMS

*
Download Squốc lộ Server Management Studio (SSMS) 18.9.2

SSMS 18.9.2 is the lakiểm tra general availability (GA) version. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.9.2 upgrades it khổng lồ 18.9.2.

Release number: 18.9.2Build number: 15.0.18386.0Release date: July 15, 2021

If you have sầu comments or suggestions, or you want khổng lồ report issues, the best way to contact the SSMS team is at Squốc lộ Server user feedbachồng. By using SQL Server Management Studio, you agree lớn its license terms và privacy statement.

The SSMS 18.x installation doesn"t upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x installs side by side with previous versions, so both versions are available for use. However, if you have sầu a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.9.2. You can see if you have sầu the pđánh giá version by going khổng lồ the Help > About window.

If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. The lachạy thử version is labeled infobandarpkr.com SQL Server Management Studio 18


Important

Beginning with Squốc lộ Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations & features in Azure Data Studio. Azure Data Studio is a cross-platform và open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.

To learn more about Azure Data Studio, kiểm tra out What is Azure Data Studio or the FAQ.


Available languages

This release of SSMS can be installed in the following languages:

SQL Server Management Studio 18.9.2:Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish


Tip

If you are accessing this page from a non-English language version, và want khổng lồ see the most up-to-date content, please visit the US-English version of the site. You can tải về different languages from the US-English version site by selecting available languages.


Note

The SQL Server PowerShell module is a separate install through the PowerShell Gallery. For more information, see Download Squốc lộ Server PowerShell Module.


What"s new

For details and more information about what"s new in this release, see Release notes for SQL Server Management Studio.

Previous versions

This article is for the lachạy thử version of SSMS only. To tải về previous versions of SSMS, visit Previous SSMS releases.


Note

In December 2021, releases of SSMS prior khổng lồ 18.6 will no longer authenticate khổng lồ Database Engines through Azure Active sầu Directory with MFA.To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later.

Connectivity lớn Azure Analysis Services through Azure Active Directory with MFA requires SSMS 18.5.1 or later.

Xem thêm: Ưu Điểm Của Giao Tiếp Modbus Rs 485 Là Gì : Cấu Tạo, Rs485 Là Gì : Cấu Tạo


Unattended install

You can also install SSMS using a command prompt script.

If you want to lớn install SSMS in the background with no GUI prompts, then follow the steps below.

Launch the comm& prompt with elevated permissions.

Type the command below in the comm& prompt.

start "" /w /Quiet SSMSInstallRoot=Example:

start "" /w %systemdrive%SSMSfromSSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%SSMStoYou can also pass /Passive instead of /Quiet to lớn see the setup UI.

If all goes well, you can see SSMS installed at %systemdrive%SSMStoCommon7IDESsms.exe" based on the example. If something went wrong, you could inspect the error code returned and take a peek at the %TEMP%SSMSSetup for the log tệp tin.

Installation with Azure Data Studio

Starting with SSMS 18.7, SSMS installs a system version of Azure Data Studio by mặc định. If an equal or greater system version of Azure Data Studio stable or insiders is already present on the workstation compared lớn the included version of Azure Data Studio, the installation of Azure Data Studio by SSMS is skipped. The Azure Data Studio version can be found in the release notes.The Azure Data Studio system installer requires the same security rights as the SSMS installer.The Azure Data Studio installation is completed with the default Azure Data Studio installation options. These are lớn create a Start Menu folder and add Azure Data Studio khổng lồ PATH. A desktop shortcut is not created & Azure Data Studio is not registered as a default editor for any tệp tin types.At this time, the installation of Azure Data Studio can be skipped by launching the SSMS installer with the comm& line flag DoNotInstallAzureDataStudio=1.

Uninstall

There are shared components that remain installed after you uninstall SSMS.

The shared components that remain installed are:

Azure Data Studioinfobandarpkr.com .NET Framework 4.7.2infobandarpkr.com OLE DB Driver for SQL Serverinfobandarpkr.com ODBC Driver 17 for Squốc lộ Serverinfobandarpkr.com Visual C++ 2013 Redistributable (x86)infobandarpkr.com Visual C++ 2017 Redistributable (x86)infobandarpkr.com Visual C++ 2017 Redistributable (x64)infobandarpkr.com Visual Studio Tools for Applications 2017

These components aren"t uninstalled because they can be shared with other products. If uninstalled, you may run the risk of disabling other products.

Supported SQL offerings

Additionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.

SSMS System Requirements

The current release of SSMS supports the following 64-bit platforms when used with the lakiểm tra available service pack:

Supported Operating Systems:

Windows 10 (64-bit) version 1607 (10.0.14393) or laterWindows 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)

Supported hardware:

1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)Hard disk space: Minimum of 2 GB up to lớn 10 GB of available space

Note

SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommover Azure Data Studio. Azure Data Studio is a cross-platkhung tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Xem thêm: Công Ty Liên Kết ( Affiliated Company Là Gì, Định Nghĩa, Ví Dụ, Giải Thích


*
Get help for SQL tools

Next steps

*
Contribute to lớn Squốc lộ documentation

Did you know that you can edit SQL nội dung yourself? If you vì chưng so, not only bởi you help improve our documentation, but you also get credited as a contributor to the page.