启用了外部脚本的服务器配置选项External Scripts Enabled server configuration option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

适用范围:SQL Server 2016 (13.x)SQL Server 2016 (13.x) R Services(数据库内)R Services (In-Database)SQL Server 2017 (14.x)SQL Server 2017 (14.x) 机器学习服务Machine Learning Services Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) R Services(数据库内)R Services (In-Database) and SQL Server 2017 (14.x)SQL Server 2017 (14.x) 机器学习服务Machine Learning Services

使用 external scripts enabled 选项启用包含某些远程语言扩展的脚本执行。Use the external scripts enabled option to enable the execution of scripts with certain remote language extensions. 此属性默认处于禁用状态。This property is OFF by default. 安装“高级分析服务” 后,安装程序可以根据需要将此属性设置为 true。When Advanced Analytics Services is installed, setup can optionally set this property to true.

RemarksRemarks

在使用 sp_execute_external_script 过程执行外部脚本之前,必须启用“已启用外部脚本”选项。You must enable the external script enabled option before you can execute an external script using the sp_execute_external_script procedure. 使用 sp_execute_external_script 执行以受支持的语言(如 R 或 Python)编写的脚本 。Use sp_execute_external_script to execute scripts written in a supported language such as R or Python.

  • 对于 SQL Server 2016 (13.x)SQL Server 2016 (13.x)For SQL Server 2016 (13.x)SQL Server 2016 (13.x)

    R Services(数据库内)R Services (In-Database) 支持 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中的 R 语言,以及一组 R 工作站工具和连接库。includes support for the R language in SQL Server 2016 (13.x)SQL Server 2016 (13.x), and a set of R workstation tools and connectivity libraries.

    安装程序安装期间安装 高级分析扩展 SQL ServerSQL Server 功能,以启用 R 脚本的执行。Install the Advanced Analytics Extensions feature during SQL ServerSQL Server setup to enable the execution of R scripts. 默认安装 R 语言。The R language is installed by default.

  • 对于 SQL Server 2017 (14.x)SQL Server 2017 (14.x)For SQL Server 2017 (14.x)SQL Server 2017 (14.x)

    机器学习服务Machine Learning Services 使用与 SQL Server 2016 相同的体系结构,但支持 Python 语言。uses the same architecture as in SQL Server 2016, but provides support for the Python language.

    SQL ServerSQL Server 安装过程中安装“高级分析扩展”功能,以启用外部脚本的执行 。Install the Advanced Analytics Extensions feature during SQL ServerSQL Server setup to enable the execution of external scripts. 确保在初始安装过程中至少选择一种语言:R 和/或 Python。Be sure to select at least one language during initial setup: either R or Python, or both.

其他需求Additional requirements

安装后,要启用外部脚本,请执行下面的脚本:After setup, to enable external scripts, execute the following script:

sp_configure 'external scripts enabled', 1;
RECONFIGURE WITH OVERRIDE;  

你必须重启 SQL ServerSQL Server 以使此更改生效。You must restart SQL ServerSQL Server to make this change effective.

有关详细信息,请参阅安装 SQL Server 机器学习For more information, see Set up SQL Server Machine Learning.

另请参阅See also

sp_configure (Transact-SQL)sp_configure (Transact-SQL)

RECONFIGURE (Transact-SQL)RECONFIGURE (Transact-SQL)

sp_execute_external_script (Transact-SQL)sp_execute_external_script (Transact-SQL)

SQL Server 机器学习服务SQL Server Machine Learning Services