ADFS v3 and SQL Merge Replication
we have 3 data centers in 3 different regions.
Each datacenter has 1 ADFS proxy (DMZ), 1 ADFS server (LAN) and 1 SQL Server (LAN)
We're configuring the SQL merge replication between the 3 SQL server to obtain high availability for ADFS databases.
So, after we've configured the SQL merge replication, we have configured the SQL string for ADFS like this:
Data Source=SQL1.DOMAIN.COM\SQLINSTANCE;Failover Partner=SQL2.DOMAIN.COM\SQLINSTANCE;Initial Catalog=ADFSConfiguration;Integrated Security=True
But the ADFS application doesn't use the SQL string correctly.
If the primary SQL is down, the ADFS doens't connect to the second SQL server.
So, is this the correct behavior?
How can I solve the issue?