SQL 2012 Data Mining Add-in for Office 2013 prerequisites error

  • Article

If you try to install the Data Mining Add-in into Office 2013 the setup may fail with the prerequisite error. This may happen if you are using the ClickToRun install of Office, chances are you still have Office 2010 or another version side-by-side, as ClickToRun  doesn’t uninstall previous versions of Office that are installed. 

Error:

Setup is missing prerequisites:

- 32-bit version of Microsoft Office 2010

Go to https://go.microsoft.com/fwlink/?LinkID=216742

clip_image002

 

The resolution is to use the Service Pack 1 version (or later) of the SQL Server 2012 Data Mining Add-ins. This download is for 2012 SP1:

https://www.microsoft.com/en-us/download/details.aspx?id=35578

 

There is a way to hack it a bit by telling the installer that Office is installed, and skipping the check by doing this kind of command line:

MSIEXEC /I C:\temp\SQL_AS_DMAddin.msi OFFICE2010PRESENT=1