Data Mining Installation

lbar 1 Reputation point

I have Microsoft SQL Server Management application and I was wondering how I install data mining onto it. Do I need a separate application, do I need to download an add-in? Let me know, thank you in advance.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,206 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,806 Reputation points


    First of all, SSMS AKA Microsoft SQL Server Management application is just a management tool. To use Data Mining , you need to install SQL Server.

    Which version of SQL Server have you installed?

    For the versions before SQL Server 2017, you need to fully install SSAS - Analysis service to have data mining features.

    For SQL Server 2017 and SQL Server 2019 , you need to install Machine Learning Service to have this feature.

    Download SQL Server.

    Hope this helps a bit.

  2. lbar 1 Reputation point

    Apologies for the late reply. Yes this helped greatly. I just got my new computer and finally was able to install everything, thank you!