SQL Server Management Studio 缺失
我刚刚安装了 SQL Server 2008 r2 和 SQL Server Management Studio。 安装后发现SQL Server Management Studio还没有安装。
我想安装 SQL Server Management Studio，但找不到相应的安装。知道如何安装吗？
I just installed SQL Server 2008 r2 and SQL Server Management Studio.
After installation, I found that the SQL Server Management Studio has not been installed.
I wanted to install SQL Server Management Studio, but cannot find the installation for this. Any idea how to install it?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
您在安装过程中是否选择了“管理工具”选项？
确保选择此选项，SQL Server Management Studio 将安装在计算机上。
Did you include "Management Tools" as a chosen option during setup?
Ensure this option is selected, and SQL Server Management Studio will be installed on the machine.
我知道这是一个老问题，但我刚刚遇到同样令人沮丧的问题几个小时，想分享我的解决方案。就我而言，安装菜单中也没有“管理工具”选项。它不仅显示为已禁用或已安装，而且只是丢失了，它不在菜单上的任何位置。
所以最终对我有用的是使用 Web Platform Installer 4.0，并检查用于安装：产品>数据库> “Sql Server 2008 R2 管理对象”。完成此操作后，您可以重新启动安装，并且“管理工具”将像前面的答案所述那样出现。
请注意，也可能有“Sql Server 2012 共享管理对象”，但我认为这是出于不同的目的。
希望这可以节省我为此浪费的几个小时。
I know this is an old question, but I've just had the same frustrating issue for a couple of hours and wanted to share my solution. In my case the option "Managements Tools" wasn't available in the installation menu either. It wasn't just greyed out as disabled or already installed, but instead just missing, it wasn't anywhere on the menu.
So what finally worked for me was to use the Web Platform Installer 4.0, and check this for installation: Products > Database > "Sql Server 2008 R2 Management Objects". Once this is done, you can relaunch the installation and "Management Tools" will appear like previous answers stated.
Note there could also be a "Sql Server 2012 Shared Management Objects", but I think this is for different purposes.
Hope this saves someone the couple of hours I wasted into this.
在SQL Server 2016中，它有自己的链接：
只需在此处下载：https://msdn.microsoft.com/en-us/library/mt238290.aspx
In SQL Server 2016 it has its own link:
Just download it here: https://msdn.microsoft.com/en-us/library/mt238290.aspx
如果您有 SQL Server 安装程序的备份副本，则可以根据要求添加功能（管理工具基本/完整）。
请在 Windows 机器中执行以下步骤：
If you have a copy of backup of SQL Server setup then you could add features (Management Tools Basic/Complete) as you requested.
Please use the below steps in Windows machine:
当前版本：
SQL Server Management Studio
直接链接：http:// go.microsoft.com/fwlink/?LinkID=828615
版本信息
此版本的 SSMS 使用 Visual Studio 2015 隔离 shell。
版本号：16.4.1
此版本的内部版本号：13.0.15900.1
支持的 SQL Server 版本
此版本的 SSMS 可与所有受支持的 SQL Server 版本（SQL Server 2008 - SQL Server 2016）配合使用，并为使用 Azure SQL 数据库中的最新云功能提供最大程度的支持。
SQL Server 2000 或 SQL Server 2005 没有明确的阻止，但某些功能可能无法正常工作。
此外，SSMS 16.x 版本或 SSMS 2016 可以与 SSMS 2014 及更早版本的先前版本并排安装。
2012 年答案的旧版本
安装步骤：
命令：
SQLEXPRWT_x64_ENU.exe /ACTION=INSTALL /FEATURES=TOOLS /QUIETSIPLE /IAcceptSQLServerLicenseTerms
原始答案是：
https://dba.stackexchange.com/questions/14438/如何安装-sql-server-2008-r2-profiler
现已发布：
http://blog.cpodesign.com/blog/sql-2012 -安装-sql-profiler/
Current version:
SQL Server Management Studio
Direct link: http://go.microsoft.com/fwlink/?LinkID=828615
Version Information
This release of SSMS uses the Visual Studio 2015 Isolated shell.
The release number: 16.4.1
The build number for this release: 13.0.15900.1
Supported SQL Server versions
This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2016), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database.
There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly.
Additionally, one SSMS 16.x release or SSMS 2016 can be installed side by side with previous versions of SSMS 2014 and earlier.
Older version of the answer for 2012
Installation steps:
Command:
SQLEXPRWT_x64_ENU.exe /ACTION=INSTALL /FEATURES=TOOLS /QUIETSIMPLE /IAcceptSQLServerLicenseTerms
original answer was:
https://dba.stackexchange.com/questions/14438/how-to-install-sql-server-2008-r2-profiler
Now posted:
http://blog.cpodesign.com/blog/sql-2012-installing-sql-profiler/
如果您刚刚安装了 SQL Server，并且 SQL Server 安装中心中没有安装 SQL Server Management Studio 的选项，请尝试重新启动计算机。
这个选择（见下图）仅在我安装 SQL Server，然后重新启动计算机后出现：
Try restarting your computer if you just installed SQL Server and there's no choice in the SQL Server Installation Center to install SQL Server Management Studio.
This choice (see image below) only appeared for me after I installed SQL Server, then restarted my computer: