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 error message “Cannot find one or more components” as displayed below. I was using SQL Server Management Studio 2016  i.e. Version 16.5.3.

SSMS Cannot Find One Or More Components

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

As the error message suggested, I tried re-installing SSMS. Still I was getting the same error. On googling, I found several forums saying that it’s because the SSMS was looking for the uninstalled Visual Studio Shell, which could have happened while I was uninstalling VS 2015. 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 and use it. Below are the steps I’ve followed.

Solution That 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

5 comments for “Solution For SSMS Error – Cannot Find One Or More Components

  1. Mert
    Sep 9, 2017 at 12:25 am

    Thx man, you saved my life. I mean it.

  2. Chris Gulden
    Aug 30, 2017 at 9:17 pm

    Thanks! Very helpful steps to get SSMS working again.

  3. Tiago
    Jul 12, 2017 at 10:57 am

    You saved my life! Thank you very much.

  4. Anjali
    Jul 8, 2017 at 4:54 am

    This worked perfectly. Thanks.

  5. Jun 28, 2017 at 3:29 am

    Thanks! This worked perfectly. You probably saved me hours of time

Leave your thoughts...