Azure AI Search, Managed Identity and SQL Failover Groups: Does ResourceId Matter?
If you index an Azure SQL database with Azure AI Search, you will probably want the indexer to use a managed identity rather than a SQL username and password. You will probably also want the database in a failover group, so it can survive a regional outage. Put those two things together and you hit an odd-looking connection string with an open question inside it.
This post explains that question, how I tested it, and what I found.
[Read More]