We are using AG DNN for sql server and 2 node are in the same zone ip's are added in cloud dns however while connecting using DNN it always point to first ip in cloud DNS instead of whatever primary instance. if we failover to second instance connection refused. the error is read only status
LinkedIn
Twitter
