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?