I already had SQL Server 2019. After upgrading my Windows 10 to latest October Update, I found my SQL Server does not have latest service packs. I downloaded latest service pack CU8 from Microsoft and ran it. After initializing set up, I get error
Attempted to perform an unauthorized operation
Many research and no luck even in SO.
Please advise.
https://www.microsoft.com/en-us/edge/business/download
Please get the offline installer for latest Microsoft Edge (Chromium) on above link.
Once you have it, run Edge installer and then try to run SQL Update again.
This worked. I ran the latest Edge standalone install and it unblocked the MSSQL patch.
I also confirm that it works. Thanks
https://www.microsoft.com/en-us/edge/business/download
I can confirm this fixes the issue when trying to install SQL 2014 Express Advanced on Windows 10 with H2 update installed. I had the same error, and installing the standalone Microsoft Edge fixes the error.
After reviewing the logs and digging into windows registry and security, I found the problem was "Microsoft Edge" registry key. Somehow it is read-only for administrator and I figured it out I need to use SYSTEM account to apply the service pack.
Finally I found I can do that using an executable in SysInternals package which is famous for doing weird things in Windows.
This is what I did to apply the service pack.
.\PsExec64.exe -sid "D:\Downloads\SQLServer2019-KB4577194-x64.exe"
This way you will execute the service pack using SYSTEM account which has highest privilege.
Service pack installed successfully!