Azure AI Search on a private connection to a Azure SQL

tatsu sei 60 Reputation points
2024-06-07T05:22:44.81+00:00

ai-search-error1

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.
Azure SQL Database
Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
831 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-06-07T15:12:02.63+00:00

    @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://video2.skills-academy.com/en-us/azure/search/search-indexer-howto-access-private?tabs=portal-createUser's image

    Regards

    Geetha

  2. tatsu sei 60 Reputation points
    2024-06-13T04:12:39.6+00:00

    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.

    0 comments
  3. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-06-19T15:14:12.89+00:00

    @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

    0 comments