Im stuck with a connection string issue
this is my connection string.
<add name="APP01" connectionString="Server=10.169.0.2; Failover Partner=10.166.0.2; Initial Catalog=DB2017; Integrated Security=True" providerName="System.Data.SqlClient" />
If I do sql server mirroring failover, the application is not connecting to new primary server. Still all the connections goes to old primary.