Hi,
Once I faced a issue when I was applying SP2 on SQL Server 2008R2. Whenever I clicked the setup icon the black CMD screen runs and disappears. Nothing happened after that and every time I click the setup icon the result is same. Then I thought that SP2 might me corrupt, so i downloaded a new SP2, but it also behaved like the earlier one. After much effort I was able to rectify the problem using the below steps.
The .Net error : the SQLsetlog gives below error
Error: Cannot load .Net security policy file
Error: InitializeSqlSetupCodeGroupCore(32bit) failed
Error: InitializeSqlSetupCodeGroup failed: 0x80004005
Setup closed with exit code: 0x80004005
Ran in cmd : C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol.exe -machine -reset
if you have 64 bit then use Framework64
Would be great if this worked but when attempting to run this command
ReplyDeleteERROR: Runtime error: This method explicitly uses CAS policy, which has been obs
oleted by the .NET Framework. In order to enable CAS policy for compatibility re
asons, please use the NetFx40_LegacySecurityPolicy configuration switch. Please
see http://go.microsoft.com/fwlink/?LinkID=155570 for more information.
For usage information, use 'caspol -?'
Great! it works for me too.
ReplyDeleteOnly by the sentence 'if you have 64 bit then use Framework64.'
I have seen lot of URL mentioning C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol.exe -machine -reset
but only your suggestion clicked for me to use Framework64
Thanks a lot...
Hey I have similar issue while installing SQL 2012 Core setup, its 64bit and this article helped me to bypass. thanks for taking time and documenting.
ReplyDeleteAnil G
Great! It works for me while installing SQL 2012.
ReplyDeleteThanks,
I have encountered the same problem while upgrading SQL-2012 SP2, your solution worked.
ReplyDeleteThanks,
Hitesh Patel
It works for me.
ReplyDeleteThanks,
Luis V.
how about installing sql 2014? Can I run the same line "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\caspol.exe -machine -reset" in cmd? Thanks in advance!
ReplyDeletenice post
ReplyDeleteSharePoint Online Training Bangalore
worked for me, had to run the caspol in both folders though.
ReplyDeletenice post keep updating like this Sql Server dba Online Training Bangalore
ReplyDeleteThanks for sharing such a great information..Its really nice and informative..
ReplyDeleteoffice 365 sharepoint training
Recovering the data base
ReplyDeleteAt Genex DBS data loss is only temporary and we prove it every day with the highest data recovery success rate in the industry. Our volume of recovered data speaks for itself.
For over 17 years, Data Storage Solutions has performed professional data recovery on every kind of storage device including Desktop hard drive data recovery, Laptop hard drives data recovery, External / USB hard disc Data Recovery / Hard Disc Recovery, Server and RAID arrays data recovery, NAS, SAN, DAS, SSD, Encryption storage devices data recovery, Database & File Recovery, CCTV Data Recovery, Flash Card Data Recovery. and enterprise-level devices like RAIDs. We have proprietary tools to handle every kind of data loss situation on any server including physical and mechanical failure, backup failure, water and fire damage, data corruption, file deletion, head crash, system failure, and more. We conduct all our data recoveries using software and solutions that won’t further damage your device.Genexdbs Database