Today I wanted to open Sql Server Management Studio 18 like every day. But this time an error message popped up:
Cannot find one or more components. Please reinstall the application.
And I reinstalled the application and even reinstalled the Microsoft visual studio 2015 Shell. What also confuses me is the fact that the shell 2017 of visual studio does not even exist yet. I'm working on a windows 11 machine.
Its a reported issued on Windows 11 22H2 (22621). See https://feedback.azure.com/d365community/idea/6b7d06dc-9bec-ec11-a81b-6045bd7ac9f9
After I uninstalled all Microsoft related Softwares in the control panel and reinstalled all again the SSMS started working. I just found out that you can also use Azure Data Studio as an alternative for SSMS, which is also sometimes preinstalled on windows machines.
EDIT
There is a solution provided in the forum that I'd like to share here:
vivetool /disable /id:36354489
shutdown -r -t0
In my case it returned No features were specified why I used another command:
vivetool /disable /name:SV2Navpane
shutdown -r -t0
If you're currently enrolled in Windows Insider Program and using Beta Channel,a fix for this issue was released just recently.