Unable to Index Data In SQL Managed Instance From Azure Cognitive Search utilising private endpoint (preview) to injest data.

Question

I'm trying to setup an indexer on Azure Cognitive Search and am able to setup the data source to the SQL managed instance however when creating the indexer I get the following error reported in the portal notifications.

"Public data endpoint must be enabled to connect to a SQL Managed Instance."

We're utilising private endpoint for SQL Manged Instance (preview) to provide private connectivity.

We can be infer that the connection string is valid as the indexer can identity that the connection string is to a "SQL Managed instance".

Is it expected that the SQL Managed Instance should be reachable and able to create the indexer using "Shared Private Access" by Search?

Answer 1

@David Hall , Thanks for the good question.

Connecting to a SQL Managed endpoint though a private endpoint is not supported.

Kindly check the resources that are supported are listed here: Make outbound connections through a private endpoint |supported-resources-and-group-ids
(The supported-resources table lists Azure resources for which you can create managed private endpoints from within Azure Cognitive Search)

So, the configuration to connect through a public endpoint and secure the connections is here:
Indexer connections to Azure SQL Managed Instance through a public endpoint

--
To benefit the community find the right answers, please do mark the post which was helpful by clicking on ‘Accept Answer’ & ‘Up-Vote’.