none
SSDT 2017 Installed Keeps Failing: "Incorrect function 0x80070001" RRS feed

  • Question

  • My OS is Windows 7 Professional, with Service Pack 1. Every time I try to install SSDT 2017 it fails with the message "Incorrect function 0x80070001." See the log file below.

    What I've done to try and fix this so far:
    1. I've uninstalled all my old Microsoft SQL Server and Visual Studio programs (2008R2, 2014 and 2015 and SSDT 2015) and then tried re-installing them in order, restarting, and then installing Visual Studio 2017, restarting, and then SSDT 2017. 

    2. I've tried making sure my machine is completely updated, restarting and trying the install again. 

    3. I tried clearing all "temp" files, restarting, and trying the install.

     4. I've tried running the installer as an administrator.

    5. I also uninstalled all of my old SQL Server and Visual Studio programs and then just installing Visual Studio 2017 and SSDT 2017.

    6. I tried using the .NET Repair Tool, found here: https://www.microsoft.com/en-sg/download/details.aspx?id=30135

    None of these has fixed the problem. It's failing with that same error code every time. I've taken a look at the log file and the part where it starts to error out is here:

    [15C0:1ED8][2017-12-05T14:13:54]e000: Error 0x80070001: Process returned error: 0x1
    [15C0:1ED8][2017-12-05T14:13:54]e000: Error 0x80070001: Failed to execute EXE package.
    [1A68:1A1C][2017-12-05T14:13:54]e000: Error 0x80070001: Failed to configure per-machine EXE package.
    [1A68:1A1C][2017-12-05T14:13:54]i000: MainViewModel.OnPackageAction: Install Completed for package Microsoft SQL Server Data Tools for Visual Studio 2017 (id: VS_SQL)
    [1A68:1A1C][2017-12-05T14:13:54]e000: MainViewModel.GetVsInstances: Failed to get VS Instances: Object reference not set to an instance of an object., stackTrace:    at Microsoft.Sql.DataTools.ManagedBootstrapperApp.ViewModel.MainViewModel.GetVsInstances()
    [1A68:1A1C][2017-12-05T14:13:54]e000: MainViewModel.OnPackageAction: Cannot get SQL instance
    [1A68:1A1C][2017-12-05T14:13:54]i000: MainViewModel.OnPackageAction: Full list of installed instances: 

    [1A68:1A1C][2017-12-05T14:13:54]i000: MainViewModel.OnPackageAction: Wait for 30 seconds and see if VS_SQL has been installed...
    [1A68:1A1C][2017-12-05T14:14:24]e000: MainViewModel.GetVsInstances: Failed to get VS Instances: Object reference not set to an instance of an object., stackTrace:    at Microsoft.Sql.DataTools.ManagedBootstrapperApp.ViewModel.MainViewModel.GetVsInstances()
    [1A68:1A1C][2017-12-05T14:14:24]e000: MainViewModel.OnPackageAction: Cannot get SQL instance
    [1A68:1A1C][2017-12-05T14:14:24]i000: MainViewModel.OnPackageAction: Full list of installed instances: 

    And the list of installed instances is blank- I have no idea why it can't find the SQL instance or what this error message means.


    • Edited by emilypa29 Tuesday, December 5, 2017 11:04 PM
    Tuesday, December 5, 2017 11:01 PM

All replies

  • Same issue here.  Nearly identical logs as well.
    Wednesday, December 6, 2017 4:27 PM
  • I have the same issue. Has this been resolved?
    Saturday, February 3, 2018 1:39 PM
  • remove the folder: C:\Program Files (x86)\Microsoft Visual Studio\2017

    And everything is working now.

    Saturday, February 3, 2018 2:42 PM
  • Same issue
    Saturday, March 2, 2019 5:12 PM
  • Same issue

    Have uninstalled VS 2017 and removed the 2017 folder from Program Files (x86) but the error persists and I cannot repair modify or uninstall due to this error.

    Installing again results in an error saying Recursion Too Deep.

    Is there any way to force the removal?

    VS 2019 doesn't come with the Import/Export tool so I need to get this working hopefully without having to format the PC.


    Robin Wilson

    Wednesday, May 8, 2019 2:08 PM
  • 1- Go install Visual Studio,

    2- After completed Visual Studio installation, try to install SSDT (standalone installer),

    3- In SSDT setup Wizard there is 2 Instance choise now

     3.1 Visual Studio (Community 2017 for me)

     3.2 Install new SSDT instance

    4. Select Visual Studio and next.. next..

    Monday, July 29, 2019 11:33 AM