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?

Answer 1

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

Answer 2

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:

• https://nielsberglund.com/2019/11/20/fix-polybase-in-sql-server-2019-developers-edition/
• https://nielsberglund.com/2019/12/30/more-polybase-issues-in-sql-server-2019-developers-edition/