SQL Server Service Pack Upgrade is not triggered automatically




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.

No comments:
Write comments

Please do not enter spam links

Meet US

Services

More Services