Connecting Azure Search to Azure SQL Server with Private Access does not work

Marco Voorwinden | Twyzer 0 Reputation points
2023-10-16T11:53:21.3266667+00:00

I have the following setup:

  • Azure SQL Server
    • Disabled public access
      • Added Private EndPoint
  • Azure Cognitive Search
    • Disabled public access
      • Added Private EndPoint

Now I want Azure Cognitive Search to access Azure SQL Server. For this I add Shared Private Access to connect to Azure SQL Server. In Azure SQL Server I approve the request.

Now the strange things:

  1. When I try to go to the Private Endpoint that has been created in Azure SQL Server (for the access from Azure Cognitive Search) I cannot open it. Reason for this is that it has been created in the wrong Subscription (no idea where this subscription comes from)
  2. When I try to view the current DataSources for Azure Cognitive Search, I get the following error:
    {"message":"Failed to fetch","stack":"TypeError: Failed to fetch\n at https://portal.azure.com/Content/Dynamic/71JwQryyyuqU.js:229:21747","isError":true}
  3. When I try to use this Azure SQL Server as a data source in Azure Cognitive Search I cannot use it. It also shows the "Failed to fetch" error message.

Anyone that can help me understand this issue? Or better, help me understand what I am doing wrong here?

Thanks,

Marco

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.
1,069 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Marco Voorwinden | Twyzer 0 Reputation points
    2023-10-23T05:50:39.5966667+00:00

    Thanks for your feedback.

    No, I am not attempting cross-subscription access. The Subscription IDs mentioned are the IDs I see on the Shared Access links, so I think this is a bug in Azure. For that, I will raise a support ticket.

    About the setup we want to achieve: we found out that the issue was caused by the fact that we disable Public Access on SQL Server and we were trying to setup the datasource on the Cognitive Search resource after disabling the access. This causes an issue because we try publicly to access the SQL Server instance (using the portal). So, in the end we created a VM within the VNET and from that VM we did the whole setup and that works.

    Thanks all for the answers.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.