CODEWITHSUNDEEP
rsql-server
cs0815
cs0815

Reputation: 17388

R version Machine Learning Server SQL Server 2019

Using Machine Learning Server and SQL Server 2017. Unfortunately, it only supports R 3.3.3. I googled a lot but could not find a definitive answer. Which version of R is supported whilst using Machine Learning Server on SQL Server 2019?

Upvotes: 0

Views: 1068

Answers (2)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89051

The versions of R and Python installed is only a default. You can update it.

Update to SQL 2017 CU22 or later, and you can change the version of R used:

If you have installed one of the above Cumulative Updates for SQL Server 2016 or 2017, you may have multiple versions of R in a SQL instance. Each version is contained in a subfolder of the instance folder with the name R_SERVICES.. (the folder from the original installation may not have a version number appended to the folder name).

Change R Runtime Version - SQL Server 2016 and SQL Server 2017

The process for SQL Server 2019 is here.

Upvotes: 3

Thom A
Thom A

Reputation: 95571

What is SQL Server Machine Learning Services with Python and R? states:

Python and R versions

The following lists the versions of Python and R that are included in Machine Learning Services.

SQL Server version Python version R version
SQL Server 2017 3.5.2 3.3.3
SQL Server 2019 3.7.3 3.5.2

So 2019 installs 3.5.2 for R, while 2017 (contrary to your question) installs 3.3.3.

Upvotes: 3

Related Questions