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 [53]. [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.
Please advise
thanks
Mahmood