Select Page

If you are here, then you have experienced the same issue with the R Service not wanting to start after installing it on an existing instance. You have seen that pesky message to the left. In this particular case our server was previously patched to (SQL Server 2016 SP1 CU3) and we needed R Services installed.

Like many of the other services added post install we expected it to start working shortly after installing the new component but we were very, very were wrong! Turns out there are some caveats which I’ll cover.

There are two steps you need to take in order to resolve this issue. 1) The group: SQLRUserGroup needs to be to allowed to log on locally and 2) you need to patch R Services. As mentioned before, our server is patched at Service Pack 1 CU3 for SQL Server 2016 and in order to get R Services up and running we need to bring R Services up to this level.

Online References:

Microsoft’s article covered the allow log on locally in this article: Upgrade and Installation FAQ (SQL Server R Services)

This Microsoft article covers the issue with version differences. Review the section: Launchpad services fails to start if version is different than R version

Microsoft’s support item which covers the version differences again: FIX: SQL Server Launchpad service fails to start if the installed version of R Services (In-Database) is different from the Database Engine in SQL Server 2016

Resolution:

In Server Manager, click on Tools and select Local Security Policy

Expand Local Policies and double click on User Rights Assignment

Click the Add User or Group

Change the location to use the local server and not the domain nor the entire directory

Click on Object Types… and be sure to check Groups

Type in SQLRUserGroup and click Check Names, then click OK on the rest of the dialog windows to finish adding the group

Service Pack

Start the setup of the Service Pack and click Yes if you are prompted by UAC

Accept the terms and click Next

Ensure you see MSSQLSERVER — Database Engine Services — R Services (In-Database) checked and click Next

Click Next then click Close when finished.

Cumulative Update

Start the setup of the Cumulative Update and click Yes if you are prompted by UAC

Accept the terms and click Next

Ensure you see MSSQLSERVER — Database Engine Services — R Services (In-Database) checked and click Next

Accept the terms and click Next

Click Next

Click Update

Click Close

Now start the R Service from SQL Server Configuration Manager

Share This