From the course: SQL Server Machine Learning Services: R
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
From the course: SQL Server Machine Learning Services: R
Enable script execution in SQL Server
- [Instructor] Now that the computer has restarted, we can load up SQL Server Management Studio and make sure that everything works. This next step will require that you log in to the server with a user account that has administrator privileges. My Windows Authentication account is the system administrator for the server so I'm going to go ahead and connect with that. Then I'll start up a new query window. The first thing I want to do is run a system procedure called sp_configure. In the results window we're going to find the row that says external scripts enabled, and it's this one here on row number 10. The current config value is set to zero. This is the default state for SQL Server and it will not allow external code to run for security purposes. In order to execute scripts written in the R language, we need to enable this feature. We do that by executing this command. We'll EXECUTE sp_configure and inside of a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.