I need to configure ADFS as a high-availability solution.

Am I correct in thinking that you need at least SQL Server Standard Edition (we're looking at SQL 2012) installed on both servers so that database mirroring can be configured, i.e. I can't use SQL Express at all on either side)?

I also understand that I need to configure NLB to support the failover. Would this be completed automated?

How long roughly would this take to setup a couple of SQL servers in this configuration and is there any step-through guides available?
Who is Participating?
Barry CunneyConnect With a Mentor Commented:
Hi Hypervizor,
Yes you need at least SQL Server 2012 Standard Edition for Database Mirroring

Other versions such as Express can be used as just a Witness server in a Database Mirroring set up.
HypervizorAuthor Commented:

What's the purpose of a witness server?
Barry CunneyCommented:
When SQL Server Database Mirroring is implemented in 'high safety' mode the role of the Witness server is to enable the Mirror server to recognize if automatic failover should be initiated

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

HypervizorAuthor Commented:
So does that mean for HA that each SQL server needs to be a witness server so that it recognises if its partner becomes unavailable or are you saying it has to be another server which is looking at both?
Barry CunneyCommented:
Hi HyperVizor,
In Database Mirroring in 'high safety' mode, yes, the Witness server is a separate SQL Server instance, separate from the Principal and the Mirror servers
HypervizorAuthor Commented:
OK, all we have is a small implementation of SQL which ADFS uses. If we then have to create two witness servers, that's just not going to be cost-effective.
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.

All Courses

From novice to tech pro — start learning today.