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