SQLServerManagementStudio17找不到一个或多个组件

我刚刚升级到 VisualStudio2017Professional 和 SSMS 17。

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

SSMS 可执行文件在:

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

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

当我尝试在 VisualStudio 之外执行 SSMS 时，是什么导致了消息“ 找不到一个或多个组件。请重新安装应用程序”？要在 VSIDE 之外执行 SSMS，我需要做什么？

77008 次浏览
小开

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. 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.
小开

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.

小开

For SSMS 2017 delete this folder from the registry:

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

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

小开

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

Follow these steps:

  1. Run Add or remove programs (Type into run box)

  2. Repair Microsoft Visual Studio 2015 Shell (Isolated) (Modify > Repair)

The installation process will report that it was unable to install some of the Visual C++ executables as they are already present; this message can be ignored, the repair still fixes the problem reported in the question.

小开

In my case, it was corrupted because the drive that it was installed on originally was removed as part of a drive consolidation exercise. That is to say, it was installed on E:\ but E:\ no longer existed.

I managed to resolve by using VSubst (https://www.ntwind.com/software/utilities/visual-subst.html) and creating a fake drive pointing back to C:\ (run as admin) where there was a "fresh" install of 2015 after downloading the VS 2015 ISO.

I then re-ran the uninstaller, which fails, then inside the log file, on the first line is the path to the "old installer". Now if you run a {PathInLog}\vs_isoshell.exe /uninstall /force with the E:\ created it will force uninstall.

小开

Same steps as Roberto's solution above - but updated links:

1. Uninstall:

Microsoft Visual C++ 2015-2019 Redistributable (x86) - 14.xxxx
Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.xxxx

2. Repair or Download/Install:

Microsoft Visual Studio 2015 Shell (Isolated)

https://visualstudio.microsoft.com/vs/older-downloads/isolated-shell/

3. Reinstall:

Microsoft Visual C++ 2015-2019 Redistributable (x86) - 14.xxxx

https://aka.ms/vs/16/release/vc_redist.x86.exe

Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.xxxx

https://aka.ms/vs/16/release/vc_redist.x64.exe

小开

In my case, I accidentally uninstall Microsoft Visual Studio 2015 Shell (Isolated) and I got the error "SQL Server Management Studio 17 cannot find one or more components". even though I recover or Repair Microsoft Visual Studio 2015 Shell (Isolated), the same error was there.

  • The only thing I did was reinstall Microsoft Visual Studio 2015 Shell (Isolated). I did not Uninstall Microsoft Visual C++ 2017 Redistributable (both the x64 and x86). this worked for me.
小开

I had same issue and solved very easily. Normally SSMS will look for integrated application. This integrated is installed by default during SSMS setup installation.

I can say your error "Cannot find one or more components. Please reinstall the application" caused because some application is uninstalled or missing by anyhow. To open SSMS will look for some connected integrated application.

Please follow these steps:

  1. search "shell" in Control Panel\Programs\Programs and Features

  2. uninstall any "shell" application

  3. Download from Microsoft below application. "en_visual_studio_2015_shell_isolated_x86_dvd_XXXXXXXX"

  4. Run the application and allow all application to install during the process.

  5. Once everything is done. Restart your system.

小开

I'm running SSMS 18 and every time KB5014770 installs, I get this error. If I uninstall this upgrade (KB5014770) it starts working again.

小开

For everyone that is coming here in 2022 and has Windows 11 (build 22622.440) installed, this is your reason> Missing components for Microsoft Visual Studio 2017 Shell (isolated)

Disable the sv2 nav pane from experimental features from windows!

Download https://github.com/thebookisclosed/ViVe

Run vive tool from elevated cmd with the option to disable the experimental feature:

vivetool /disable /name:SV2Navpane

Restart windows immeadiatly:

shutdown -r -t 0

Taken from here, thanks to @Erin Stellato: https://feedback.azure.com/d365community/idea/6b7d06dc-9bec-ec11-a81b-6045bd7ac9f9


提交答案