KB5014770 is a part of Windows Insider Windows 11 Insider Preview Build 22621.160 to the Beta Channel. So such annoying things are natural in insider program
Solution to ssms18 stopping working is result of the update KB5014770 how do I stop windows from updating this again?
in the post "ssms18 Microsoft Visual Studio 2017 Shell (Isolated) Cannot find one or more components. Please reinstall the application."
A user FredTakiya-1624 mentioned a recent update KB5014770
On uninstalling it SSMS started working again
I did this and it worked.
The issue is with KB5014770 how do I stop it from reupdating until this is resolved.