0

I have 2 server using SQL Server installed on Linux Ubuntu 20,04 OS, it's Server A and Server B.

when I connect and querying to Server A from server B, is successfully using SQLCMD.

but I got error when I create external data source by polybase with error message tcp provider: no such host is known when I create it from Server B with Location Server A.

I searching in https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-installation?view=sql-server-ver16, I think I got my problem information, TCP/IP Disabled, but how to find and enable TCP/IP??.

When I go to link https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver16 , I got the confgiration only using SQL Server Configuration manager and Powershell .

it's ok if I using Windows for SQL Server Database, but I use linux for SQL Server Database:),

so, anyone have solution?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.