Solution For SSMS Error – Cannot Find One Or More Components

Few days back, I’ve uninstalled Visual Studio 2015 and all its components from my windows 10 pc and installed Visual Studio 2017. After doing this, I could not open the SQL Server Management Studio 2016 (SSMS). When I tried to launch SSMS, I was getting the below error message. I was using SQL Server Management Studio 2016  i.e. Version 16.5.3.

Cannot find one or more components. Please reinstall the application.

SSMS Cannot Find One Or More Components

On googling, I found several forums saying that it’s because the SSMS was looking for the uninstalled Visual Studio Shell. They also provided solution by  removing the registry folder entry HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\13.0_Config and restart the SSMS. But, removing the registry folder alone didn’t fix the problem for me. After several trials, finally the error got fixed and I’m able to start SSMS, after doing the below steps.

Solution Which Worked For Me

  1. Uninstall SQL Server Management Studio 2016.
  2. Make sure the registry entry HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\13.0_Config is not there. If it there, then remove it, after taking a backup of the registry.
  3. Download and install Visual Studio 2015 isolated shell. You can download the shell from ( https://download.microsoft.com/download/C/9/C/C9CA8400-20AA-4488-92A3-F3F6D978AD81/vs_isoshell.exe ).
    SSMS Cannot Find One Or More Components
  4. Reinstall SQL Server Management Studio 2016. You can get the latest version from ( https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms ).

Reference

Related Articles & Tools

Leave your thoughts...