Setup Doesnot Start For Sql Server Service Pack Upgrade

I was upgrading my sql server 2012 setup from 2012 SP1 to SP2 but as you know my work never finish without issues “Lucky Me J”

Issue: Setup was extracting in temp folder and nothing happen after words even extract is clearing automatically.

Fix-Process:

• I try to run service pack setup using service account but no luck
• To see what’s there in errorlog  I jumped in errorlog location but nothing reported
• I verified event viewer and it’s also empty
• I verified service pack log directory “C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log” and  It’s also empty
• So last attempt was default temp folder for user, to open it type %temp%   in start – run and it will take you in temp folder location of user

Open the file “SqlSetup” and I found my error: “Cannot load .Net security policy file 0x80004005”

/*******************************************/

.Net version 3.5 is installed

.Net version 2.0 is installed

Patch related actions cannot be run from the local setup.exe, so continuing to run setup.exe from media.

Attempt to initialize SQL setup code group

Attempting to determine security.config file path

Checking to see if policy file exists C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\security.config

.Net security policy file does exist

Attempting to load .Net security policy file

Error: Cannot load .Net security policy file 0x80004005

Error: InitializeSqlSetupCodeGroupCore(64bit) failed

Error: InitializeSqlSetupCodeGroup failed: 0x80004005

Setup closed with exit code: 0x80004005

/*******************************************/

Solution:

So problem is very clear now:  Issue is with “.Net security policies” which is available @ C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\security.config as given in errorlog.

So we have to now reset .net security policy as its not allowing sql setup code to initialize but how to do that? And shashank srivastav comes to my rescue

Open Command prompt (Using Run as Administrator) and execute below:

“C:\Windows\Microsoft.NET\Framework64\v2.0.50727\caspol.exe -machine –reset”

If you are using 32 bit SQL, please use below:

“C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol.exe -machine –reset”

And now when I run service pack it finishes as smooth as butter.