question

LillyCong-0322 avatar image
0 Votes"
LillyCong-0322 asked PengGe-MSFT commented

Unable to install SSDT 2017 tools for SSIS and SSRS

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

vs-generalvs-extensions
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LillyCong-0322
I have not heard from you for a couple of days. Please let me know if there is anything that I can help here.

0 Votes 0 ·
PengGe-MSFT avatar image
0 Votes"
PengGe-MSFT answered PengGe-MSFT edited

Hi @LillyCong-0322

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LillyCong-0322 avatar image
0 Votes"
LillyCong-0322 answered LillyCong-0322 commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LillyCong-0322
I updated my answer, please check it.

0 Votes 0 ·

Hi Peng,
I I did off line install but still didn't work. The install still failed at the application tool 2017 screen with different errors. I have my latest net. framework and have VS 2019 professional.
I need SSDT 2017 for other projects, and I used to be able to install before. I have Window 10 Pro version 21H1.
Thanks
Lilly

0 Votes 0 ·
PengGe-MSFT avatar image
0 Votes"
PengGe-MSFT answered

Hi @LillyCong-0322

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.


image.png (129.2 KiB)
image.png (27.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.