下載 SQL Server Management Studio (SSMS)Download SQL Server Management Studio (SSMS)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

SQL Server Management Studio (SSMS) 是整合式環境,可用於管理任何 SQL 基礎結構,從 SQL Sever 到 Azure SQL Database 皆適用。SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS 提供工具來設定、監視以及管理 SQL Server 執行個體和資料庫。SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. 使用 SSMS,即可部署、監視和升級應用程式所使用的資料層元件,以及建置查詢和指令碼。Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.

使用 SSMS,即可查詢、設計與管理資料庫和資料倉儲,而不論它們位在何處:本機電腦上或雲端中。Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.

下載 SSMSDownload SSMS

下載 SQL Server Management Studio (SSMS) 18.9。1

SSMS 18.9.1 是正式推出 (GA) 版本的最新正式運作。SSMS 18.9.1 is the latest general availability (GA) version. 如果您先前已安裝 SSMS 18 的 GA 版本,則安裝 SSMS 18.9.1 會將其升級至18.9.1。If you have a previous GA version of SSMS 18 installed, installing SSMS 18.9.1 upgrades it to 18.9.1.

  • 版本號碼:18.9。1Release number: 18.9.1
  • 組建編號:15.0.18384。0Build number: 15.0.18384.0
  • 發行日期:2021年4月20日Release date: April 20, 2021

若您有意見或建議,或是要回報問題,則連絡 SSMS 小組的最佳方式是透過 SQL Server 使用者意見反應If you have comments or suggestions, or you want to report issues, the best way to contact the SSMS team is at SQL Server user feedback. 使用 SQL Server Management Studio 即表示您同意其 授權條款隱私權聲明By using SQL Server Management Studio, you agree to its license terms and privacy statement.

SSMS 18.x 安裝不會升級或取代 SSMS 17.x 版或更早版本。The SSMS 18.x installation doesn't upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x 會與舊版本並行安裝,以便於使用者能夠同時使用這兩種版本。SSMS 18.x installs side by side with previous versions, so both versions are available for use. 不過,如果您已安裝 SSMS 6.x 的 預覽 版本,您必須先將其卸載,再安裝 ssms 18.9.1。However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.9.1. 可以前往 [說明] > [關於] 視窗,以查看您是否有預覽版本。You can see if you have the preview version by going to the Help > About window.

如果電腦中包含並存安裝的 SSMS,請確認已針對您的特定需求啟動正確的版本。If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. 最新版本會標記為 Microsoft SQL Server Management Studio 18The latest version is labeled Microsoft SQL Server Management Studio 18


從 SQL Server Management Studio (SSMS) 18.7 開始,Azure Data Studio 會與 SSMS 一起自動安裝。Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. 現在,SQL Server Management Studio 使用者也可獲益於 Azure Data Studio 的創新和功能。Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. 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.

若要深入了解 Azure Data Studio,請參閱什麼是 Azure Data Studio常見問題集To learn more about Azure Data Studio, check out What is Azure Data Studio or the FAQ.

可用的語言Available languages

此版 SSMS 提供下列語言版本:This release of SSMS can be installed in the following languages:

SQL Server Management Studio 18.9.1:SQL Server Management Studio 18.9.1:
簡體中文 | 繁體中文 | 英文 (美國) | 法文 | 德文 | 義大利文 | 日文 | 韓文 | 葡萄牙文 (巴西) | 俄文 | 西班牙文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.


SQL Server PowerShell 模組為透過 PowerShell 資源庫個別安裝的模組。The SQL Server PowerShell module is a separate install through the PowerShell Gallery. 如需詳細資訊,請參閱下載 SQL Server PowerShell 模組For more information, see Download SQL Server PowerShell Module.

新功能What's new

如需此版本中新功能的詳細資訊和詳細資訊,請參閱 SQL Server Management Studio 的版本資訊。For details and more information about what's new in this release, see Release notes for SQL Server Management Studio.

此版本有一些已知問題There are a few known issues with this release.

舊版Previous versions

本文僅適用於最新版本的 SSMS。This article is for the latest version of SSMS only. 若要下載舊版的 SSMS,請前往舊版 SSMSTo download previous versions of SSMS, visit Previous SSMS releases.


