Our SQL DBAs was facing some issue with upgrading the SQL Service pack 3 with CU 6 on Windows 2008 R2 server. Whenever they ran the setup the black CMD screen runs and disappears, no error or events reported.
When we look at the SQLsetup Logs. You can find it from Temp folder, by running %temp%
12/09/2016 13:36:14.984 Checking to see if policy file exists C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\security.config
12/09/2016 13:36:14.985 .Net security policy file does exist
12/09/2016 13:36:14.986 Attempting to load .Net security policy file
12/09/2016 13:36:14.988 Error: Cannot load .Net security policy file 0x80004005
12/09/2016 13:36:14.993 Error: InitializeSqlSetupCodeGroupCore(64bit) failed
12/09/2016 13:36:14.993 Error: InitializeSqlSetupCodeGroup failed: 0x80004005
some .Net security problems which causing the setup to failed initiating.
Solution:
Run below command “C:\Windows\Microsoft.NET\Framework64\v2.0.50727\caspol.exe -machine -reset” on a command prompt run as administrator, It will ask you to confirm “altering security policy of .NET framework”
Note: If you are running x86 version of .net, you may use “Framework” instead of “Framework64”
