I have attempted installing an update to Microsoft SQL Server Data Tools into Visual Studio 2015 Professional. Upon doing so I receive the following error message:
Setup is missing an installation prerequisite:
-Microsoft SQL Server 2016 System CLR Types. To continue, install SQL Server 2016 System CLR Types from http://go.microsoft.com/fwlink/?LinkID=398158 and then run the Setup operation again.
The hyperlink provided by Microsoft actually takes me to Microsoft SQL Server 2014 Feature Pack. Nonetheless, I continue to install
ENU\x64\SQLSysClrTypes.msi. Just to be extra sure, I navigated to Microsoft SQL Server 2016 Feature Pack and installed
ENU\x64\SQLSysClrTypes.msi from the latest version of SQL Server.
When running the SQL Server Data Tools installer again I receive the same fatal error in the installer message and log file. The log file reports the error code
0x80070643. The most helpful article I have found relating this issue is KB976982. I have tried running the Microsoft .NET Framework Repair Tool; the tool failed to resolve the problem and I am continuing to work through it.
I have tried to open my VS professional 2015 with update 3 and go to Tools-Extensions and Updates… and Updates-Product Updates and there should have an update for SSDT, click ‘Update’ button to install, it installed successfully.
If this behavior not works for you, you can go to Control Panel—Programs and Features and uninstall the Microsoft System CLR Types for SQL Server 2016 items and earlier versions then navigate to the Microsoft® SQL Server® 2016 Feature Pack and download ENU\x64\SQLSysClrTypes.msi and ENU\x86\SQLSysClrTypes.msi, then install them. After that, install the above SSDT again. Meanwhile, make sure you are login as the local admin account not a domain account to do this installation.
BTW, the error code 0x80070643 is a general error code, the root cause of this failed installation should be recorded in the log file, you can also use http://aka.ms/vscollect to gather the installation logs. After using it, you will find vslogs.zip under %temp% folder then upload the file to https://onedrive.live.com/ and share the link here.
I got the same issue and above solution (Updating SSDT) didn't work for me. So, here is the working solution with step by step instructions:
Hope it will help someone! :)
User contributions licensed under CC BY-SA 3.0