ADFS & SQL

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?
HypervizorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James HodgeManaging DirectorCommented:
Hello,

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

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

http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
0
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?
0
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.

http://technet.microsoft.com/en-us/library/ms366349.aspx

You should also ask this in the SQL section, I'm sure the experts there have a lot more experience with SQL HA.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office 365

From novice to tech pro — start learning today.