SQL Service pack failed due to .Net security issue (no error)


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”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s