Tuesday, October 2, 2012

Issue 4 :- Applying SP2 on SQL Server 2008 and it shows black CMD screen and then it disappears.


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


  1. Would be great if this worked but when attempting to run this command

    ERROR: 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 for more information.

    For usage information, use 'caspol -?'

    1. Great Article IoT Projects for Students

      Deep Learning Projects for Final Year

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. Great! it works for me too.
    Only 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...

  3. 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.
    Anil G

  4. Great! It works for me while installing SQL 2012.

  5. I have encountered the same problem while upgrading SQL-2012 SP2, your solution worked.

    Hitesh Patel

  6. 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!

  7. worked for me, had to run the caspol in both folders though.

  8. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on. SQL server dba Online Training

  9. Thanks for sharing such a great information..Its really nice and informative..

    office 365 sharepoint training

  10. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...

  11. Highly informative article. This site has lots of information and it is useful for us. Thanks for sharing . top 10 micronutrients company in india

  12. Recovering the data base
    At 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