Error in instaling SQL server 2016 0x800736FD SqlSupport_KatmaiRTM_Cpu64_1

Question

Hi,

During installation Sql Server 2016 Standard SP3 X64. I encountered this error:

I have Windows Server 2019 Standard. 64-bits

bellow error detail in log SqlSupport_KatmaiRTM_Cpu64_1

MSI (s) (EC:48) [16:05:57:729]: Assembly Error:An HRESULT could not be translated to a corresponding Win32 error code.

MSI (s) (EC:48) [16:05:57:729]: Note: 1: 1935 2: {51B6FD4C-6551-1104-A01F-C8B3B9A1E18E} 3: 0x800736FD 4: IAssemblyCacheItem 5: Commit 6: policy.8.0.Microsoft.VC80.ATL,version="8.0.50727.1833",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32-policy"
MSI (s) (EC:48) [16:05:57:729]: Assembly Error (sxs): Please look into Component Based Servicing Log located at %windir%\logs\cbs\cbs.log to get more diagnostic information.
MSI (s) (EC:48) [17:42:26:394]: Product: Microsoft SQL Server 2008 Setup Support Files -- Error 1935. An error occurred during the installation of assembly 'policy.8.0.Microsoft.VC80.ATL,version="8.0.50727.1833",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32-policy"'. Please refer to Help and Support for more information. HRESULT: 0x800736FD. assembly interface: IAssemblyCacheItem, function: Commit, component: {51B6FD4C-6551-1104-A01F-C8B3B9A1E18E}

Error 1935. An error occurred during the installation of assembly 'policy.8.0.Microsoft.VC80.ATL,version="8.0.50727.1833",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32-policy"'. Please refer to Help and Support for more information. HRESULT: 0x800736FD. assembly interface: IAssemblyCacheItem, function: Commit, component: {51B6FD4C-6551-1104-A01F-C8B3B9A1E18E}

I tried the following action but with no success :

• Restart Services : Windows Modules Installer & Windows Installer
• SFC tools >> Windows Resource Protection did not find any integrity violations.
• HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Edit DWORD..
• Reboot

Thank you in advance !

Hicham.

Answer 1

Hi @Cham JAFRANY ,

This may be more of a registry issue, the error will return when an incorrect registry setting prevents the Windows Modules Installer from running, please check if the Windows Modules Installer service is started, if not and you receive an error about "Insufficient system resources" error when trying to start it, it may be the origin of the problem

To solve it:
Open regedit and replace the value, navigate to the following location:

HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control  

In the registry editor, double-click RegistrySizeLimit, type: REG_DWORD, value:0xFFFFFF(4294967295), if unable to find this key, then create this key

Then reboot the machine, log in as an Administrator and open Command Prompt, run SFC /SCANNOW to check the integrity of system modules

Remember to install pending windows updates

Error: Error 1935: An error occurred during the installation of assembly

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello

Thank you for your question and reaching out. I can understand you are having issues related to SQL installation.

VC80 =Visual C++ , Download and install the following VC++ Redistributables

https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170

Also , I can see there also SQL 2008 is installed as per error log , Please try to Uninstall SQL 2008 as its legacy and no longer supported and may not work on latest version of Windows due to updated security protocols.

-----------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--