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 or higher. 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

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

  1. Jun 9, 2018 at 12:20 am

    This worked great! I use SSMS 2014 and it required VS2010 isolated shell.

    • Jun 9, 2018 at 9:49 pm

      Hi Pursuant, Great to know this solution worked for you.

  2. Tim
    Apr 8, 2018 at 4:01 am

    Thanks for this. I was just sitting down to do some training videos and I knew this worked last week but I was cleaning up my hard drive and must have deleted those files.

    • Apr 8, 2018 at 10:17 pm

      Hi Tim, Happy to hear that this helped you. Have a great day.

  3. Daniel Larkin
    Jan 27, 2018 at 7:40 am

    This was a great resource. Thanks for posting.

  4. John Spencer
    Jan 1, 2018 at 12:39 pm

    I can see there are many solutions offered for this situation. I could not get SSMS 17.4 to execute — No matter what I did. I see that for some persons, the above did work. It appears that a ‘clean reinstall’ of Windows is what would ‘solve’ this issue for some people. There has to be some .dll/registry entry that is causing this.
    I do have SSMA 17.4 running on a VM where VStudio was not installed — only has SQL server 2017 installed.
    My other machine has had several versions of VStudio and MSSQL server — this is the machine that will not run SSMS 17.4….
    I went back and am running SSMS 16.5. That version appears to run with no issues connecting to the MSSQL 2017 database instance running on the VM

  5. Dec 7, 2017 at 2:52 pm

    Yup, after windows update last month (november 2017) and this happened, multiple times reinstall the SSMS, and am glad this help. Thanks

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

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

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

    Thanks! Very helpful steps to get SSMS working again.

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

    You saved my life! Thank you very much.

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

    This worked perfectly. Thanks.

  10. Jun 28, 2017 at 3:29 am

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

Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.