locked
'Cannot find one or more components. Please reinstall the application.' when starting SSMS 2016 RRS feed

  • Question

  • I upgraded SQL Server Manager 2016 and I receive the message 'Cannot find one or more components. Please reinstall the application.' when starting the application. SQL Server 2016 Express works fine. Reinstalling SSMS doesn't work, repairing SSMS also doesn't work. I am interested to hear how I can find out which components are missing and how I can reinstall them.
    Friday, June 10, 2016 1:24 PM

Answers

  • Hi Jorrit,

    Based on my research, as SQL Server Management Studio(SSMS)  depends on Visual Studio Shell, the above error could occur when Visual Studio Shell was removed or corrupted, which makes SSMS not working. Please perform the following steps to resolve this issue.

    1. Start regedit.exe

    2. Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio

    3. Delete 13.0_Config

    4. Restart ssms.exe

    However, if you still fail to start SSMS 2016 after performing the above steps , please reinstall Visual Studio 2015 Shell, then reinstall SSMS 2014 again.

     

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, June 13, 2016 2:30 AM

All replies

  • Hi Jorrit,

    Based on my research, as SQL Server Management Studio(SSMS)  depends on Visual Studio Shell, the above error could occur when Visual Studio Shell was removed or corrupted, which makes SSMS not working. Please perform the following steps to resolve this issue.

    1. Start regedit.exe

    2. Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio

    3. Delete 13.0_Config

    4. Restart ssms.exe

    However, if you still fail to start SSMS 2016 after performing the above steps , please reinstall Visual Studio 2015 Shell, then reinstall SSMS 2014 again.

     

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, June 13, 2016 2:30 AM
  • You can download re-do the setup of SQL SERVER 2016 express, or even try SQL SERVER express 2014 by downloading the set-up file of Express version "with advanced options".

    Many Thanks & Best Regards, Hua Min


    Monday, June 13, 2016 3:41 AM
  • I did the sensible thing and restored a backup. I remember that I tried reinstalling both SQL Server Management Studio and the Visual Studio 2015 isolated shell. Both reinstalls did not work.
    Thursday, June 16, 2016 10:20 AM
  • Hi,

    Can you try to set up SQL SERVER express with Advanced options (that is for SSMS) separately from VS 2015?


    Many Thanks & Best Regards, Hua Min

    Thursday, June 16, 2016 3:17 PM
  • I did the sensible thing and restored a backup. I remember that I tried reinstalling both SQL Server Management Studio and the Visual Studio 2015 isolated shell. Both reinstalls did not work.
    Did you tried Lydia Zhang solution (removing the registry key) ?

    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Thursday, June 16, 2016 4:09 PM
  • I was looking in the wrong place, this change worked! Thanks!
    Thursday, June 16, 2016 8:20 PM
  • .I have the same issue. But in my case i have a security blue/yellow shield on ssms executable  file.

       Every time i trying to start the application it asks me to confirm changes to computer components and than a very strange thing happens:

    new 13.0_Config created with some numbers after.

    So my registry after several tries to start sms looks like:

    13.0_Config

    Config_13.0_1234

    Config_13.0_1235

    etc

    Another strange thing is that i can start ssms with  different AD user, but not the current that is logged in 


    Friday, August 19, 2016 4:21 AM
  • Good day Dimitri ,

    1. it is best to open new thread if you have question, and add a link to old thread(s) that discuss the same issue, Instead of responding to a VERY old thread that was already closed.

    * If you open a new thread you have full control over it, which is another advantage.

    2. Image worth 1000 words

    Instead of trying to describe what you see, why not showing us?

    Please post 2 images, one clean and one with comment and mark the parts that seems strange to you.

    * by the way, I do not follow this specific forum usually. I works more in the code forums like T-SQL, but sometimes I check all question regarding SQL Server category in general...


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]


    • Edited by pituachMVP Monday, August 22, 2016 2:33 AM
    Monday, August 22, 2016 2:31 AM
  • Apologies if it is now too late to continue this thread.

    I have downloaded and installed the basic SQL Server 2016 Express and SQL Server Management Studio.  On trying to open the latter, I get the error: "Cannot find one or more components. Please reinstall the application."  I have done this several times - always with the same error.  Furthermore, I do not have an entry of HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio in the registry.  The closest is HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\130 containing 'Default' and 'Customer feedback'.  I am trying to get SSMS working so I can configure and use Sage accounting software for a charity.  Any help much appreciated. 

    Monday, December 12, 2016 3:19 PM
  • After spending a day repairing, uninstalling and reinstalling and corrupting my VS Pro installation, I came across your solution.  It worked GREAT!
    Thursday, March 9, 2017 4:18 PM
  • I didin't find the path HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio what should i do
    Friday, September 29, 2017 6:01 PM