Entity Framework Core for SQL Server Failover Basic Availability Groups does not work
Ok, so I had to go out of my way and took a risk to setup DNS without AD. It wasn't a big deal since we had only 2 SQL instances and 3 client VMs. Apparently &quot;Failover Partner&quot; keyword only works with the deprecated &quot;mirroring&quot; feature. And the listeners are to be only accessed with their names. I don't think there is a solution to not using DNS without a number of ugly hacks.