Windows 10: Install Error: Failed to find expected public key in certificate chain

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 DLd 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 Microsofts 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 Id much prefer being able to access the full capabilities of SSMS.

Any constructive advice will be much appreciated.

:)

 

SCEP Server(sub-CA) issues only once CA certificate instead of certificate chain

Hi ,

I configured a CA server in windows server 2008 with rootCA(windows server 2008)-->SubCA1(windows server 2008)--->SubCA2 (windows server 2008)

and configured NDES in SubCA2 and when I send a SCEP request to subCA2 .

It issues me a certificate and CA certificate(public key) and CA certificate only has subCA2 certificate but does not present a certificate chain .

But when I go to issued certificates in SubCA2 it shows the entire certification path till rootCA. Is there a way to send entire certificate chain to SCEP client or is this expected behavior

 

Certificate error - Windows 10 / Accessing Router

A follow up. I should have included this in the original question.

• failed: System.Security.Authentication.AuthenticationException A call to SSPI failed, see inner exception. < The certificate chain was issued by an authority that is not trusted for pipe (CN=*.dropbox.com, O=DO_NOT_TRUST, OU=Created by Fiddler - Web Debugging Proxy - Telerik).
• 18:11:34:7336 !SecureClientPipeDirect failed: System.Security.Authentication.AuthenticationException A call to SSPI failed, see inner exception. < The certificate chain was issued by an authority that is not trusted for pipe (CN=*.dropbox.com, O=DO_NOT_TRUST,
  OU=Created by http://www.fiddler

No idea why this is referencing DropBox but maybe that's a Fiddler thing?

 

KB4025339 Fails Install 0x80070564

Thanks
I am trying Eagle 51's suggestions now. Windows Update troubleshooter found a bunch of errors and fixed all but one.The update is trying to download KB4025339 again. I'll see what happens. At step one troubleshooter finishes with one error unresolved "Potential Windows Update Database Error Detected-Not Fixed". Windows update stalled at 0%.

At step 2 same troubleshooter error. The KB finished a new download failed to install.
Did step 3 KB has downloaded but fails to install.

If Eagle's suggestion doesn't work I'll try EdTittel's suggestion

Tried bothe Eagle & Ed 's suggestions - do not work. Anyone else?

I have noticed that the latest update for my nvidia drivers has failed to update. Wondering about that!