Azure AI Search on a private connection to a Azure SQL

Question

I am currently setting up an Azure AI Search to establish a connection with Azure SQL on a private network. However, I am encountering a connection error while attempting to create a data source on Azure AI Search. I would greatly appreciate any advice or guidance on how to resolve this issue. Additionally, if there are any additional configurations that need to be made, please inform me. Thank you for your assistance.

Here is my current environment configuration:

• AI Search:
  • Configured a private endpoint in VnetA.
  • Disabled public access.
  • Established a shared private link with Azure SQL.
• Azure SQL:
  • Configured a private endpoint in VnetB (internal DNS resolution is functioning properly).
  • Disabled public access.
  • Approved the shared private link with Azure AI Search.

Answer 1

@tatsu sei I'm glad that you were able to resolve your issue and very much appreciated for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue: You are encountering a connection error while attempting to create a data source on Azure AI Search to establish a connection with Azure SQL on a private network.

Solution: As you mentioned you have solve this issue by utilizing the Call Azure Ai Search API for creating the data source and executing the indexer, rather than relying on the Azure portal.

If you have any other questions or are still running into more issues, please let me know.

Please remember to "Accept Answer", so that others in the community facing similar issues can easily find the solution.

Regards

Geetha

Answer 2

@tatsu sei Thanks for posting your question in Microsoft Q&A.

Thanks for sharing the configuration and error screenshot.

I assume you are running the indexer

one key thing is to ensure the indexer running on isolated environment

https://learn.microsoft.com/en-us/azure/search/search-indexer-howto-access-private?tabs=portal-create

Regards

Geetha

Answer 3

I solve this issue by utilizing the Call Azure Ai Search API for creating the data source and executing the indexer, rather than relying on the Azure portal.