Error opening  SSMS -  Cannot find one or more components. Please reinstall the application .

Randy Roberts
Randy Roberts used Ask the Experts™
on
SSMS error during install on SQL Server  Enterprise 2012 R2. cannot find one or more components. Please reinstall the application . Looks like I am missing feature Microsoft Visual Studio Shell (Intergrated) - ENU version 10.0.40219. That's the different between server that's working a the problem one.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Shaun VermaakTechnical Specialist
Awarded 2017
Distinguished Expert 2018

Commented:
Not trying to be funny, what happens if you reinstall it?

Author

Commented:
Same thing. I even reinstalled twice.
Software Engineer
Top Expert 2011
Commented:
Usually caused by Real time scanning on anti-virus software try :

1. Uninstall SSMS
2. Restart your computer
3. Clear the temp folder c:\users\userName\AppData\Local\Temp
4. Disable Anti-virus
5. Install SSMS
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Install for SSMS will not run. I start the setup and it just goes away.

Author

Commented:
Had reboot 2 times for some reason to get the uninstall for ssms to start working.

Author

Commented:
Did everything Paul ask to do. Still getting the same error. Cannot find one or more components. Please reinstall the application.
Paul JacksonSoftware Engineer
Top Expert 2011
Commented:
Which version of SSMS are you trying to install? The reason I ask is because since SSMS 2016 Microsoft has been using the Microsoft Visual Studio Shell (Isolated) for SSMS so curious as to why its giving this error for the Integrated version.

Is there any Visual Studio IDE Software installed on the server?

Can you have a look at the install logs from c:\users\username\AppData\Local\Temp  and post the relevant error(s).
Nakul VachhrajaniTechnical Architect, Capgemini India
Commented:
If this is a bootstrap package, the installer may not be able to download a pre-requisite.
The new standalone SSMS will work with SQL Server 2012. You can try installing the same: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Author

Commented:
Did all that Paul said to do. Still getting same error.
Paul JacksonSoftware Engineer
Top Expert 2011
Commented:
Try doing a repair of your SQL Server instance using the SQL Server software installation media.
Is it the new SQL Server 2017 SMS that you are trying to install?
Did you see any errors in the installation logfiles?

Author

Commented:
Running the repair. Then i will try SQL Server 2017 SSMS.

Author

Commented:
Thank you Nakul . Looks like SQL Server 2017 SSMS worked. At least it open.
Paul JacksonSoftware Engineer
Top Expert 2011

Commented:
Redo as incorrect comments selected

Author

Commented:
Thanks for everyone's help. Just hope it work for my AlwaysOn Servers because one side will be 2017 SSMS and the other 2012 SSMS.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial