Hero Banner

Products Discussions

Share best practices and get the latest Microsoft product info

Reply
Level 1 Contributor

ADFS v3 and SQL Merge Replication

Hello,

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?

1 REPLY 1
Visitor 1

Hi,

we're hosting the ADFS environment in Azure.

KEMP1 KEMP2

WAP1 WAP2

ADFS1 ADFS2

SQL1 SQL2 (Enpterpise AlwaysOn)

|VPN to OnPrem DC's|

 

But your way is also very interesting.

 

BR

Franz