SQL Server R Services - Could not find stored procedure 'master..xp_ScaleR_init_job'

I'm trying to run a data science experiment as explained in this tutorial.
The tutorial has 5 lessons, and each lesson has a few sub-sections in it.

For this tutorial, I am using

• a SQL Server 2016 RC3 Virtual Machine on Azure, with R Services enabled.

• RRE for Windows 8.0.0 as a data science client / R Client (for remote connection to SQL Server)

• A new SQL Login created with read, write and ddl access to the database - used to connect to the SQL Server via the R client.

I've successfully completed Lesson 1, i.e. Create SQL Server data objects from my R client, Query and Modify SQL Server data, and Define/set compute contexts.

I'm stuck with an error in the beginning of Lesson 2 of the tutorial.

Once I change the compute context from local to sql server, a simple summarize function (rxsummary) is throwing an error.

The error looks like this:

C:\Users\...\Project0\DeepDive Experiment.R(109): Error in try({ : 
  ODBC statement error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master..xp_ScaleR_init_job'.
Error in rxInDbJobIdParam(schedulerJobInstance, FALSE) : 
  hpcServerJob object has an invalid id. Ensure it was returned from a prior rxStartClusterJob() call
Error in rxStartClusterJob(hpcServerJob, timesIsValidated = TRUE, continueOnFailure = FALSE) : 
  Error in try({ : 
  ODBC statement error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master..xp_ScaleR_init_job'.

Error in rxInDbJobIdParam(schedulerJobInstance, FALSE) : 
  hpcServerJob object has an invalid id. Ensure it was returned from a prior rxStartClusterJob() call

Any help on

• why this error is occurring?

• how to find/check stored procedures in the master database - how to check if xp_scaleR_init_job exists?

• how to add/create the stored procedure if it does not exist?

will be appreciated.

For easy access, here's the full commented script until I reach the error:

```
#############################

Apparently, SQL Server 2016 needs an R Server Client (RRE) that is atleast 8.0.3. This website talks about it. I also got the same answer from Microsoft Support.

The R server I have is RRE 8.0.0. That was probably the reason for the error that I received. When I installed the Microsoft R Client instead, the script worked (barring rxCube) ! I could push computations to SQL Server and finish the tutorial.

StackExchange Database Administrators Q#141717, answer score: 2