SQLTeam.com | Weblogs | Forums

External Tables

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