Answered by:
'Cannot find one or more components. Please reinstall the application.' when starting SSMS 2016

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 ZhangLydia Zhang
TechNet Community Support- Marked as answer by Jorrit Schippers Thursday, June 16, 2016 8:21 PM
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 ZhangLydia Zhang
TechNet Community Support- Marked as answer by Jorrit Schippers Thursday, June 16, 2016 8:21 PM
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
- Edited by Jackson_1990 Monday, June 13, 2016 3:53 AM
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) ?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!
- Edited by Jorrit Schippers Thursday, June 16, 2016 8:21 PM
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...
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 doFriday, September 29, 2017 6:01 PM