PowerShell install of SQL Server Data Tools fails, works manually

This topic contains 3 replies, has 3 voices, and was last updated by  Max Kozlov 1 year ago.

  • Author
  • #70780


    I'm installing SQL Data Tools via a PowerShell script. I run my script, but the final part where the Data Tools are installed fails (inside of the SQL installer window). If I run the script without that part, and install Data Tools manually it works.

    The error is:

    VS Shell installation has failed with exit code -2147205120.

    The parts before this install .NET, SQL Server Management Studio, and SQL SP1. I don't think they're relevant to my issue, but I will post that part if requested. Here are the relevant parts. This should install Data Tools and SNAC_SDK.

    Write-Host "Lauching SQL Server Data Tools install ..."
    Write-Host "Installer launched ..."
    Write-Host "SQL Server Data Tools installation failed"

    As it is now, it finishes the install with that error I posted, and has installed Visual Studio, but no Data Tools.

    If I run the installer manually (and check the two boxes for SSDT and SNAC_SDK) everything installs correctly.

    So the PowerShell installer is working... half way...

  • #70786

    Don Jones

    That's a "poorly built installer" problem. It's probably not something you can fix.

    • #70787


      Really? What makes you say that?

  • #70880

    Max Kozlov

    may be your error code means something similar to 'Block' ?

You must be logged in to reply to this topic.