在 2021 年 12 月,18.6 以前的 SSMS 版本無法再透過 Azure Active Directory 進行 MFA 驗證。In December 2021, releases of SSMS prior to 18.6 will no longer authenticate through Azure Active Directory with MFA.

若要繼續使用 Azure Active Directory 進行 MFA 驗證,您需要 SSMS 18.6 或更新版本To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later.

自動安裝Unattended install

您也可以使用命令提示字元指令安裝 SSMS。You can also install SSMS using a command prompt script.

苦要在不提供 GUI 提示的背景中安裝 SSMS,請執行下列步驟。If you want to install SSMS in the background with no GUI prompts, then follow the steps below.

  1. 啟動權限較高的命令提示字元。Launch the command prompt with elevated permissions.

  2. 在下列命令提示字元中鍵入命令。Type the command below in the command prompt.

    start "" /w <path where SSMS-Setup-ENU.exe file is located> /Quiet SSMSInstallRoot=<path where you want to install SSMS>


    start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMSto

    您也可以傳遞 /Passive (而不是 /Quiet ),以查看安裝程式 UI。You can also pass /Passive instead of /Quiet to see the setup UI.

  3. 若一切順利,就會像範例般顯示安裝在 %systemdrive%\SSMSto\Common7\IDE\Ssms.exe 的 SSMS。If all goes well, you can see SSMS installed at %systemdrive%\SSMSto\Common7\IDE\Ssms.exe" based on the example. 若發生錯誤,將能查看傳回的錯誤碼,以及 %TEMP%\SSMSSetup 中的記錄檔。If something went wrong, you could inspect the error code returned and take a peek at the %TEMP%\SSMSSetup for the log file.

使用 Azure Data Studio 來安裝Installation with Azure Data Studio

  • 從 SSMS 18.7 開始,SSMS 預設會安裝 Azure Data Studio 的系統版本。Starting with SSMS 18.7, SSMS installs a system version of Azure Data Studio by default. 如果工作站上的 Azure Data Studio 穩定或測試人員系統版本等於或高於內含的 Azure Data Studio 版本,則 SSMS 會跳過 Azure Data Studio 的安裝。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. 您可以在版本資訊中找到 Azure Data Studio 版本。The Azure Data Studio version can be found in the release notes.
  • Azure Data Studio 系統安裝程式需要與 SSMS 安裝程式相同的安全性權限。The Azure Data Studio system installer requires the same security rights as the SSMS installer.
  • Azure Data Studio 安裝已完成 (使用預設的 Azure Data Studio 安裝選項)。The Azure Data Studio installation is completed with the default Azure Data Studio installation options. 這些是用來建立 [開始] 功能表資料夾,並將 Azure Data Studio 新增至 PATH。These are to create a Start Menu folder and add Azure Data Studio to PATH. 不會建立桌面捷徑,而且 Azure Data Studio 不會註冊為任何檔案類型的預設編輯器。A desktop shortcut is not created and Azure Data Studio is not registered as a default editor for any file types.
  • Azure Data Studio 的當地語系化是透過語言套件延伸模組來完成的。Localization of Azure Data Studio is accomplished through Language Pack extensions. 若要將 Azure Data Studio 當地語系化,請從延伸模組市集下載對應的語言套件。To localize Azure Data Studio, download the corresponding language pack from the extension marketplace.
  • 此時,您可以透過使用命令列旗標 DoNotInstallAzureDataStudio=1 啟動 SSMS 安裝程式,以跳過 Azure Data Studio 的安裝。At this time, the installation of Azure Data Studio can be skipped by launching the SSMS installer with the command line flag DoNotInstallAzureDataStudio=1.


在您將 SSMS 解除安裝之後,某些共用元件仍會維持安裝。There are shared components that remain installed after you uninstall SSMS.

維持安裝的共用元件為:The shared components that remain installed are:

  • Azure Data StudioAzure Data Studio
  • Microsoft .NET Framework 4.7.2Microsoft .NET Framework 4.7.2
  • Microsoft OLE DB Driver for SQL ServerMicrosoft OLE DB Driver for SQL Server
  • Microsoft ODBC Driver 17 for SQL ServerMicrosoft ODBC Driver 17 for SQL Server
  • Microsoft Visual C++ 2013 可轉散發套件 (x86)Microsoft Visual C++ 2013 Redistributable (x86)
  • Microsoft Visual C++ 2017 可轉散發套件 (x86)Microsoft Visual C++ 2017 Redistributable (x86)
  • Microsoft Visual C++ 2017 可轉散發套件 (x64)Microsoft Visual C++ 2017 Redistributable (x64)
  • Microsoft Visual Studio Tools for Applications 2017Microsoft 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.

