SQL Server 2014 Troubleshooting: Unable to install on Windows 7 machine and 2008 R2 Server

Error:

 

Error 1935.An error occurred during the installation of assembly 'policy.8.0.Microsoft.VC80.MFC,type="win32-policy",version="8.0.50727.42",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="x86"'. Please refer to Help and Support for more information. HRESULT: 0x80073712. assembly interface: IAssemblyCacheItem, function: Commit, component: {68B7C6D9-1DF2-54C1-A01F-C8B3B9A1E18E}

 

 

MSI (s) (80:4C) [16:36:00:551]: Product: Microsoft Visual C++ 2005 Redistributable -- Error 1935.An error occurred during the installation of assembly 'policy.8.0.Microsoft.VC80.MFC,type="win32-policy",version="8.0.50727.42",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="x86"'. Please refer to Help and Support for more information. HRESULT: 0x80073712. assembly interface: IAssemblyCacheItem, function: Commit, component: {68B7C6D9-1DF2-54C1-A01F-C8B3B9A1E18E}

** **

Cause:

The below reg and the files associated with in C:\Windows\winsxs\Manifests\ it seems to be incorrect.

 

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide\Winners\

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_none_e95fc02599af695c

** **

** **

Solution:

 

The SFC and CheckSur are coming clean and did not found any corruption.

Started the Procmon Analysis

 

We don’t see any errors in Procmon logs but found below

 

TrustedInstaller.exe was looking for below reg and was not able to see and we got the results "NAME NOT FOUND"

=============

8:54:36.9918851 AM TrustedInstaller.exe 3492 RegOpenKey HKLM\COMPONENTS\DerivedData\Components\x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.42_none_54c11df268b7c6d9 NAME NOT FOUND Desired Access: Read

8:54:36.9918851 AM TrustedInstaller.exe 3492 RegOpenKey HKLM\COMPONENTS\DerivedData\Components\x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.42_none_54c11df268b7c6d9 NAME NOT FOUND Desired Access: Read

===========

 

Further in the logs it seems that the msiexec.exe was trying to look for the below reg and again got the result "NAME NOT FOUND"


8:55:28.8092934 AM msiexec.exe 2608 RegQueryValue HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide\Winners

\x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_none_e95fc02599af695c\8.0\8.0.50727.42 NAME NOT FOUND Length: 144

8:55:28.8092935 AM msiexec.exe 2608 RegQueryValue HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide\Winners

\x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_none_fc7803bb717e28a6\8.0\8.0.50727.42 NAME NOT FOUND Length: 144


 

So below two reg we got it from the working machine and the and replaced it on non-working machine.

 

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide\Winners

\x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_none_e95fc02599af695c

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide\Winners

\x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_none_fc7803bb717e28a6

 


Also went to C:\Windows\winsxs\Manifests\ and found below files related to above reg.

 

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_4db05f807dd45954.cat

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_4db05f807dd45954.cat

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_4db05f807dd45954.manifest

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.4027_none_4daf0ae87dd59b6e.cat

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.4027_none_4daf0ae87dd59b6e.manifest

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.6229_none_4daee0dc7dd5c9a0.cat

x86_policy.8.0.microsoft.vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.6229_none_4daee0dc7dd5c9a0.manifest

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_49ed4131141912ee.cat

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_49ed4131141912ee.manifest

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.4027_none_49ebec99141a5508.cat

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.4027_none_49ebec99141a5508.manifest

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.6229_none_49ebc28d141a833a.cat

x86_policy.8.0.microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.6229_none_49ebc28d141a833a.manifest

 

 

So compared the size of the above files and with working one but found no difference. Still went ahead and ran below commands to take permission of the above files. And replaced them from the working machine with latest manifest & cat files.

 

To assign full control for the Administrators group on the folder and file.

 

cacls C:\Windows\winsxs\Manifests /E /T /C /G "Administrators":F

cacls C:\Windows\winsxs\Manifests\vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_4db05f807dd45954.manifest /E /T /C /G "Everyone":F

cacls C:\Windows\winsxs\Manifests\vc80.mfcloc_1fc8b3b9a1e18e3b_8.0.50727.1833_none_4db05f807dd45954.cat /E /T /C /G "Everyone":F

 

After this we started the installation again and "Microsoft Visual C++ 2005" Redistributable installed successfully, Also Microsoft SQL Server 2014 installed successfully.