SQL Server Management Studio 17无法找到一个或多个组件

I have just upgraded to Visual Studio 2017 Professional and SSMS 17.

我刚刚升级到Visual Studio 2017 Professional和SSMS 17。

I can access my servers and databases through Visual Studio 17's SQL Server Object Explorer but when I try to execute SSMS outside of the VS IDE it tells me "Cannot find one or more components. Please reinstall the application". I have reinstalled SSMS 17 twice and still cannot run it.

我可以通过Visual Studio 17的SQL Server Object Explorer访问我的服务器和数据库，但是当我尝试在VS IDE之外执行SSMS时，它会告诉我“找不到一个或多个组件”。请重新安装应用程序”。我已经重新安装了两次SSMS 17，但是仍然不能运行它。

The SSMS executable is at:

SSMS可执行文件如下:

C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe.

C:\Program Files (x86)\Microsoft SQL Server 140 \ \ \ Binn \ ManagementStudio \ Ssms.exe工具。

I get the same problem on another machine running VS 2017 Community.

在另一台运行于2017社区的机器上，我也遇到了同样的问题。

What is causing the message "Cannot find one or more components. Please reinstall the application" when I try to execute SSMS outside of Visual Studio? What do I need to do to execute SSMS outside of the VS IDE?

导致消息“无法找到一个或多个组件”的原因。请重新安装应用程序“当我尝试在Visual Studio之外执行SSMS时?”在VS IDE之外执行SSMS需要做什么?

4 个解决方案

#1

I had similar problem and in my case it was due to a corrupt Microsoft Visual Studio 2015 Shell (Isolated) which SSMS 17 requires to run outside the VS IDE.

我也遇到过类似的问题，这是由于微软Visual Studio 2015 Shell(孤立的)出现了问题，SSMS 17需要在VS IDE之外运行。

To fix this, I had to do the following:

为了解决这个问题，我必须做以下事情:

Uninstall Microsoft Visual C++ 2017 Redistributable (both the x64 and x86). This is to ensure that step (2) will succeed as the repair process of the prerequisites might fail in some cases if newer versions have been installed.
卸载Microsoft Visual c++ 2017 Redistributable (x64和x86)。这是为了确保第(2)步能够成功，因为在某些情况下，如果安装了更新的版本，先决条件的修复过程可能会失败。
Repair Microsoft Visual Studio 2015 Shell (Isolated) (or reinstall using https://download.microsoft.com/download/C/9/C/C9CA8400-20AA-4488-92A3-F3F6D978AD81/vs_isoshell.exe).
修复微软Visual Studio 2015 Shell(孤立的)(或者使用https://download.microsoft.com/download/C/9/C/C9CA8400-20AA-4488-92A3-F3F6D978AD81/vs_isoshell.exe重新安装)。
Reinstall Microsoft Visual C++ 2017 Redistributable (https://go.microsoft.com/fwlink/?LinkId=746572 and https://go.microsoft.com/fwlink/?LinkId=746571) if removed earlier.
重新安装Microsoft Visual C+ 2017 Redistributable (https://go.microsoft.com/fwlink/?LinkId=746572和https://go.microsoft.com/fwlink/?

#2

Here is a quick fix for cannot find one or more components in SQL Server

下面是对SQL Server中找不到一个或多个组件的快速修复

Follow these steps:

遵循以下步骤:

Run Add or remove programs (Type into run box)

运行添加或删除程序(在运行框中输入)
Repair Microsoft Visual Studio 2015 Shell (Isolated) (Modify > Repair)

修复Microsoft Visual Studio 2015 Shell(隔离)(修改>修复)

#3

For SSMS 2017 delete this folder from the registry:

对于SSMS 2017，从注册中心删除该文件夹:

HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\14.0_Config

It would be better to export the keys before deleting them.

最好在删除键之前导出它们。

#4

Remove every version installed of visual C++, then run the repair on the Visual Studio 2015 Shell (isolated). Once completed, open the SQL Server Management Studio and it will work.

删除所有安装的visual c++版本，然后在visual Studio 2015 Shell上运行修复(隔离)。一旦完成，打开SQL Server Management Studio，它就会工作。

#1