Share via

SSDT 2017 installation error 0x80070001

  • Article

Question

Thursday, June 14, 2018 6:00 AM | 1 vote

Hello.

I am trying to install Microsoft SQL Server Data Tools 2017 (release 15.7.0) onto a Windows 10 (build 1803) workstation but it fails with error 0x80070001.  The log file is large but this stands out near the end:

[1D30:1CE4][2018-06-12T14:21:56]e000: Error 0x80070001: Process returned error: 0x1
[1D30:1CE4][2018-06-12T14:21:56]e000: Error 0x80070001: Failed to execute EXE package.
[1F98:1F9C][2018-06-12T14:21:56]e000: Error 0x80070001: Failed to configure per-machine EXE package.

Can anyone help translate this pointless error into something helpful?  I have tried these suggestions to no avail:

https://stackoverflow.com/questions/46421619/ssdt-installation-issue-failed-to-execute-exe-package/47645278

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/881b5ad0-5f7d-47bf-bb5f-c896625c477a/ssdt-2017-installed-keeps-failing-quotincorrect-function-0x80070001quot?forum=ssdt

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5c41001f-7d93-4318-96c7-75fa3c416605/offline-installer-for-ssdt-2017?forum=ssdt

Thanks,
Ted

All replies (3)

Thursday, July 19, 2018 9:05 AM âś…Answered | 2 votes

OK, I finally managed to make this work.  I followed this guide:

https://blogs.msdn.microsoft.com/sqlmeditation/2018/06/21/how-to-install-sql-server-data-tools-ssdt-offline-with-no-internet-connection/

but it failed.  It didn't seem to create the instance because at step 6 it still wanted to create it.  So I went back to step 4 and ran the following instead:

vs_setup.exe --nickname ssdt -noweb

This installed everything I needed and I was able to continue to step 6 and install SSRS, SSIS into the existing instance.

This took weeks to figure out - I hope someone else can benefit from this post.

Thursday, June 14, 2018 12:00 PM

Digging further into the log I found this:

The current operating system is not supported. This application requires at least Windows 7 SP1 or Windows 8.1 to run.

Does SSDT 2017 not work with Windows 10?  Do I need to downgrade to Windows 7?  I have Windows 10 Pro 64bit (build 1803)

Wednesday, April 3, 2019 11:44 AM

It did help.  And thank you so very much.