支援的 SQL 供應項目Supported SQL offerings

  • 此版本的 SSMS 適用於所有支援的 SQL Server 2008 版本 - SQL Server 2019 (15.x)SQL Server 2019 (15.x),並提供最高層級的支援以使用 Azure SQL Database 與 Azure Synapse Analytics 中最新的雲端功能。This version of SSMS works with all supported versions of SQL Server 2008 - SQL Server 2019 (15.x)SQL Server 2019 (15.x) and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure Synapse Analytics.
  • 此外,SSMS 18.x 可以與 SSMS 17.x、SSMS 16.x 或 SQL Server 2014 SSMS 及更早的版本並存安裝。Additionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.
  • SQL Server Integration Services (SSIS) - SSMS 17.x 或更新版本不支援連線至舊版 SQL Server Integration Services 服務。SQL Server Integration Services (SSIS) - SSMS version 17.x or later doesn't support connecting to the legacy SQL Server Integration Services service. 若要連線至舊版 Integration Services 的舊版本,請使用與 SQL Server 版本一致的 SSMS 版本。To connect to an earlier version of the legacy Integration Services, use the version of SSMS aligned with the version of SQL Server. 例如,使用 SSMS 16.x 連線至舊版 SQL Server 2016 Integration Services 服務。For example, use SSMS 16.x to connect to the legacy SQL Server 2016 Integration Services service. SSMS 17.x 和 SSMS 16.x 可以並存安裝在相同電腦上。SSMS 17.x and SSMS 16.x can be installed side by side on the same computer. 自 SQL Server 2012 發行之後,建議使用 SSIS Catalog 資料庫 SSISDB 來儲存、管理、執行和監視 Integration Services 套件。Since the release of SQL Server 2012, the SSIS Catalog database, SSISDB, is the recommended way to store, manage, run, and monitor Integration Services packages. 如需詳細資訊,請參閱 SSIS 目錄For details, see SSIS Catalog.

SSMS 系統需求SSMS System Requirements

搭配最新推出的服務套件使用時,最新版的 SSMS 支援下列 64 位元平台: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 位元) 版本 1607 (10.0.14393) 或更新版本Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64 位元)Windows 8.1 (64-bit)
  • Windows Server 2019 (64 位元)Windows Server 2019 (64-bit)
  • Windows Server 2016 (64 位元)Windows Server 2016 (64-bit)
  • Windows Server 2012 R2 (64 位元)Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64 位元)Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64 位元)Windows Server 2008 R2 (64-bit)

支援的硬體:Supported hardware:

  • 1.8 GHz 或更快的 x86 (Intel、AMD) 處理器。1.8 GHz or faster x86 (Intel, AMD) processor. 建議雙核心或更佳的處理器Dual-core or better recommended
  • 2 GB 的 RAM,建議 4 GB 的 RAM (如果在虛擬機器上執行,至少 2.5 GB)2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)
  • 硬碟空間:最少 2 GB 至 10 GB 的可用空間Hard disk space: Minimum of 2 GB up to 10 GB of available space


SSMS 僅以適用於 Windows 的 32 位元應用程式形式提供。SSMS is available only as a 32-bit application for Windows. 若您需要能在 Windows 以外作業系統上執行的工具,我們建議使用 Azure Data Studio。If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio 是一個跨平台工具,可在 macOS、Linux 與 Windows 上執行。Azure Data Studio is a cross-platform tool that runs on macOS, Linux, as well as Windows. 如需詳細資料,請參閱 Azure Data StudioFor details, see Azure Data Studio.

取得 SQL 工具的說明

後續步驟Next steps

參與編輯 SQL 文件

您知道您可以自己編輯內容嗎?Did you know that you could edit the content yourself? 如果您這樣做,不只會改善我們的文件,而且您也會成為該頁面的參與者!If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.