0

I`m using SQL Server 2019 preview version (15.0.1000.34) with Polybase services installed on localhost/SQL2019 named instance (Windows 10) and Azure Data Studio, I wish to add an External Table from Oracle db (remote server) and getting an error "This operation requires PolyBase to be enabled in the target server". The services "SQL Server PolyBase Data Movement (SQL2019)" and "SQL Server PolyBase Engine (SQL2019)" are actually running on my laptop. I tried to restart the computer, but the issue still persists.

Does anyone know, what are other actions to be taken to create an External Table from Azure Data Studio?

I`m attacheing screenshots from Data Studio and Services manager, the last one is in Russian but the status at 3 services means "Running".

enter image description here

enter image description here

Alexey Chibisov
  • 188
  • 1
  • 10

2 Answers2

2

You need to do this: -- Change polybase value to 1

exec sp_configure @configname = 'polybase enabled', @configvalue = 1;

RECONFIGURE;

--Re-check polybase feature

exec sp_configure 'polybase enabled';

Then it should work.

bummi
  • 27,123
  • 14
  • 62
  • 101
Huub
  • 36
  • 1
0

A Similar worded problem showed up during a Cumulative Update SQL Server Patch update for me.

SQLPBDMS SQLPBENGINE Cannot Restart Stuck in Starting Services Status. Cumulative Update and Service Patch will not complete due to SQL Server PolyBase Engine Service not restarting during SQL Service Patch Update.

Solution : Make sure that the SQL Server Configuration Manager shows TCP/IP as an enabled protocol for your SQL Server Instance.

SQL Server Configuration Manager can be seen in the "Computer Management" utility usually.

Sql Surfer
  • 1,344
  • 1
  • 10
  • 25