Unable to install SSDT 2017 tools for SSIS and SSRS

lcong 1 Reputation point
2021-09-16T23:08:47.123+00:00

I tried to install SSDT 2017 release 15.9.9 and keep getting a failure at Microsfot Visual studio for Application 2017. The VSTA2017.log keeps repeating the error below.
[4020:1824][2021-09-16T15:09:26]i304: Verified existing payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache.unverified\vsta_hostingcore_x86.
[4020:1824][2021-09-16T15:09:26]i305: Verified acquired payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache.unverified\vsta_hostingcore_x86, moving to: C:\ProgramData\Package Cache{9594C97E-6A20-38B3-81BB-2778C4780BE1}v15.0.27520\packages\vsta_hostingcore_x86\vsta_hostingcore_x86.msi.
[2C84:5558][2021-09-16T15:09:26]i000: MUX: Source confirmed
[4020:1824][2021-09-16T15:09:26]e000: Error 0x80070490: Failed to find expected public key in certificate chain.
[4020:1824][2021-09-16T15:09:26]e000: Error 0x80070490: Failed to verify expected payload against actual certificate chain.
[4020:1824][2021-09-16T15:09:26]e000: Error 0x80070490: Failed to verify signature of payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
[4020:1824][2021-09-16T15:09:26]e310: Failed to verify payload: cab9D11BAE11C8EDF380F5DC63624B6CC82 at path: C:\ProgramData\Package Cache.unverified\cab9D11BAE11C8EDF380F5DC63624B6CC82, error: 0x80070490, delete: Yes
[4020:1824][2021-09-16T15:09:26]e000: Error 0x80070490: Failed to cache payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
[2C84:5558][2021-09-16T15:09:26]i000: MUX: Verify Failed. Retry acquiring, Retry Count: 1 of 3

I have tried previous version and have no success.
Please advise.
Thanks
Lilly

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,514 questions
{count} votes

3 answers

Sort by: Most helpful
  1. PengGe-MSFT 3,321 Reputation points
    2021-09-17T02:59:39.47+00:00

    Hi @lcong

    Welcome to Microsoft Q&A!

    You can refer to this document to install SSDT.
    *
    Update:
    Have you tried Offline install? What is your operating system version?
    You can try to update the system to the latest version, install the latest .NET Framework and then run the installer in administrator mode.

    Sincerely,
    Peng
    *
    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments No comments

  2. PengGe-MSFT 3,321 Reputation points
    2021-09-23T06:59:00.893+00:00

    Hi @lcong

    Do you mean that you will encounter errors when installing SSDT according to the documentation tutorial?
    134586-image.png

    According to the system requirements of Microsoft Visual studio for Application 2017, you cannot install it for Visual Studio 2019.
    134562-image.png

    You need to install Visual Studio2017.

    0 comments No comments

  3. lcong 1 Reputation point
    2021-09-17T17:28:49.543+00:00

    Peng,
    Thanks for the reply.
    I followed that documentation when I installed SSDT. I'm using standalone version - Release 15.9.9.
    The installation hung at screen Microsoft Visual Studio Tools for Applications 2017.
    The VSTA2017log shows repeating messages (same as my previous post, I just uninstalled and reinstalled this morning). Please let me know my next steps.

    [5FEC:4C04][2021-09-17T09:36:53]i304: Verified existing payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache.unverified\vsta_hostingcore_x86.
    [5FEC:4C04][2021-09-17T09:36:53]i305: Verified acquired payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache.unverified\vsta_hostingcore_x86, moving to: C:\ProgramData\Package Cache{9594C97E-6A20-38B3-81BB-2778C4780BE1}v15.0.27520\packages\vsta_hostingcore_x86\vsta_hostingcore_x86.msi.
    [4A6C:6628][2021-09-17T09:36:53]i000: MUX: Source confirmed
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to find expected public key in certificate chain.
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to verify expected payload against actual certificate chain.
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to verify signature of payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
    [5FEC:4C04][2021-09-17T09:36:54]e310: Failed to verify payload: cab9D11BAE11C8EDF380F5DC63624B6CC82 at path: C:\ProgramData\Package Cache.unverified\cab9D11BAE11C8EDF380F5DC63624B6CC82, error: 0x80070490, delete: Yes
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to cache payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
    [4A6C:6628][2021-09-17T09:36:54]i000: MUX: Verify Failed. Retry acquiring, Retry Count: 1 of 3
    [4A6C:6628][2021-09-17T09:36:54]i000: MUX: Set Result: Return Code=-2147023728 (0x80070490), Error Message=, Result Detail=, Vital=True, Package Action=Verify, Package Id=vsta_hostingcore_x86
    [4A6C:6628][2021-09-17T09:36:54]e314: Failed to cache payload: cab9D11BAE11C8EDF380F5DC63624B6CC82 from working path: C:\Users\lilly\AppData\Local\Temp{f895a2f1-ae3f-4212-8af1-7fa1f8c212ea}\cab9D11BAE11C8EDF380F5DC63624B6CC82, error: 0x80070490.
    [4A6C:6628][2021-09-17T09:36:54]e349: Application requested retry of payload: cab9D11BAE11C8EDF380F5DC63624B6CC82, encountered error: 0x80070490. Retrying...
    [5FEC:4C04][2021-09-17T09:36:54]i304: Verified existing payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache{9594C97E-6A20-38B3-81BB-2778C4780BE1}v15.0.27520\packages\vsta_hostingcore_x86\vsta_hostingcore_x86.msi.
    [4A6C:6628][2021-09-17T09:36:54]i000: MUX: Reset Result
    [4A6C:6628][2021-09-17T09:36:54]i000: MUX: Source confirmed
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to find expected public key in certificate chain.
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to verify expected payload against actual certificate chain.
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to verify signature of payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
    [5FEC:4C04][2021-09-17T09:36:54]e310: Failed to verify payload: cab9D11BAE11C8EDF380F5DC63624B6CC82 at path: C:\ProgramData\Package Cache.unverified\cab9D11BAE11C8EDF380F5DC63624B6CC82, error: 0x80070490, delete: Yes
    [5FEC:4C04][2021-09-17T09:36:54]e000: Error 0x80070490: Failed to cache payload: cab9D11BAE11C8EDF380F5DC63624B6CC82
    [4A6C:6628][2021-09-17T09:36:54]i000: MUX: Verify Failed. Retry acquiring, Retry Count: 1 of 3

    Thanks
    Lilly