Monday, August 6, 2018

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.






No comments:

Post a Comment

What is SQLOISIM? What is it used for in SQL Server?

SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...