R 在 SQL Server 2016 中 [英] R In SQL Server 2016

问题描述

尝试执行 MSDN 提供的测试脚本以确保 R 已启用，但它抛出以下错误，

Trying to execute the test script that MSDN provides to make sure R is enabled, but it throws the following error,

Msg 39023, Level 16, State 1, Procedure sp_execute_external_script, Line 1 [Batch Start Line 0]
'sp_execute_external_script' is disabled on this instance of SQL Server. Use sp_configure 'external scripts enabled' to enable it.
Msg 11536, Level 16, State 1, Line 1
EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result set(s) at run time.

我已经确定我运行了

Exec sp_configure  'external scripts enabled', 1  

使用覆盖重新配置

声明，然后我确保将配置设置设置为 1，并在检查和之后重新启动服务，但没有运气.

Statement and then i made sure the configuration setting was set to 1 which it is, and restarted the services inbetween checking and afterwards, but no luck.

我还确保我不会加载任何其他 R 开放平台 ide 或其他版本的 SQL Server 版本(2016 开发人员除外).

I've also made sure i'm not side loading any other R open platform ide's or other versions of SQL Server versions except 2016 developer.

推荐答案

运行:

Exec sp_configure  'external scripts enabled', 1;
reconfigure;

然后从 services.msc 重新启动服务或重新启动系统.

Then restart the service from services.msc or restart your system.

这篇关于R 在 SQL Server 2016 中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！