title: External tables not working when "Deny public network access" is set to Yes
body: <p>I have enabled Private link by setting the &quot;Deny public network access&quot; knob to Yes in the Firewall settings on my Azure SQL Database server. Everything is working as expected except external data sources (external tables). The external tabels are simply links to tables in another Azure SQL database that belongs to the same server. Before I enabled the Private link, everything worked fine. If I try to query the external tables I get this error message:</p>
  <p>&quot;Error retrieving data from [mydbserver].database.windows.net.[mydbname].  The underlying error message received was: 'Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (<a href="https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access" rel="nofollow noreferrer">https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access</a>). To connect to this server, use the Private Endpoint from inside your virtual network (<a href="https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database" rel="nofollow noreferrer">https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database</a>).&quot;</p>
  <p>I can't find anything in the docs about any limitation regarding external data sources and external tables in combination with Private Link setup.</p>
  <p>The external tables where created using the standard way: &quot;CREATE EXTERNAL DATA SOURCE&quot; and &quot;CREATE EXTERNAL TABLE&quot;. I have also tried to recreate the data source and the tables after enabling Private Link, but the error remains...</p>