Tuesday, July 12, 2016

SQL - Msg 39011 SQL Server was unable to communicate with the LaunchPad service

I’m very passionate to learn new technologies especially in SQL Server. To understand the functionality R Services within SQL Server 2016, I was running some R scripting code in SQL Server 2016. After writing some R scripting in SQL, I got the error as “Msg 39011 SQL Server was unable to communicate with the LaunchPad service” at runtime as given below:


It was the stuck point for me and after doing the R&D, I got the solution which stated that your “SQL Server LaunchPad (MSSQLSERVER)” services is stopped means it should be in the running mode to play with R scripting code in SQL Server 2016.
So, I opened services on my machine and find out “SQL Server LaunchPad (MSSQLSERVER)” service which was stopped as given below:

I did right click on that service and select start. 

After clicking on the start, service has been started as given below:

After starting the “SQL Server LaunchPad (MSSQLSERVER)” services, I have run my R scripting code in SQL Server 2016 again and it’s running successfully as given below:
Steps to run the SQL Server LaunchPad (MSSQLSERVER) Services
There are two way to run that services as given below-
1) Through Control Panel
Control Panel -> Administrative Tools -> Services
Services -> "SQL Server LaunchPad (MSSQLSERVER)"
Right-click it and select "Start" and my scripts run again.
2) Through run command
Type Services and open Services window
Services -> "SQL Server LaunchPad (MSSQLSERVER)"
Right-click it and select "Start" and my scripts run again.

Conclusion
To run the R scripting code in SQL Server 2016, “SQL Server LaunchPad (MSSQLSERVER)” services should be in the running mode as the other services of the SQL Server. In SQL Server 2016 RTM, SQL Server Launchpad is automatic started when restarting the SQL Server.

No comments:

Post a Comment