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:
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