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

MS SQL Standard HA/Clustering Guides


I'm looking for simple ABC guides at setting up Microsoft SQL 2014 Standard Clustering with two nodes, Active/Active and Active/Passive. Anyone run into this - rather not at this stage have to dig through tomes of microsoft articles on random aspects of clustering but rather, A-B-C and then later I can start to break it down to understand all of the other possibilities...

1 Solution
Vitor MontalvãoMSSQL Senior EngineerCommented:
You already have a Windows cluster machines?
Ryan McCauleyData and Analytics ManagerCommented:
Here's my favorite walk-through for creating a two-node SQL Server cluster:


It uses Windows and MSSQL 2008, but the steps should still be valid with current versions.

Also, I've done an article that attempts to clarify some cluster terminology that normally causes confusion:


If there's something different you're looking for, please clarify and I can provide some additional detail.
RFVDBAuthor Commented:
Hi Ryan,

Thanks. I'll let you know if I have any other questions.
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

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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