CODEWITHSUNDEEP
rsql-server-2016
Sumit Chaudhary
Sumit Chaudhary

Reputation: 21

SQL Server 2016 integration with R Services

While trying to integrate R Studio with SQL Server 2016 I am getting following error:

Unable to launch runtime for 'R' script. Please check the configuration of the 'R' runtime.

As suggested on different sites it is advised to install "%programfiles%\RRO\RRO-3.2.2-for-RRE-7.5.0\R-3.2.2\library\RevoScaleR\rxLibs\x64\RegisterRExt.exe" /install.

But I have already installed R studio and not able to find the path specified.

Upvotes: 2

Views: 754

Answers (1)

Mike Wise
Mike Wise

Reputation: 22847

R Services for SQL 2016 is a new offering from Microsoft - who purchased Revolution Analytics about a year ago. This is the first major result of that.

SQL Server 2016 is in (CTP - community technical preview), so not really finished (although you can download and use a version that will expire after about 6 months). Also a lot of the docs are incomplete and there are probably a fair amount of bugs. However it has been long announced that it will include "R Services for SQL 2016", which is based on the Revolution R Engine. In order to use that you have to

  1. Install SQL Server 2016 CTP as usual.

  2. Install the "Advanced Analytics Extensions" from the setup.exe program (see https://msdn.microsoft.com/en-us/library/mt590808.aspx)

  3. Obtain the appropriate RevoScaleR packages (there are two) and install them, one your client, and one on the machine running SQL 2016. They are described here: https://msdn.microsoft.com/en-us/library/mt604883.aspx

  4. Then to test it you can follow the instructions here: https://msdn.microsoft.com/en-us/library/mt590808.aspx

Good luck with it, but remember it is still in pre-release development and testing, so problems are to be expected.

Upvotes: 2

Related Questions