debugsqlModerate
Msg 39011 SQL Server was unable to communicate with the LaunchPad service
Viewed 0 times
themsgserver39011sqlwithlaunchpadunableservicecommunicate
Problem
I was playing with the new "R" scripting in SQL Server 2016 CTP 30.
Finally got it working, thanks to this site.
I've had a problem that I'm sure others will run into as well.
All of a sudden the "R" scripts no longer worked, they returned this error:
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.
Finally got it working, thanks to this site.
I've had a problem that I'm sure others will run into as well.
All of a sudden the "R" scripts no longer worked, they returned this error:
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.
Solution
In order to move TempDB to a disk with more space, I had to restart the server.
This stopped the SQL Server as well as SQL Agent, and the new "SQL Server Launchpad".
It was easy to restart SQL Server and SQL Agent.
To restart LaunchPad, I needed to go to
Administrative Tools -> Services
and find "SQL Server LaunchPad (MSSQLSERVER)"
right-click it and select "Start"
and my scripts run again.
This stopped the SQL Server as well as SQL Agent, and the new "SQL Server Launchpad".
It was easy to restart SQL Server and SQL Agent.
To restart LaunchPad, I needed to go to
Administrative Tools -> Services
and find "SQL Server LaunchPad (MSSQLSERVER)"
right-click it and select "Start"
and my scripts run again.
Context
StackExchange Database Administrators Q#120205, answer score: 13
Revisions (0)
No revisions yet.