ADFS 2.0 SQL DB故障转移 - 它是如何工作的？ [英] ADFS 2.0 SQL DB failover - how does it work?
问题描述
我已经配置了一个ADFS 2.0服务器场，其中包含三个Web服务器，两个位于主站点，另一个位于我们的DR中。 。网站 我将使用f5在三个Web服务器之间进行网络负载平衡，对于数据库，我们有两个SQL服务器，我们在镜像配置中设置了
， 并且三个Web服务器将其配置为ADFS配置的连接字符串：
" Data Source = aADFSDB; Failover Partner = aADFSDBDR; Initial Catalog = AdfsConfiguration; Integrated Security = True"
和工件存储数据库连接字符串：
" Data Source = aADFSDB; Failover Partner = aADFSDBDR; Initial Catalog = AdfsArtifactStore; Integrated Security = True" ;
因此您可以看到SQL Server 1（aADFSDB）托管活动数据库和SQL Server 2（aADFSDBDR）托管故障转移伙伴/镜像。
我如何让ADFS故障转移到第二个数据库服务器？ 我试图阻止其中一个Web服务器访问主数据库服务器，希望我会看到一个事件确认它正在尝试连接到故障转移伙伴，但我得到的只是事件的
，就像本页底部的那个。 / p>
所以有人能告诉我这个配置究竟是如何故障转移到故障转移合作伙伴数据库的，它需要做什么以及我如何测试它？ 我已经查找了文档，但微软提供了有关使用SQL的宝贵信息，出于安全原因我们需要
（令牌重放检测仅在SQL配置中可用，而不是Windows内部数据库配置）
<我找到了许多关于如何使用故障转移伙伴配置设置SQL的页面，但没有找到有关ADF如何实际检测和执行故障转移的详细信息，以及在事件发生时需要采取哪些手动步骤。
AD FS配置数据库中的SQL操作，带有连接字符串数据源= aADFSDB;故障转移伙伴= aADFSDBDR;初始目录= AdfsConfiguration;集成安全性=真失败。
其他数据
异常详情：
用户'AUSTRALIANUNITY \登录失败svcADFSacc'。
任何人都可以帮忙吗？
I have configured an ADFS 2.0 farm with three web servers, two in the main site and one in our DR site. I will be using an f5 to do network load balancing across the three web servers, and for the Databases we have two SQL servers that our DBA's set up in a mirror config, and the three web servers have this configured as their connection string for ADFS Configuration:
"Data Source=aADFSDB;Failover Partner=aADFSDBDR;Initial Catalog=AdfsConfiguration;Integrated Security=True"
and the artifact store DB connection string:
"Data Source=aADFSDB;Failover Partner=aADFSDBDR;Initial Catalog=AdfsArtifactStore;Integrated Security=True"
so as you can see SQL Server 1 (aADFSDB) hosts the active Database and SQL server 2 (aADFSDBDR) hosts the failover partner/mirror.
How exactly do I get ADFS to failover to the second DB server? I tried blocking one of the Web server's access to the main database server hoping I would see an event confirming it attempting to connect to the failover partner but all I got were event's like the one at the bottom of this page.
So can anyone tell me how exactly this configuration fails over to the failover partner DB, what is required for it to do so and how I can test it? I have looked for documentation but Microsoft give precious little info on using SQL, which we needed for security reasons (token replay detection is only available in SQL config not windows internal DB config)
And I found many pages on how to setup the SQL with failover partner config but none with any details on how ADFs actually detects and performs failover and what manual steps may need to be taken in the event that it does.
A SQL operation in the AD FS configuration database with connection string Data Source=aADFSDB;Failover Partner=aADFSDBDR;Initial Catalog=AdfsConfiguration;Integrated Security=True failed.
Additional Data
Exception details:
Login failed for user 'AUSTRALIANUNITY\svcADFSacc'.
Can anyone help with this?
这篇关于ADFS 2.0 SQL DB故障转移 - 它是如何工作的？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
