SSDT installer missing prerequisite: SQL Server 2016 System CLR Types

2
votes

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.

2
sql-servervisual-studio-2015installationsql-server-data-toolssql-server-2016
What's the OS on your machine? Do you have the latest Windows Update installed? – Eddie Chen - MSFT
It was Windows 10 at the time with latest updates installed. – dkmann

2 Answers

3
votes

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.

1
votes

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:

  1. Open SQL Server 2016 Feature Pack
  2. Click on Download
  3. Select ENU\x64\SQLSysClrTypes.msi AND ENU\x86\ReportViewer.msi
  4. Click Next (Download will Start)
  5. Now Install both msi files
  6. Finally, Re-Install SQL Server 2016

NOTES:

  1. SQL Server 2016 Step by Step Installation Guide for Newbies
  2. Don't need to Un-Install existing installation
  3. Don't need to Create New Instance in installation process, just select older instance
  4. Tested on Windows 8 with Visual Studio 2015 update 3 on 14-August-2017

Hope it will help someone! :)