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

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...