From the course: SQL Server Machine Learning Services: Python

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Enable script execution in SQL Server

Enable script execution in SQL Server

From the course: SQL Server Machine Learning Services: Python

Start my 1-month free trial

Enable script execution in SQL Server

“

- [Instructor] Now that the computer has restarted, we can load up SQL Service Management Studio and verify that everything works. Make sure that you login to the server with a user account that has administrator privileges. Then I'm going to start up a New Query window. I need to check the status of my server by running the stored procedure called sp_configure. Once you get this query here and the value that I'm looking for is on the row that says external scripts enabled. It's line number 10 here. The current config_value is set to zero. That's because the default is to not allow external code to run for security purposes. In order to execute Python code, we need to enable this feature. We do this by executing sp_configure. Then inside of SQL quotation marks, I'll type in the words, external scripts enabled, 1. I'll come down to line number two and type in reconfigure with override. Once I get these two lines to change the settings on my server, and now we can run sp_configure again…

Contents