0
votes

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:

Azure Data Studio error

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

Sql Server Configuration Manager error

Any ideas how to configure it properly to use PolyBase?

2
Did you consult the event log or other applicable error logs for details? - GSerg
I got following error in Event Log: - bhuiokmnb7891
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

2 Answers

0
votes

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

0
votes

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: