Installing SQL Service Pach or Hotfix does nothing;
In general all the install logs will be available at Setup Bootstrap (Example: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log ), however you will not be able to see any additional infomration.
Before moving QL setup logs, temporary logs will be stored at %temp%, locate sqlsetup.log file from %temp% folder and check for error!
Fix is to reset security policy setting using below command (Ref: https://docs.microsoft.com/en-us/previous-versions/dotnet/netframework-4.0/bk67a586(v=vs.100)?redirectedfrom=MSDN )
caspol –machine –reset
- You will not be able to execute the command from Powershell but use command prompt
- The tool is available in multiple .net framework locations but choose the correct one (Example, resetting .NET 4.5 did not help to fix the problem but resetting from v2.0x helped to fix the problem)
- Sample Screenshot: