Troubleshooting "Failed to Fetch" Error

Question

I'm attempting to import data from an Azure SQL Database into Azure Search but encounter the error message "Failed to fetch" when connecting to the data source. I've verified that the data source is visible in Azure Search and have provided the correct connection details.

Could you please suggest potential reasons for this error and steps to resolve it?

Additionally, please provide a detailed guide on how to establish a connection between Azure Search and an Azure SQL Database.

Answer 1

Hi @MulluriNivas-6816

Thanks for the question and using MS Q&A platform.

I have encountered a similar issue and found that the error "Failed to fetch" often occurs when the SQL server is behind a firewall, restricting access.

The issue might be due to your SQL server being behind a firewall, which is restricting access and causing Azure Search to fail when attempting to connect to the database data source.

To resolve this, set the Public network access to Selected Netwoks in the networking of respective server.

Ensure that the Allow Azure services and resources to access this server option is checked to enable easy access to this server by Azure services.

If still issue persist it might be internal issue, then it's better to raise a Support ticket for your issue.

Reference: Create Index for Full Text Search using Azure Cognitive Service and Azure SQL Database

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.