In this article

Applies to:

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

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

Bạn đang xem: Microsoft® sql server® 2008 r2 sp2

Use SSMS to query, design, và manage your databases and 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 lathử nghiệm general availability (GA) version. If you have sầu a previous GA version of SSMS 18 installed, installing SSMS 18.9.2 upgrades it lớn 18.9.2.

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

If you have comments or suggestions, or you want to lớn 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 khổng lồ its license terms và 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 lathử nghiệm version is labeled viettiep.info 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 lớn benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platkhung & open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.

To learn more about Azure Data Studio, check out What is Azure Data Studio or the FAQ.


Available languages

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

Squốc lộ 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, & want lớn see the most up-to-date content, please select Read in English at the top of this page. 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 SQL Server PowerShell Module.


What"s new

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

Previous versions

This article is for the lademo version of SSMS only. To download previous versions of SSMS, visit Previous SSMS releases.


Note

In December 2021, releases of SSMS prior to lớn 18.6 will no longer authenticate to 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.


Unattended install

You can also install SSMS using a command prompt script.

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

Launch the command prompt with elevated permissions.

Type the comm& below in the commvà prompt.

start "" /w /Quiet SSMSInstallRoot=Example:

start "" /w %systemdrive%SSMSfromSSMS-Setup-ENU.exe cộ /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%SSMStoCommon7IDESsms.exe" based on the example. If something went wrong, you could inspect the error code returned & 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 khổng lồ 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 & add Azure Data Studio khổng lồ 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 command 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 Studioviettiep.info .NET Framework 4.7.2viettiep.info OLE DB Driver for SQL Serverviettiep.info ODBC Driver 17 for Squốc lộ Serverviettiep.info Visual C++ 2013 Redistributable (x86)viettiep.info Visual C++ 2017 Redistributable (x86)viettiep.info Visual C++ 2017 Redistributable (x64)viettiep.info 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 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 Server 2022 (64-bit)Windows 10 (64-bit) version 1607 (10.0.14393) or laterWindows 8.1 (64-bit)Windows Server 2019 (64-bit)Windows Server năm 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 (Hãng sản xuất 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 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-platform tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Xem thêm: Canon Lbp2900 Driver Free Download Windows, Canon Lbp2900B Driver And Software Downloads


*
Get help for Squốc lộ tools

Next steps

*
Contribute to SQL documentation

Did you know that you can edit SQL nội dung yourself? If you vày so, not only vị you help improve sầu our documentation, but you also get credited as a contributor khổng lồ the page.