SQL Server Management Studio 18.11.1 Errors Galore!
While attempting to upgrade SSMS to version 18.11.1, it kept failing with a very odd error I'd never run across before. "MainViewModel.OnBundleAction: Bundle action failed: Fatal error during installation (0x80070643)" After trying many of the tips on the web like updating Visual C++ Redistributable, running a .NET repair, etc., I finally found the solution. I fired up trusty old Procmon64 and let it capture while I attempted to install SSMS 18.11.1. Once it failed, I went to Tools \ Count Occurrences and chose "Result". The count showed 222 "Access Denied" results. I double-clicked that line which took me to the list of "Access Denied". I found the ones that were the culprit. Evidently, SSMS 18.11.1 needs to install some help files and it couldn't access the HelpLibrary2 folder. My assumption was the permissions were incorrect, so I addressed that by running the following command from an elevated CMD prompt: icacls.exe C:\ProgramData\...