Incorrect Function 0x80070001: SSDT Setup Failed [Fix]

Explore expert-recommended ways to fix the issue

Reading time icon 3 min. read

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Key notes

  • If you don’t have a Visual Studio license, you need to install Visual Studio Community Edition to install and use SSDT.
  • This guide will help you with all the available solutions to fix the issue.
_SSDT Setup Failed Incorrect Function 0x80070001 [Fixed]

If you are trying to install SQL Server Data Tools (SSDT) and getting Setup Failed incorrect function (0X80070001), then you are not alone. Don’t worry; it can be fixed.

This guide will explain all the reasons behind the issue and the available fixes. Let’s get started!

How can I fix the SSDT setup failed incorrect function 0x80070001?

Before diving into the detailed solutions, try these quick fixes first: 

If none of these worked for you, check out these detailed troubleshooting steps: 

1. Use the Registry Editor

  1. Press the Windows key, type CMD and click Run as Administrator.CMD elevated
  2. Type the following command and press Enter: chkdsk
  3. Copy and paste the following command and press Enter sfc/scannow
  4. Now, type in the following commands and press Enter after every command: DISM /Online /Cleanup-Image /CheckHealth DISM /Online /Cleanup-Image /ScanHealth DISM /Online /Cleanup-Image /RestoreHealthDISM and sfc COMMANDS
  5. Restart your computer once the scan is done.

2. Uncheck the automatic configuration script

  1. Press the Windows key, type Control Panel and click Open.Control Panel Open
  2. Select View by Large icons and click Internet Options.explorer_SSDT Setup Failed Incorrect Function 0x80070001
  3. Go to Connections and click LAN settings.LAN settings
  4. Under Automatic configuration, uncheck use automatic configuration script.LAN properties
  5. Click OK, then Apply and OK

3. Use Regedit

3.1 If you can locate TLS 1.0 Key

  1. Press Windows + R key to open the Run window.Registry Editor
  2. Type regedit and hit Enter to open Registry Editor.
  3. Follow this path:  Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client
  4. Right-click on Client, select DWORD (32-bit) Value, and name it Enabled.Registry Editor SSDT
  5. Double-click on the DWORD, change the Value data to 1, and click OK.

3.2 If you don’t have TLS 1.0 

  1. Press Windows + R to open the Run console.
  2. Type regedit and hit Enter.
  3. Follow this path: Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols
  4. Now right-click on Protocols, select Key and name it TLS 1.0.TLS 1.0
  5. Next, Right-click on TLS 1.0, click Key, and name it Client.
  6. Go to Client, right-click on it, select DWORD (32-bit) Value, and name it Enabled.Client Enabled
  7. Double-click the DWORD, change the Value data to 1, and click OK.Registry Editor SSDT

4. Perform offline installation

Note: If you encounter any error on the CMD screen, don’t worry; let the process get complete. 

  1. Download SSDT 2017 and Visual Studio.
  2. Save the .exe files for both at the same location. Now, press Windows, type CMD and click Run as administrator
  3. Locate the path where you downloaded the files, copy the path, and keep it aside.
  4. Type cd <path> to change the directory, just like this cd C:\Users\user\Downloads
  5. Now paste this command mentioned below and press Enter. This will initiate the installation, and files will be downloaded in the folder vs_SQL.exe --layout C:\ SSDT2017 \ -- lang en-us
  6. If you get any download errors, type the command mentioned below:  vs_SQL.exe --layout C:\SSDT2017 --fix
  7. Now type the following path one by one and press Enter: cd C:\SSDT2017 vs_setup.exe  --NoWeb
  8. Click the Install button on the installation wizard to install Visual Studio Data Tools 2017.
  9. Now, double-click the SSDT-Setup-ENU.exe, and on the installation wizard, put a checkmark beside SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services, and click Install.
  10. Please wait for the installation to complete and restart your computer when prompted.

So, these are steps to resolve the SSDT setup failed incorrect function 0x80070001. Try these methods and let us know which worked for you in the comments section.