My company has SQL Server 2008 (not R2) and Office 2010. I checked the Excel Data Mining Add-in downloads on both the Microsoft site and SQLServerDataMining.com looking for this combination but cannot find it. The DM Addin for Office 2010 are all SQL Server 2012 and the SQL Server 2008 version has Office 2007. I installed the SQL Server 2008/Office 2007 add-in but it keeps getting disabled. I get an error message stating that there are compatibility issues. Does anyone have an idea on what the best add-in is to install? There are many users in the organization and the version of SQL Server is way above my pay grade.
The Data Mining Add-ins for SQL Server 2008 is a free download that can be used with either Excel 2007 or Excel 2010. When you use the data mining add-ins, you can connect to an existing instance of SQL Server 2008 Analysis Services and use the data mining algorithms and services provided by that server to perform data mining on the data in your Excel workbook and other supported data sources.
To use both add-ins on the same computer, you must install the same version of both add-ins. Each version requires the corresponding version of Excel. When installing SQL Server 2008 Data Mining Add-Ins and it can be used together with 32-bit version of Microsoft Office 2010 . In addition, if you are running a version of Windows other than Windows 7, you will need to download and install .NET Framework 3.5 SP1. For more information, see: http://social.technet.microsoft.com/wiki/contents/articles/1090.how-to-use-the-sql-server-data-mining-add-ins-with-powerpivot-for-excel.aspx
There is detail about how to troubleshoot installations of add-ins, you can review it.
TechNet Community Support
Choose the version that matches your Office (2010).
There were almost no changes in SQL Server data mining since 2008 (except bug fixes) so it should work. I believe that Microsoft states that 2010 version only works with SQL Server 2012 because Microsoft didn't test other configurations.
I used data mining add-ins for Office 2010 with SQL Server 2008 R2 several years ago and don't remember having any problems.
If you continue running into issues, you can take a look at Predixion Insight. This product was developed by the same people as data mining add-ins but has many new features. Cloud version of Predixion Insight does not require SQL Server at all. You can get it at http://predixionsoftware.com/Technology/Predixion-Insight-Download
Tatyana Yakushev [PredixionSoftware.com]