Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

Thanks.

share|improve this question
add comment

2 Answers

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
add comment

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 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
add comment

Your Answer

 
discard

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.