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.

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

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

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

    You saved my life! Thank you very much.

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

    This worked perfectly. Thanks.

  3. Jun 28, 2017 at 3:29 am

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

Leave your thoughts...