Elastic Query issues in Azure SQL Database not working with private link

Question

I am trying to execute cross database queries in Azure sql .So far the only way I found is with Elastic Query . Unfortunately the Data source which is created as a part of Elastic Query need public network which in my case not possible as I am using Private end point to access Azure sql database. Is there any other recommended way for performing cross database query operation ?

Answer 1

Hi @HemantSingh-3622 , Elastic Query is only supported when "Public network access" remains enabled.

More info: Resolve Elastic Query issues in Azure SQL Database - Microsoft Community Hub

Answer 2

Hemant Singh Thank you for reaching out.

Elastic queries do not support private end points at this point. Azure SQL Managed Instance supports cross-database queries natively, no need for Elastic Query with that setup.

https://learn.microsoft.com/en-us/answers/questions/775956/cross-transaction-query-sql-managed-instance

AS siwibowo mentioned Elastic Query is only supported when "Public network access" remains enabled.

Please raise your feedback here https://feedback.azure.com/d365community/search/?q=azure+sql

Regards,

Oury