Hi All,<\/p>\n
In this blog I will discuss the steps taken to make an ADFS Server which is using SQL as its configuration database to be mirror aware. Mirroring your database can help in making your ADFS Server Farm more redundant in the event of a server outage. In order to compete the steps in this blog, you will need to have and ADFS 2.0 server which is using SQL for it’s configuration database and a mirrored copy of the database will need to be created on\u00a0a second SQL server. Creating the actual SQL mirrored copy is out of the scope of this blog. For information about creating an ADFS Server to use SQL as it’s configuration database please see Configuring ADFS Server as the First server in the ADFS Farm using SQL for the Configuration Database<\/a>.<\/p>\n 1. Create a mirror copy of the ADFS Configuration and Artifact Database on a second SQL server.<\/p>\n 2. Make sure your ADFS Service Account has the proper permissions to the mirrored database the same as it does for the master copy.<\/p>\n 3. Now you will need to configure the ADFS Server to use the failover configuration database by following these steps:<\/p>\n Please Note: You will need to complete the following steps on all ADFS servers in the farm.<\/p>\n a. Logon to your ADFS Server and open PowerShell as Administrator.<\/p>\n b. Stop the ADFS Server from the by typing “net stop adfssrv”.<\/p>\n c. Now run the following 3 PowerShell commands replacing OriginalSqlServerName<\/em> with the name of your original SQL instance and replace MirrorSQLServerName<\/em> with the name SQL instance that has the mirrored copy:<\/p>\n $temp= Get-WMIObject -namespace root\/ADFS -class SecurityTokenService<\/p>\n $temp.ConfigurationdatabaseConnectionstring=\u201dData Source=OriginalSqlServerName<\/em>; Failover Partner=MirrorSQLServerName<\/em>;Initial Catalog=AdfsConfiguration;Integrated Security=true\u201d<\/p>\n $temp.put()<\/p>\n d. Now you can start the ADFS service back up by typing “net start adfssrv”.<\/p>\n e. To verify the new setting you can run the following PowerShell command:<\/p>\n Get-WmiObject -namespace root\/adfs -class securitytokenservice<\/p>\n You will see the \u201cConfigurationdatabaseConnectionstring\u201d property\u00a0has been\u00a0updated to include the failover SQL Server instance.<\/p>\n 4. Next step will be to configure the ADFS Farm\u00a0so the\u00a0Artifact Resolution database\u00a0can use the mirrored copy for failover following the steps below:<\/p>\n Please Note: This will only need to be run on one server in the ADFS Server Farm but the ADFS service will need to be restarted on all ADFS Servers in the farm after it is run.<\/p>\n a. Logon to your ADFS Server and open PowerShell as Administrator and\u00a0run the following 2 PowerShell\u00a0commands replacing OriginalSqlServerName<\/em> with the name of your original SQL instance and replace MirrorSQLServerName<\/em> with the name SQL instance that has the mirrored copy:<\/p>\n Add-PSSnapin Microsoft.ADFS.Powershell<\/p>\n Set-adfsproperties \u2013artifactdbconnection \u201dData Source=OriginalSqlServerName<\/em>; Failover Partner=MirrorSQLServerName<\/em>;Initial Catalog=AdfsArtifactStore;Integrated Security=true\u201d<\/p>\n After running the commands above you will receive the following warning:<\/p>\n \u201cWARNING: PS0038: This action requires a restart of the AD FS 2.0 Windows Service. If you have deployed a federation server farm, restart the service on every server in the farm.\u201d<\/p>\n b. Restart the ADFS Service on every server in the farm.<\/p>\n c. To verify the new setting you can run the following PowerShell command from any server in the farm:<\/p>\n Get-ADFSProperties<\/p>\n You will notice the \u201cArtifactDBConn\u201d property has been updated with the failover SQL Server instance.<\/p>\n At this point you are done. Now you can test by shutting down the master copy of the database and testing your farm. You can also review the ADFS event viewer logs for failover events.\u00a0As always I recommend testing all of this\u00a0in a lab scenario first. If you have any questions or feedback, please feel free to\u00a0leave a comment. I hope this helps.<\/p>\n Related Links:<\/p>\n Installing Active Directory Federation Services (ADFS) 2.0<\/a><\/p>\n Configuring ADFS Server as the First server in the ADFS Farm using SQL for the Configuration Database<\/a><\/p>\n Adding an additional ADFS Server to your ADFS Farm when using SQL for the Configuration Database<\/a><\/p>\n Installing and Configuring an ADFS 2.0 Proxy Server<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Hi All, In this blog I will discuss the steps taken to make an ADFS Server which is using SQL as its configuration database to be mirror aware. Mirroring your database can help in making your ADFS Server Farm more … Continue reading