I have a problem using SQLServer "data mining" addin on excel. Below are the programs installed on my PC:
- SQLServer 2016 CTP2.0 64bit
- Office 2013 pro plus 64-bit
- SQLServer 2012 data mining addin 64bit
I activated the data addition and connected to the analysis service database using the connection wizard. However, I do not see the name of the tab associated with the data mining tools in the feed; also an invisible tool under the table. Actually they are, but they do not have a shortcut. There is only a small empty tab area that I can click on all related data mining tools.
When I try to use any of these tools, it gives an error message:
"The object reference is not set to an instance of the object."
What could be the problem?
- Two years ago, I installed and used these dm tools on my previous PC with SQLServer 2012, but now I can not do it with version 2016. Is SQLServer 2012 for data mining only compatible with SQL Server 2012? I tried to find an updated version of addin but could not find.
- Do I need to set up a visual studio and create a new analysis service connection with it? I will not use the visual studio for any other purpose, so I do not want to install it if it is not needed.
source
share