Install Machine Learning Services for Python-Get Started with SQL Server Machine Learning Services – Part 2

Introduction

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.

Fig. 1 SQL Server Installation Center

Switch over to the Installation step from the left

Fig.2 Installation

Choose the first option, “New SQL Server stand-alone installation or add features to an existing installation”.

Fig.3 Step Up Process

Once the media files are installed successfully, press the Next Button to perform some system checks.

Fig.4 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.

Fig.5 Choose Installation Name from the dropdown

Choose the Installation Name from the Dropdown Menu. Choose that and press Next Button. Now the installation takes us to the Feature Selection.

Fig. 5 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.

Fig. 6 Consent to install Python

Click Next button and it will leads to Ready to Install screen. and press install button.

Fig. 7 Ready to Install Screen

Installation will take few minutes,

Fig. 8 Installation Progress

Everything should wrap up without any issues. And when installation is completed we should able to see the screen as shown below,

Fig. 9 Installed Successfully

Its always good to restart the system after installing.

Conclusion

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.

Other Articles in this Series

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: