Sql Server 2019 Polybase feature issue

Question

I'm trying to configure PolyBase on SQL Server 2019 to test some new features.

I already installed this feature and performed all steps from below instruction:
Install PolyBase on Windows

I get an error notification when trying to configure connection to external table in Azure Data Studio:

I cannot start the SQL Server PolyBase Engine service, maybe it has something to do in this case:

Any ideas how to configure it properly to use PolyBase?

Did you consult the event log or other applicable error logs for details? — GSerg, Nov 22 '18 at 08:56
The SQL Server PolyBase Data Movement (MSSQLSERVER01) service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 7260000 milliseconds: Restart the service. — bhuiokmnb7891, Nov 22 '18 at 09:11

score 0 · Answer 1 · answered Dec 12 '18 at 22:49

0

You need to enable TCP/IP for this SQL Server before starting the services

answered Dec 12 '18 at 22:49

PBVK

score 0 · Answer 2 · edited Nov 08 '20 at 09:35

You need to:

enable TCP/IP as network protocol for your SQL Server instance.
Restart the SQL Instance Restart the Polybase services.
Enable PolyBase on the instance: exec sp_configure @configname = 'polybase enabled', @configvalue = 1; RECONFIGURE;.

You can read more about this in following two blog posts:

2 Answers2