SSMS 18.8 Install abort with "Failed to find expected public key in certificate chain"

Art Hansen 566 Reputation points
2020-12-22T17:19:52.383+00:00

[I couldn’t find a more specific forum so am posting here; please feel free to move this post to where it belongs if this particular forum is inappropriate]

SSMS 18.8 install aborts; Visual Studio & MS SQL installed, connected and functioning well. Details:

Environment
Win 10 1909 x64 (upgraded from Win7 10/1)

Visual Studio Community 2019

  • ,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

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

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:

Registering bundle dependency provider: {29fdeb7a-f6e5-40c3-a203-e306837e95a4}, version: 15.0.18369.0
Error 0x80070490: Failed to find expected public key in certificate chain.
Error 0x80070490: Failed to verify expected payload against actual certificate chain.
Error 0x80070490: Failed to verify signature of payload: VCRedistD14x86
[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.
Error 0x80070490: Failed to cache payload: VCRedistD14x86

The install tried 3 times to continue past the the above errors before aborting.

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”; I was unable to find a solution online

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.
Art

PS Complete logs can be provided if they would help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
Accepted answer
  1. Erland Sommarskog 101.4K Reputation points MVP
    2020-12-31T10:05:09.437+00:00

    Unfortunately, I can't say what your problem might be. While I have seen more than one person having problems with installing SSMS, I can't recall having seen errors related to certificates before.

    What I can say is that I have SSMS 18.8 installed myself, and that ran without problem. On more than one machine.

    So even if I don't know how to fix this problem, I think this is something specific to your environment, and that is why I asked about private vs. corporate. In a corporate environment, your IT department may have induced something that causes problem, for instance certificate revocations.

    What it could be in your case? I don't know. Maybe your anti-malware program. Maybe because it is old installation that has been upgraded.
    I can see four options for you:

    1. Dig around and try to find what the root cause may be.
    2. Flatten your machine and reinstall Windows.
    3. Stay put with SSMS 17.9.1.
    4. Move over to Azure Data Studio, which is the most recent effort from Microsoft. (Personally, I think it has a long way to go before it's on par with SSMS, but I've seen being very positive about ADS.)

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2020-12-23T03:15:41.6+00:00

    Hi @Art Hansen ,

    Did you try to install SSMS 18.7 or SSMS 17.9.1? You can get them from here.

    If they have the same issue, please let us know.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.