Tải sql server 2014

In this article

Applies to:

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

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

Bạn đang xem: Tải sql server 2014

Use SSMS khổng lồ query, design, và manage your databases & data warehouses, wherever they are - on your local computer, or in the cloud.

Download SSMS

*
Download SQL Server Management Studio (SSMS) 18.9.2

SSMS 18.9.2 is the lademo 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 comments or suggestions, or you want to report issues, the best way khổng lồ contact the SSMS team is at SQL Server user feedback. 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 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 previews 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 lathử nghiệm version is labeled tochuchoinghi.net SQL Server Management Studio 18


Important

Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of Squốc lộ Server Management Studio are now able khổng lồ benefit from the innovations & features in Azure Data Studio. Azure Data Studio is a cross-platsize 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:

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, and 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 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 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 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 Directory with MFA.To continue utilizing Azure Active sầu Directory authentication with MFA, you need SSMS 18.6 or later.

Connectivity khổng lồ Azure Analysis Services through Azure Active sầu 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 command prompt script.

If you want to 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 commvà prompt.

start "" /w /Quiet SSMSInstallRoot=Example:

start "" /w %systemdrive%SSMSfromSSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%SSMStoYou can also pass /Passive instead of /Quiet khổng lồ see the cài đặt 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 default. 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 default Azure Data Studio installation options. These are lớn create a Start Menu folder and add Azure Data Studio to PATH. A desktop shortcut is not created and 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.

Uninstall

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 SQL Servertochuchoinghi.net ODBC Driver 17 for Squốc lộ 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 Squốc lộ offerings

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

SSMS System Requirements

The current release of SSMS supports the following 64-bit platforms when used with the latest 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 (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 recommkết thúc Azure Data Studio. Azure Data Studio is a cross-platsize tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Xem thêm: Tải Adobe Premiere Pro Cc 2017 Full Crack, Adobe Premiere Pro Cc 2017 Final Full Version


*
Get help for Squốc lộ tools

Next steps

*
Contribute to lớn SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only vì chưng you help improve sầu our documentation, but you also get credited as a contributor khổng lồ the page.


Chuyên mục: Download