Configuring failover endpoint in Azure AI search datasource, for a multi region Azure SQL managed instance database

Question

Configuring failover endpoint in Azure AI search datasource, for a multi region Azure SQL managed instance database

Karthik P 0 Microsoft Employee

Hi we have the following database configuration We are using Azure SQL Managed Instance where we have 2 database instances

1 in NCUS region
Other in SCUS region

Now one of them acts as primary and other acts as secondary.

We also have enabled CDC in few tables that we populate to Azure AI search. Currently we have the following datasource configuration,

Datsource_ncus -> reads from the CDC table NCUS region
Datasource_scus -> reads from the CDC table in SCUS region

We also have configured indexers the following way

Indexer_ncus -> uses the datasource_ncus and populates the index_1
Indexer_scus -> uses the datasource_scus and populates the index_1

Now since only 1 database can be primary, for example here lets say NCUS is primary, the indexer of SCUS keeps failing (which we allow to fail) We also have configured failover endpoint for the above 2 database instance, so they are part of a failover group What i want to understand is, if we can use this failover endpoint, instead of having a seperate datasource and indexer for the database in 1 region.

By doing that, we avoid having multiple indexers and datasources. We will just have 1 datasource and 1 indexer, and datasource would always resolve to the primary instance.

Can you please help in how i can configure this? There seems to be no documentation available

Karthik P 0 Microsoft Employee

When i tried configuring using the failover endpoint, i get the below error

apiError - Failed to update indexer "failover-indexer", error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"

Here is the configuration i am using

datasource


{
  "@odata.context": "*****",
  "@odata.etag": "******",
  "name": "failoverendpoint-test",
  "description": null,
  "type": "azuresql",
  "subtype": null,
  "indexerPermissionOptions": [],
  "credentials": {
    "connectionString": "Data Source=tcp:<failover_endpoint>.database.windows.net,3342;Initial Catalog=*****;User ID=...;Password=...;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False;Authentication=ActiveDirectoryManagedIdentity"
  },
  ...
  ...
}

indexer i added the datasource as

"dataSourceName": "failoverendpoint-test",

Also in the UI i notice that there is no option to add failover endpoint

attached pic

User's image

Aditya N 2,550 Reputation points Microsoft External Staff Moderator

2026-04-23T07:01:14.4966667+00:00

Hello @Karthik P

Thank you for reaching out Microsoft Q&A. We're looking into it, we'll get back to you shortly.