This is Part 2 of “Get Started with SQL Server Machine Learning Services “. In the part 1 article, we discussed about the capabilities of Machine Learning in SQL Server. In this article, we will discuss “How to Install Machine Learning Services in SQL Server”.
Note: If you are new to this article, recommending you to refer the previous article in this series, Get Started with SQL Server Machine Learning Services – Part 1
Install Machine Learning Services for Python
The support for Python is not automatically installed with the basic SQL Server installation. But we can easily add as part of custom configuration. My SQL Server version is 2019 and later from 2017 SQL Server, we can add the required components to our instance.
Add Machine Learning Functionality
To add Machine learning Functionality, go to Start Menu and find SQL Server Program group. Choose SQL Server Installation Center.
Switch over to the Installation step from the left
Choose the first option, “New SQL Server stand-alone installation or add features to an existing installation”.
Once the media files are installed successfully, press the Next Button to perform some system checks.
Click Next button and it takes us to Installation Type. Two options are shown as,
- Perform a new installation of SQL Server 2019
- Add features to an existing instance of SQL Server 2019
In my case, I am choosing the second one.
Choose the Installation Name from the Dropdown Menu. Choose that and press Next Button. Now the installation takes us to the Feature Selection.
In our scenario, choose Python. Event if you wish, you can install R from the Machine Learning Services and Language Extensions option. If we scroll little bit down in the screen, we could see another option as Machine Learning Server (Standalone), make sure we leave this option unchecked. Now press the Next Button.
Accept the license terms under the Consent to install Python. In this Anaconda is installed.
Click Next button and it will leads to Ready to Install screen. and press install button.
Installation will take few minutes,
Everything should wrap up without any issues. And when installation is completed we should able to see the screen as shown below,
Its always good to restart the system after installing.
In this article, we have discussed how to install Python Machine learning services in SQL Server, I hope you all found this article useful. We will discuss more concepts in upcoming articles. Please share your feedbacks in the comment section.