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?


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.