Migrating a WID-based AD FS farm to an SQL Server

This recipe shows how to migrate a WID-based AD FS farm to an SQL Server.

Getting ready

Have a domain-joined SQL server available on the network that is also resolvable through DNS and reachable by the proposed AD FS server(s).

Perform all the following steps with an account that has these specific permissions:

• Domain administrator privileges in Active Directory through membership of the Domain Admins group
• Local administrator privileges on the primary AD FS server in the AD FS farm
• sa privileges on the SQL server

How to do it...

To migrate a WID-based AD FS farm to the SQL Server, perform the following steps on the primary AD FS server:

1. Create a script.
2. Create AD FS databases.
3. Detach databases from the AD FS server.
4. Copy database files.
5. Attach databases to the SQL server.
6. Reconfigure AD FS.
7. Remove the WID feature.

Then, perform Steps 2, 5, and 6 for all other...