up vote 1 down vote favorite
share [g+] share [fb]

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

Thanks.

link|improve this question
50% accept rate
feedback

2 Answers

up vote 5 down vote

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

link|improve this answer
feedback
up vote 4 down vote

Enterprise and Data Centre versions only sorry.

link|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 microsoft.com/sqlserver/2005/en/us/compare-features.aspx. I see you do more Oracle from your answers... inbuilt bias? :-) – gbn Sep 22 '10 at 10:52
3  
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; msdn.microsoft.com/en-us/library/ms189134.aspx – Chopper3 Sep 22 '10 at 11:25
feedback

Your Answer

 
or
required, but never shown
discard

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