Data Mining Installation

lbar 1 Reputation point
2021-02-12T00:25:10.503+00:00

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,296 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-02-12T05:37:09.29+00:00

    Hi,

    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.
    Lukas


  2. lbar 1 Reputation point
    2021-03-02T05:54:30.087+00:00

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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.