Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to install sql server 2008 r2 edition in a cluster environment. Can I use Windows Server 2008 R2 Standard edition?


share|improve this question

It looks like you need to go to Server 2008 Enterprise or Data Centre for clustering, or Itanium for that usage case. My assumption would be once you have the OS sorted, you need to ensure that you're running a version of SQL that supports clustering

So, to answer your question - Windows Server 2008 R2 Standard cannot be used for a SQL cluster

share|improve this answer

Enterprise and Data Centre versions only sorry.

share|improve this answer
Factually incorrect. Correct answer even has link to MS documentation sating the answer. – TomTom Sep 22 '10 at 10:49
In ye olden days (SQL Server 2000), this would have been true. It changed 5 years ago with Workgroup edition SQL Server 2005 becoming the old "standard". See I see you do more Oracle from your answers... inbuilt bias? :-) – gbn Sep 22 '10 at 10:52
I'm sorry but you're both incorrect and I am in fact correct - the combination being asked about (SQL 2008 on Server 2008 Standard) will NOT support clustering (even 2-node) as Server 2008 Standard does not support Failover Clustering at all. The document that gbn links to regards what level of clustering SQL 2008 supports, it still requires a supporting OS under it and this combination won't work. Have a look at the bottom of this link; – Chopper3 Sep 22 '10 at 11:25

That is correct. Windows 2008R2 Standard Edition does not support Failover cluster. The failover cluster doesn't even show up in the list of features. I just checked it. Only Ent and Datacenter supports it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.