SQL SERVER – Unable to Launch SSMS Error – Cannot Find One or More Components. Please Reinstall the Application

SQL
22 Comments

Recently, one of my virtual machines started behaving strangely. I had SSMS 17.1 installed on the machine and it was working fine. I don’t remember what I installed, but I started facing an SSMS error. As soon as I click on SQL Server Management Studio (SSMS), it gives me below pop-up.

SQL SERVER - Unable to Launch SSMS Error - Cannot Find One or More Components. Please Reinstall the Application ssms-comp-error-01

I cannot find one or more components. Please reinstall the application.

As mentioned in the message, I already tried reinstalling the SSMS but the error didn’t go away. I searched on the internet and found one solution which worked for me.

SOLUTION/WORKAROUND – SSMS Error

The steps which worked for me were to repair Visual studio shell. It seems SSMS is dependent on the visual studio shell. As I mentioned earlier, My SSMS version was 17.1 and looks like it is based on a visual studio 2015 shell.

  1. Open the control panel and go to “Program and Featured”
  2. Search for the shell, as shown in the below image.

SQL SERVER - Unable to Launch SSMS Error - Cannot Find One or More Components. Please Reinstall the Application ssms-comp-error-02

  1. In my case, it was Microsoft Visual Studio 2015 Shell (Isolated). If the same error happens with lower versions of SSMS like SQL Server 2014 then I think it might be some different shell.
  2. Choose “Change” and selected the option to “Repair”SQL SERVER - Unable to Launch SSMS Error - Cannot Find One or More Components. Please Reinstall the Application ssms-comp-error-03
  3. After the repair, I restarted the machine and then I was able to launch SSMS.

The repair worked for me. If it doesn’t work for you then you may want to uninstall and then install it again It is a free download from Microsoft site.

Have you found a solution other than above? Please share it with others via command.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database
Next Post
SQL SERVER – Fix the Error – Accessing this Server via SQL Management Objects (SMO) or Distributed Management Objects is Currently Not Permitted

Related Posts

22 Comments. Leave new

  • Thank you.;.. very timely post. I recently experienced the same issue on one of our VMs!

    Reply
  • Junior Galvão - MVP
    December 8, 2017 5:14 am

    Hi,

    Great post, today i have this problem.

    Regards.

    Reply
  • thanks man, worked well

    Reply
  • Eugene van den Bergh
    May 16, 2018 3:15 pm

    Thanks Dave you’re the best, I messed up my SSMS after installing SSDT for VS2015. It worked without having to restart

    Reply
  • I have two windows 2016 VMS ,on one server there was no issue with SSMS but another server has similar error.

    I have repaired visual studio 2015 (isolated) uninstalled SSMS 17.X and reinstalled 16.X but still has the same error.

    if you find any other solutions please help me.

    Reply
  • Many thanks. It works great.

    Reply
  • Kenyon Stevens
    May 31, 2018 11:17 pm

    This worked for me!! You saved me a lot of headache

    Reply
  • Thank you to! …worked for me as well …thought I would have to rebuild my laptop

    Reply
  • Thank you! I had this exact problem, and your solution solved it for me. Last night Window 10 did an update of my system without telling me (I hate that) and in the morning, I could no longer run SSMS. I use it every day. Your solution got me back in business.

    Thank you!

    Reply
  • sumon bhuiyan
    June 26, 2018 5:22 pm

    Thank s…worked for me as well …thought I would have to rebuild my laptop

    Reply
  • Shaun Austin
    July 5, 2018 4:22 pm

    Thanks very much. I had this problem and these steps resolved it. I think the problem occurred because I tried to remove Visual Studio 2015 from my machine. The removal failed, however it looks like it may have partly removed some components that SSMS depends on.

    Reply
  • Worked! Thank you!

    Reply
  • Thank you! You’re a lifesaver

    Reply
  • Yes this solution Worked for me

    Reply
  • thanks its working

    Reply
  • I get the same problem today. In my case, it was Microsoft Visual Studio 2015 Shell (Isolated). Though it does not allow me to repair or change.
    I followed this steps.

    first uninstall Microsoft Visual Studio 2015 Shell (Isolated). Then reinstall it from https://visualstudio.microsoft.com/vs/older-downloads/isolated-shell/ the same version
    Restart the computer
    Able to open SSMS

    Reply
  • Hakim Chandio
    April 14, 2020 5:31 pm

    thanks that worked for me , i really appreciate your effort and i am following you since i was junior .

    Reply
  • Randall C. Jordan
    December 1, 2020 11:27 pm

    Unfortunately, this did not work for me. I have been trying to resolve this over a month. I have uninstalled Microsoft Visual Studio 2015 Shell (Isolated) numerous times. Tried to repair it and reinstalled it. Nothing works. Since I already installed SQL Server 2017, do I need to uninstall it and reinstall it, or do the applications work independently? Does Visual C++ 2017 need to be installed? I have never had such a hard time to get an application to work. Thank you for your assistance.

    Reply
  • Worked Well…

    Reply

Leave a Reply

Menu