Unable to install Client Tools SDK for SQL Server 2017

Question

This is really a 2 part question -

Background: Needing to install the 64 bit version of dtswizard.exe on a user's win10 machine. (Only the 32bit version is on the machine presently, and user has 64bit office 2016 installed).
Some of the posts have said the 64bit version is there, just not on the start menu. I can confirm in this case, that the 64bit version is in fact NOT on the machine.

Problem: Several posts have suggested that installation of the Client Tools SDK and Client Tools Connectivity features from sql server will make the 64bit version available. When I run the installer,
it tells me that the prerequisites for the Client Tools SDK are met, but the installation fails, with the following error:

Detailed results:
Feature: Client Tools SDK
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then try the setup process again.

Problem is, there is no 'following information' to indicate what the error is, causing the installation to fail.

Anyone have any thoughts on why the client tools SDK install would fail with no details, or, how I can get the 64bit version of dtswizard.exe on the pc?

Thanks

Answer 1

Hi @cxc143 ,

I suggest you uninstall SQL Server and reinstall.
Remember to back up your databases before uninstalling.
The following are the steps to uninstall the sql server cleanly to prevent the subsequent installation from being affected.

1. Remove all SQL Server components from 'Programs and Features'
2. Backup the registry
3. Delete the following keys in regedit:
   --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
   --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
6. Reboot the machine
   In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.