If anyone else runs into issues with this, I believe that the order you install things matters. I was able to get a working R install by going in the following order:
1) R runtime
2) R enterprise Node
3) SQL 2016 with R Extensions
4) Run the sp_configure script
5) Finally, run the command line script
Persistence is key!
Ernest Libertucci (11/1/2015)
Thanks very much for the head's up.I have installed CTP 3, and followed the MS instructions for enabling R (including the other installers), but I'm hitting a brick wall when attempting to run a simple test R script. If anyone has seen the below error or could give any pointers, I would be very appreciative.
Test script:
EXECUTE sp_execute_external_script
@language = N'R'
, @script = N'OutputDataSet <- data.frame(mean(InputDataSet[,1]))'
, @input_data_1 = N'SELECT 50 as L_Quantity '
WITH RESULT SETS ((col int not null));
Results:
Msg 39021, Level 16, State 1, Line 1
Unable to launch runtime for 'R' script. Please check the configuration of the 'R' runtime.
Msg 39019, Level 16, State 1, Line 1
An external script error occurred:
Unable to launch the runtime. ErrorCode 0x80070490: 1168(Element not found.).