- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe to Topic
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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?
- Labels:
-
Server Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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
