MicrosoftRohit_Nayak Thank you, so in the connection string should we be using the Failovergroup Listener or the Private End point of the SQL?
In my case SQL1, App Service both are in the same region VNet (NC) and the SQ2 failover is in the SC (Different Vnet/Subnet) but all of them in the same Private DNS Zone. Right now even after keeping the NC as primary and connection string using the Failover Listener its not working so I am confused as to what is missing here. NSlookup resolves the failovergroup link to the primary SQL from the App Service Kudu but when I try to open the app it complains with cant connect to the database ( I am using the failover Read/Writer Listener endpoint in the connection string)
