SQL Server-CREATE EXTERNAL DATA SOURCE（err）

Question

SQL Server-CREATE EXTERNAL DATA SOURCE（err）

夏天 1

GENERIC why？

AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff

2020-08-21T09:50:16.973+00:00

Hi summeronline,

Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

Best Regards,

Amelia

2 answers

Your answer

AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff

2020-08-21T09:50:16.973+00:00

Hi summeronline,

Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

Best Regards,

Amelia

Answer 1

AmeliaGu-MSFT 14,006 Microsoft External Staff

Hi summeronline,

This error may occur because PolyBase is installed but not configured on the instance.

Please make sure PolyBase is installed and enabled.

EXEC sp_configure 'polybase enabled', 1
RECONFIGURE

Please refer to this article for more details.

Best Regards,

Amelia

=======================================
Please remember to click " Accept Answer" and upvote the responses that resolved your issue. This can be beneficial to other community members reading this thread.

Answer 2

Sreekanth Madambath 86

Hi,

Please check if below link helps.

https://blog.sqlauthority.com/2020/03/16/sql-server-polybase-error-msg-46530-external-data-sources-are-not-supported-with-type-generic/

Thanks,
Sreekanth Madamabth

Share via

SQL Server-CREATE EXTERNAL DATA SOURCE（err）

2 answers

Your answer