SSIS installation Error: Unknown error (0x80131500) (0x80131500)

Xiong Fei 1 Reputation point
2022-10-19T09:32:25.317+00:00

Hi all,

Please help to resolve the SQL Server Integrations Services (SSIS) Projects extension installation error for visual studio 2019 professioal.

Visual studio version: Microsoft Visual Studio Professional 2019 Version 16.11.18

SSIS Extension Version tried: V3.16 and V4.1, both failed with Unknown error (0x80131500) (0x80131500).

I whitelisted the following folder to run executables (.exe):

  • %OSDRIVE%\ProgramData\Microsoft\VisualStudio\Packages*
  • %OSDRIVE%\ProgramData\Package Cache*

Still got errors.

Please help to resolve the issue, or advise on what to check for GPOs whitelisting.

Thank you.

251972-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
989 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2022-10-19T09:38:33.593+00:00

    Hi @Xiong Fei

    Did you get more related error message from setup log?

    251946-image.png

    Try to repair the VS via Visual Studio Installer.

    233303-image.png

    If this do not work, try to re-install SSIS project from VS extension below.

    251965-image.png

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  2. Xiong Fei 1 Reputation point
    2022-10-20T04:04:33.033+00:00

    Hi @ZoeHui-MSFT ,

    Thanks for your reply.

    I have tried to repair. I got error as the screenshot below.

    252268-image.png

    I cannot view the log file in the screenshot above. Please advise.

    0 comments No comments

  3. ZoeHui-MSFT 34,581 Reputation points
    2022-10-20T06:44:15.023+00:00

    Hi @Xiong Fei

    You may refer to below methods:

    1. Please navigate to this directory: C:\ProgramData\Microsoft\VisualStudio\Packages and look for the package which called Microsoft.VisualCpp.Redist.14,xxxxxxx(or similar). And then backup it and remove the whole folder. After that retry repairing VS 2019.
    2. I notice that your machine seems to be included in GPO. You may need to communicate with your administrator to check this, and if possible, please try to disable it to see if it blocks something.
    3. Please try to download and run this collect.exe tool: Download Microsoft Visual Studio and .NET Log Collection Tool from Official Microsoft Download Center. This tool will help to collect the VS setup log files. After it finishes running, please navigate to %temp% folder and look for a file called vslogs.zip, upload to OneDrive and share the link here, I will go to check it. Or you can extract it, and open the temp folder inside it, and check the related files which start with dd_, such as dd_bootstrapper, dd_installer and dd_setup…
    4. If it is possible for you, reinstalling VS may work. You can try to uninstall it from VS Installer and reinstall it.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  4. Xiong Fei 1 Reputation point
    2022-11-04T08:02:47.247+00:00

    @ZoeHui-MSFT , thank you for the reply.

    may i know more about collect.exe? how to install it? what info will be collected by this software?

    Thank you.