Tải Sql Server 2014 + Hướng Dẫn Cài Đặt, Download Sql Server Express



SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, & administer instances of SQL Server và databases. Use SSMS to deploy, monitor, & upgrade the data-tier components used by your applications, và build queries and scripts.

Bạn đang xem: Tải Sql Server 2014 + Hướng Dẫn Cài Đặt, Download Sql Server Express

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

Download SSMS

SSMS 18.9.2 is the latest general availability (GA) version. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.9.2 upgrades it to 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 lớn liên hệ the SSMS team is at SQL Server user feedback. By using SQL Server Management Studio, you agree lớn its license terms & privacy statement.

The SSMS 18.x installation doesn"t nâng cấp 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 the preview version by going to 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 lademo version is labeled tochuchoinghi.net Squốc lộ Server Management Studio 18


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 khổng lồ benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and 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


If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the US-English version of the site. You can download different languages from the US-English version site by selecting available languages.


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

What"s new

For details & more information about what"s new in this release, see Release notes for Squốc lộ Server Management Studio.

Previous versions

This article is for the lachạy thử version of SSMS only. To download previous versions of SSMS, visit Previous SSMS releases.


In December 2021, releases of SSMS prior lớn 18.6 will no longer authenticate lớn 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 to lớn Azure Analysis Services through Azure Active Directory with MFA requires SSMS 18.5.1 or later.

Xem thêm: Tải Cubase 7 Full Crack Ed Cubase 7 Full Software, Cubase Elements 7 Full Version + Patch

Unattended install

You can also install SSMS using a comm& 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 commvà below in the command prompt.

start "" /w /Quiet SSMSInstallRoot=Example:

start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMStoYou can also pass /Passive instead of /Quiet to lớn see the thiết lập UI.

If all goes well, you can see SSMS installed at %systemdrive%\SSMSto\Common7\IDE\Ssms.exe" based on the example. If something went wrong, you could inspect the error code returned và 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 default. If an equal or greater system version of Azure Data Studio stable or insiders is already present on the workstation compared to 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 mặc định Azure Data Studio installation options. These are to lớn create a Start Menu folder and add Azure Data Studio to PATH. A desktop shortcut is not created và Azure Data Studio is not registered as a mặc định editor for any file 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.


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

The shared components that remain installed are:

Azure Data Studiotochuchoinghi.net .NET Framework 4.7.2tochuchoinghi.net OLE DB Driver for Squốc lộ Servertochuchoinghi.net ODBC Driver 17 for SQL Servertochuchoinghi.net Visual C++ 2013 Redistributable (x86)tochuchoinghi.net Visual C++ 2017 Redistributable (x86)tochuchoinghi.net Visual C++ 2017 Redistributable (x64)tochuchoinghi.net 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 Squốc lộ Server năm trước SSMS và 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 năm nhâm thìn (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 (Hãng 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 khổng lồ 10 GB of available space


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-platform tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Get help for SQL tools

Next steps

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you bởi so, not only vị you help improve sầu our documentation, but you also get credited as a contributor lớn the page.