Enabling Machine Learning in SQL Server - 2

Launch SQL Server, the version (herein, SQL Server 2017) for which you want to use and start a New Query. Run the following in the context of the server:

sp_configure 'external scripts enabled'

Depending on the response to this query, you can find whether Machine Learning is installed or not. If the run_value=0, ML is not enabled.

The Advanced Analytics Extensions was enabled and the above query was executed. The value of Value_run is still 0.

However, if you run the query:

sp_configure 'external scripts enabled', 1

The response is as shown (note that the previous script is also included for reference):

This screen shows that the extension is installed. However the run-value will still be 0. You need to start the Windows Service s(SQL Server Launch Pad for MSSQLServer) shown here:

You can start the service from the above screen and it gets started as shown:

After restarting you should restart the MSSQL Server service before the changes are made. Now you run the script:

sp_configure 'external scripts enabled'

Now you get the following response:

If you are using SQL Server 2016, the procedure is slightly different and you should use the related SQL Server Launch Pad service.

Enabling Machine Learning in SQL Server - 1

The important question is whether Machine Learning (ML) is enabled or not.

You can find if ML is enabled or not by the following:


Launch SQL Server, the version for which you want to use and start a New Query. Run the following in the context of the server:

sp_configure 'external scripts enabled'

Depending on the response to this query, you can find whether Machine Learning is installed or not. If the run_value=0, ML is not enabled.

MachineLearning_0
However the following query gives more information.

MachineLearning_1
You need to install 'Advanced Analytics Extensions' to enable Machine Learning (Using R or Python)