| title | External Scripts Enabled server configuration option | Microsoft Docs | ||
|---|---|---|---|
| ms.date | 11/13/2017 | ||
| ms.prod | sql | ||
| ms.technology | configuration | ||
| ms.reviewer | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 9d0ce165-8719-4007-9ae8-00f85cab3a0d | ||
| author | MashaMSFT | ||
| ms.author | mathoma |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Applies to: [!INCLUDEsssql15-md] [!INCLUDErsql-productname-md] and [!INCLUDEsssql17-md] [!INCLUDErsql-productnamenew-md]
Use the external scripts enabled option to enable the execution of scripts with certain remote language extensions. This property is OFF by default. When Advanced Analytics Services is installed, setup can optionally set this property to true.
You must enable the external script enabled option before you can execute an external script using the sp_execute_external_script procedure. Use sp_execute_external_script to execute scripts written in a supported language such as R or Python.
-
For [!INCLUDEssSQL15]
[!INCLUDErsql_productname] includes support for the R language in [!INCLUDEssSQL15], and a set of R workstation tools and connectivity libraries.
Install the Advanced Analytics Extensions feature during [!INCLUDEssNoVersion] setup to enable the execution of R scripts. The R language is installed by default.
-
For [!INCLUDEsssql17-md]
[!INCLUDErsql-productnamenew-md] uses the same architecture as in SQL Server 2016, but provides support for the Python language.
Install the Advanced Analytics Extensions feature during [!INCLUDEssNoVersion] setup to enable the execution of external scripts. Be sure to select at least one language during initial setup: either R or Python, or both.
After setup, to enable external scripts, execute the following script:
sp_configure 'external scripts enabled', 1;
RECONFIGURE WITH OVERRIDE; You must restart [!INCLUDEssNoVersion] to make this change effective.
For more information, see Set up SQL Server Machine Learning.