I want to create reference to external tables from Azure to on premise SQL Server. I don't want to create Linked Services or data pipelines.
The idea is to create a read reference to on premise SQL Server database to read the tables.
I was able to accomplish this, however, when I try to select the data from external table, I get the following error:
An error occurred while establishing connection to remote data source: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server . [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired[Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.