SQL Server Management Studio 17找不到一个或多个组件 [英] SQL Server Management Studio 17 cannot find one or more components

问题描述

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

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

我可以通过Visual Studio 17的SQL Server对象资源管理器访问服务器和数据库，但是当我尝试在VS IDE外部执行SSMS时，它告诉我"找不到一个或多个组件.请重新安装该应用程序".我已经重新安装了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.

SSMS可执行文件位于:

The SSMS executable is at:

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

我在运行VS 2017 Community的另一台计算机上遇到相同的问题.

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

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

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?

推荐答案

我遇到了类似的问题，在我的情况下，这是由于损坏的Microsoft Visual Studio 2015 Shell (Isolated)导致SSMS 17需要在VS IDE外部运行.

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.

要解决此问题，我必须执行以下操作:

To fix this, I had to do the following:

1. 卸载Microsoft Visual C++ 2017 Redistributable(x64和x86).这是为了确保步骤(2)将成功，因为如果已安装较新的版本，前提条件的修复过程在某些情况下可能会失败.
2. 修复Microsoft Visual Studio 2015 Shell (Isolated)(或使用 https://download.microsoft.com/download/C/9/C/C9CA8400-20AA-4488-92A3-F3F6D978AD81/vs_isoshell.exe ).
3. 重新安装Microsoft Visual C++ 2017 Redistributable( https://go.microsoft.com/fwlink/?LinkId = 746572 和 https://go.microsoft.com/fwlink/?LinkId= 746571 )(如果较早删除).

1. 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.
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).
3. Reinstall Microsoft Visual C++ 2017 Redistributable (https://go.microsoft.com/fwlink/?LinkId=746572 and https://go.microsoft.com/fwlink/?LinkId=746571) if removed earlier.

这篇关于SQL Server Management Studio 17找不到一个或多个组件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！