• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

Changing current ADFS 2.0 (for Office 365) from SQL DB to WID

Hi all. I have a current ADFS 2.0 that is using SQL locally installed for Office 365 as well as federated venders. It is in farm mode, but only one node currently. I want to add another server to the farm. Since SQL is used locally on the first server, changed from WID, if that server fails, the DB will not be available. I realize under the current scenario, I would have to move the SQL DB to another server, preferably a SQL cluster, and then add the second server pointing to this DB. There really is no need for SQL though here and the high cost of license for a Cluster because the AD object count is not that high. If I deploy the farm using WID DBs, they will have fault tolerance built in to the primary/secondary components of this.

My Question is, is there anyway to change my current farm to go back to WID from SQL? I cant find anything on the Internet that states this. I see dozens of articles on how to go from WID to SQL...

If I cannot do this, can I add another new farm using WID and reconnect to Office 365 without much downtime?
1 Solution
Vasil Michev (MVP)Commented:
Could not find anything either. You cannot have more than 1 AD FS in your org, so you will need to remove the existing one first. Which is not as simple as uninstalling the AD FS, it will leave the database and the rest of the config. If you feel adventurous enough to do so, read these:



Jorge's blog is very useful btw, you might also contact him directly to get an answer to this (make sure to post back here too)
RobguadAuthor Commented:
I actually was able to install a second ADFS 2.0 infrastructure in the same forest. I used a different name space. Once I was ready for the cut over, I just ran the commands to connect this new namespace to Office365. It worked just fine.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now