none
SQL Server was unable to communicate with the LaunchPad service

    Question

  • I am unable to run R scripts in SQL Server 2016 Service Pack 1 on Windows 10.

    When I run:

       exec sp_execute_external_script  
         @language =N'R',    
         @script=N'OutputDataSet<-InputDataSet',      
         @input_data_1 =N'select 1 as hello'    
         with result sets (([hello] int not null));    
       go    

    I get the message

       Msg 39011, Level 16, State 1, Line 1
       SQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service.  
       Msg 11536, Level 16, State 1, Line 1
       EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result    set(s) at run time.

    Both Windows Services and SQL Server Configuration Manager report that Launchpad is running.

    "Exec sp_configure 'external scripts enabled'" reports 1

    The SQLRUserGroup has log-on privileges.


    John Kane

    Tuesday, December 13, 2016 7:35 PM

All replies

  • Hi JJ Kane,

    Could you please share more information to us for analysis? We want to know the account of SQL Server Service  and the account of Launchpad Service. You can check it in SQL Server Configuration Manager (SSCM). Besides, have you ever used the R Service of other release on this machine before? For example, SQL Server 2016 CTP or other release. What's the type of instance, default instance or named instance? Besides, please share the rlauncher.config file to us, this file should be at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn

    SQL Server will use Trusted Launchpad to run R jobs, we will meet the error message 'SQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service' when SQL Server cannot connect with LaunchPad service.

    If you have any other questions, please let me know.

    Best Regards,
    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, December 14, 2016 3:15 AM