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


Can you use the free version of SQL as part of installing ADFS?

We want to set this up as high-availability and I understand that you need to create a mirrored database. Can you use the free version to accomplish this?
  • 2
2 Solutions
James HodgeManaging DirectorCommented:

If you are dealing with an environment with less than 50,000 objects then SQL Express is fit for purpose.

Vasil Michev (MVP)Commented:
No, the Express Edition can only be used as a witness.

HypervizorAuthor Commented:
So you would have to have one SQL Standard license and you can use SQL Express for the other or does it mean you have to have 2 x SQL Standard licenses?
Vasil Michev (MVP)Commented:
Again, you cannot use EE for mirroring, both the principal and the mirror servers need to be at least Standard. You can use it as a witness though, so you will need 2x Standard and 1 EE.


You should also ask this in the SQL section, I'm sure the experts there have a lot more experience with SQL HA.
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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