I'm attempting to install MS SQL Server Management Studio (SSMS). The tool is a GUI for designing, defining, building and maintaining MS SQL databases. It is part of a "suite" comprised of Visual Studio, MS SQL server and SSMS. Whilst the 3 components of the "suite" are designed to work together they are presented as individual products.

I have successfully installed and connected Visual Studio and SQL Server but the SSMS install is aborting during cert check.

Product details:
Visual Studio Community 2019 w/the following modules:

  • ,NET desktop development
  • Universal Windows Platform
  • Game development w/Unity
  • Data storage and processing


MS SQL Server 2017 developer x64 (i.e., v14.00.100)

  • Installed as stand-alone instance on localhost


SQL Server Management Studio 18.8 [install aborting with error 0x80070490]

Everything DL ‘d from MS sites.

Searching on the error code results in hits for Windows Update problems or a corrupted component in CBS although the actual error description in the install log provides the following detail:

  1. Registering bundle dependency provider: {29fdeb7a-f6e5-40c3-a203-e306837e95a4}, version: 15.0.18369.0
  2. Error 0x80070490: Failed to find expected public key in certificate chain.
  3. Error 0x80070490: Failed to verify expected payload against actual certificate chain.
  4. Error 0x80070490: Failed to verify signature of payload: VCRedistD14x86
  5. [0E34:1818][2020-12-22T06:01:14]e310: Failed to verify payload: VCRedistD14x86 at path: C:\ProgramData\Package Cache\.unverified\VCRedistD14x86, error: 0x80070490. Deleting file.
  6. Error 0x80070490: Failed to cache payload: VCRedistD14x86


Actions taken thus far:

  • Reset permissions via Windows cmd run as nt authority\system:

[C:\Windows\SysWOW64\subinacl.exe /subkeyreg HKEY_LOCAL_MACHINE [/grant=administrators=f /grant=system=f]]
===> Done: 359360, Modified 271478, Failed 87882, Syntax errors 0
[C:\Windows\SysWOW64\subinacl.exe /subkeyreg HKEY_CURRENT_USER [/grant=administrators=f /grant=system=f]]
===> Done: 1435, Modified 1435, Failed 0, Syntax errors 0
[C:\Windows\SysWOW64\subinacl.exe /subkeyreg HKEY_CLASSES_ROOT [/grant=administrators=f /grant=system=f]]
===> Done: 210454, Modified 129369, Failed 81085, Syntax errors 0
[C:\Windows\SysWOW64\subinacl.exe /subdirectories %SystemDrive% [/grant=administrators=f /grant=system=f]]
===> C:\Windows\System32 : delete Perm. ACE 5 builtin\administrators
===> C:\Windows\System32 : delete Perm. ACE 4 builtin\administrators
===> C:\Windows\System32 : new ace for builtin\administrators
===> C:\Windows\System32 : new ace for builtin\administrators
===> C:\Windows\System32 : 4 change(s)
===> C:\Windows\System32 : delete Perm. ACE 3 nt authority\system
===> C:\Windows\System32 : delete Perm. ACE 2 nt authority\system
===> C:\Windows\System32 : new ace for nt authority\system
===> C:\Windows\System32 : new ace for nt authority\system
===> C:\Windows\System32 : 4 change(s)
All errors were “access denied”.

  • Ran DISM.exe /Online /Cleanup-image /checkhealth || “repairable” problems found
  • Ran DISM.exe /Online /Cleanup-image /restorehealth || Aborted at 62.3% complete with a “source file not found” error
  • Reran DISM.exe /Online /Cleanup-image /restorehealth /Source:"M:\sources\install.wim" || Aborted at 62.3% complete with a “source file not found” error
  • Performed an in-place upgrade repair using Win10 ISO DL’d from MS
  • Ran the Update Troubleshooter which found a “Problem with BITS service : The requested service has already been started. System.Management.Automation.RemoteException More help is available by typing NET HELPMSG 2182. System.Management.Automation.RemoteException”


None of the above listed actions resolved the SSMS 18.8 install abort.

I found a SSMS version in Microsoft’s archived versions (Microsoft SQL Server Management Studio 13.0.16106.4) that will install but when I try to create a data model or add/define new tables this error is displayed “This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)”.

Tables can be added via Visual Studio but the functionality supporting column/field definition is fairly rudimentary. I was able to finally figure out how to get my primary keys to auto-increment by adding IDENTITY in the code but since my last time actively working with RDBs was 1988 I’d much prefer being able to access the full capabilities of SSMS.

Any constructive advice will be much appreciated.