Incorrect Function 0x80070001: SSDT Setup Failed [Fix]

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: 

• Delete all Temp files using Clean Manager.
• Restart your computer.
• Check for Windows Updates.
• Ensure Visual Studio 2017 is up to date.
• Set VSS to automatic.

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.
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 /RestoreHealth
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.
2. Select View by Large icons and click Internet Options.
3. Go to Connections and click LAN settings.
4. Under Automatic configuration, uncheck use automatic configuration script.
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.
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.
5. Double-click on the DWORD, change the Value data to 1, and click OK.

Read more about this topic

• Dell has a guide on how to identify an AI PC and confirms that AI Explorer is exclusive to Snapdragon X Elite CPUs
• Mechrevo reveals two high-end gaming laptops, both with external water-cooling
• Navigating compatibility challenges – Windows on ARM devices and x86-64 software
• Planning to buy a Hisense TV? It’s triggering weird problems on Windows PC

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.
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.
7. Double-click the DWORD, change the Value data to 1, and click OK.

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.