Cannot start R Launchpad service on SQL Server 2016 server

Jim Youmans
Jim Youmans used Ask the Experts™
on
Microsoft R and SQL Server 2016

I installed Microsoft R on an existing instance of SQL Server 2016 and I cannot get the SQL Server Launchpad service to start.  Each time I try, I get "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."  In the application error log is says "A timeout was reached (30000 milliseconds) while waiting for the SQL Server Launchpad (MSSQLSERVER) service to connect."

I have tried everything I can find and no joy.  I read that if the R library is out of sync with SQL Server this can happen.  How can I tell if this is the case and if so how can I fix it?

Here is the version number of the Launchpad.exe file 13.0.1601.5
Here is the version number of the SQLSVC.dll is 13.0.5216.0

The @@VERSION for SQL Server is Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64)   Sep 13 2018 22:16:01  

Any help would be greatly appreciated.

Jim
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
If the R-Server and SQL Server installed are at different patch levels, then SQL Server Launchpad Service will not start..
https://support.microsoft.com/en-us/help/4014734/fix-sql-server-launchpad-service-fails-to-start-if-the-installed-versi
Above link is slightly outdated for SQL Server 2016 SP1 CU2 but explains the reason for failure..

So, I would suggest you to apply CU6 for SQL Server 2016 SP2 from the below link..
https://support.microsoft.com/en-us/help/4488536/cumulative-update-6-for-sql-server-2016-sp2
and then download the latest R Server components from here and install it to get it fixed out..
https://docs.microsoft.com/en-us/machine-learning-server/install/r-server-install-windows-offline

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial