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

适用对象:yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Management Studio (SSMS) 是一种集成环境,用于管理从 SQL Server 到 Azure SQL 数据库的任何 SQL 基础结构。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, as well as 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.

SSMS 是免费的!SSMS is free!

SSMS 18.0 候选发布 1 (RC1) 现已推出,它是为 SQL Server 2019 预览SQL Server 2019 preview 提供支持的最新一代 SQL Server Management Studio。SSMS 18.0 Release Candidate 1 (RC1) is now available, and is the latest generation of SQL Server Management Studio that provides support for SQL Server 2019 预览SQL Server 2019 preview.

SSMS 17.9 1 是当前 SSMS 的正式发布 (GA) 版本SSMS 17.9.1 is the current General Availability (GA) version of SSMS

[![d下载]ownload](../ssdt/media/download.png) 下载 SQL Server Management Studio 17.9.1Download SQL Server Management Studio 17.9.1](https://go.microsoft.com/fwlink/?linkid=2043154)

[![d下载]ownload](../ssdt/media/download.png) 下载 SQL Server Management Studio 17.9.1 升级包(将 17.x 升级到 17.9.1)Download SQL Server Management Studio 17.9.1 Upgrade Package (upgrades 17.x to 17.9.1)](https://go.microsoft.com/fwlink/?linkid=2043430)

版本信息Version Information

  • 版本号:17.9.1Release number: 17.9.1
  • 生成号:14.0.17289.0Build number: 14.0.17289.0
  • 发布日期:2018 年 11 月 21 日Release date: November 21, 2018

可用语言 (SSMS 17.9.1)Available Languages (SSMS 17.9.1)

备注

如果安装在以下平台中,非英语本地化版本的 SSMS 17.x 需要 KB 2862966 安全更新程序包:Windows 8、Windows 7、Windows Server 2012 和 Windows Server 2008 R2。Non-English localized releases of SSMS 17.x require the KB 2862966 security update package if installing on: Windows 8, Windows 7, Windows Server 2012, and Windows Server 2008 R2.

中文(中国) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

有关 SSMS 17.9.1 的其他详细信息,请参阅 SSMS 17.9.1 更改日志For additional details about SSMS 17.9.1, please see the SSMS 17.9.1 changelog.

SSMS 安装提示和问题 (SSMS 17.9.1)SSMS installation tips and issues (SSMS 17.9.1)

尽量减少安装重启的次数Minimize Installation Reboots

  • 执行以下操作以降低 SSMS 安装程序在安装结束时需要重新启动的可能性:Take the following actions to reduce the chances of SSMS setup requiring a reboot at the end of installation:
    • 请确保运行的是最新版 Visual C++ 2013 Redistributable Package。Make sure you are running an up-to-date version of the Visual C++ 2013 Redistributable Package. 需要版本 12.0.40649.5(或更高版本)。Version 12.0.40649.5 (or greater) is required. 仅需要版本 x64。Only the x64 version is needed.
    • 验证计算机上的 .NET Framework 版本是否为 4.6.1(或更高版本)。Verify the version of .NET Framework on the computer is 4.6.1 (or greater).
    • 关闭计算机上打开的所有 Visual Studio 实例。Close every instance of Visual Studio that are open on the computer.
    • 请确保计算机上已安装所有最新 OS 更新。Make sure all the latest OS updates are installed on the computer.
    • 所提及的操作通常只需执行一次。The noted actions are typically required only once. 有几种情况需要在额外升级到 SSMS 的同一主版本期间重新启动。There are few cases where a reboot is required during additional upgrades to the same major version of SSMS. 对于次要升级,计算机上已安装 SSMS 的所有先决条件。For minor upgrades, all the prerequisites for SSMS are already installed on the computer.

SSMS 18.0 (RC1)SSMS 18.0 (RC1)

SSMS 18.0 候选发布 1 (RC1) 现已推出,它是为 SQL Server 2019 预览SQL Server 2019 preview 提供支持的最新一代 SQL Server Management Studio!SSMS 18.0 Release Candidate 1 (RC1) is now available, and is the latest generation of SQL Server Management Studio that provides support for SQL Server 2019 预览SQL Server 2019 preview!

![dow下载](.nload 下载 SQL Server Management Studio 18.0 (RC1)Download SQL Server Management Studio 18.0 (RC1)](https://go.microsoft.com/fwlink/?linkid=2085742)

RC1 是 SSMS 18.0 的最新公共预览版。RC1 is the latest public preview of SSMS 18.0. 如果安装了以前的 SSMS 18.0 预览版,请在安装 SSMS 18.0 RC1 之前将其卸载。If you have a previous SSMS 18.0 Preview installed, uninstall it before installing SSMS 18.0 RC1.

版本信息Version Information

  • 版本号:18.0 (RC1)Release number: 18.0 (RC1)
  • 生成号:15.0.18098.0Build number: 15.0.18098.0
  • 发布日期:2019 年 3 月 28 日Release date: March 28, 2019

如果你有意见或建议,或想报告问题,最好是通过 UserVoice 与 SSMS 团队取得联系。If you have comments or suggestions, or you want to report issues, the best way to reach out to the SSMS Team is at UserVoice.

SSMS 18.x 安装不会升级或替换 SSMS 17.x 或更早版本。The SSMS 18.x installation does not 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 的并行安装,请验证你是否针对特定需求启动相应的版本。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 18:The latest version is labeled Microsoft SQL Server Management Studio 18:

可用语言 (SSMS 18.0 RC1)Available Languages (SSMS 18.0 RC1)

此版本的 SSMS 可以安装在以下语言中:This release of SSMS can be installed in the following languages:

SQL Server Management Studio 18.0 (RC1):SQL Server Management Studio 18.0 (RC1):
中文(中国) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

SQL Server Management Studio 18.0 升级包(升级到 18.0):SQL Server Management Studio 18.0 Upgrade Package (upgrades to 18.0):
此时没有可用的升级选项。No upgrade option is available at this time. 如果安装了以前的 SSMS 18.0 预览版,请在安装 SSMS 18.0 RC1 之前将其卸载。If you have a previous SSMS 18.0 preview installed, uninstall it before installing SSMS 18.0 RC1.

备注

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.

此版本 (SSMS 18.0 RC1) 中的新增功能New in this Release (SSMS 18.0 RC1)

SSMS 18.0 (RC1) 是最新版本的 SQL Server Management Studio。SSMS 18.0 (RC1) is the latest version of SQL Server Management Studio. SSMS 的 18.x 一代提供对 SQL Server 2008 到 SQL Server 2019 预览版几乎所有功能领域的支持。The 18.x generation of SSMS provides support for almost all feature areas on SQL Server 2008 through SQL Server 2019 preview.

有关此版本中新增功能的详细信息,请参阅 SSMS 发行说明For details about what's new in this release, see the SSMS release notes.

受支持的 SQL 产品/服务 (SSMS 18.0 RC1)Supported SQL offerings (SSMS 18.0 RC1)

  • 此版本的 SSMS 适用于所有受支持 SQL Server 2008 - SQL Server 2019 预览SQL Server 2019 preview,并且在最大程度上支持与 Azure SQL 数据库和 Azure SQL 数据仓库中的最新云功能配合使用。This version of SSMS works with all supported versions of SQL Server 2008 - SQL Server 2019 预览SQL Server 2019 preview and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.
  • 此外,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 does not 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 目录数据库 (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 18.0 RC1)Supported Operating systems (SSMS 18.0 RC1)

与最新可用的服务包一起使用时,此版本的 SSMS 支持以下 64 位平台:This release of SSMS supports the following 64-bit platforms when used with the latest available service pack:

  • Windows 10(64 位)*Windows 10 (64-bit) *
  • Windows Server 2016 *Windows Server 2016 *
  • 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)

* 需要版本 1607 (10.0.14939) 或更高版本* Requires version 1607 (10.0.14939) or later

备注

SSMS 仅在 Windows 上运行。SSMS runs on Windows only. 如果需要在 Windows 以外的平台上运行的工具,请查看 Azure Data Studio。If you need a tool that runs on platforms other than Windows, take a look at Azure Data Studio. Azure Data Studio 是一个全新的跨平台工具,可在 macOS、Linux 以及 Windows 上运行。Azure Data Studio is a new cross-platform tool that runs on macOS, Linux, as well as Windows. 有关详细信息,请参阅 Azure Data StudioFor details, see Azure Data Studio.

发行说明 (SSMS 18.0 RC1)Release Notes (SSMS 18.0 RC1)

N/AN/A

以前的版本Previous releases

以前的 SQL Server Management Studio 版本Previous SQL Server Management Studio Releases

反馈Feedback

needhelp_person_icon SQL 客户端工具论坛needhelp_person_icon](../ssms/media/needhelp_person_icon.png) SQL Client Tools Forum

info_tip 获取帮助Get Help

另请参阅See Also

编辑内容 参与编辑 SQL 文档Contribute SQL documentation

您是否知道,您可以编辑内容自己?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.

如果你有意见或建议,或想报告问题,最好是通过 UserVoice 与 SSMS 团队取得联系。If you have comments or suggestions, or you want to report issues, the best way to reach out to the SSMS Team is at UserVoice.