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.

Using SqlServer 2008 in cluster do I need to have the two servers installed with Windows in Cluster mode?

share|improve this question

3 Answers 3

up vote 0 down vote accepted

You should be able to set up a single node cluster as long as you've got storage that can be shared. Note, when adding a node to a windows 2008 fail over cluster it will take the clustered resources down, resulting in an outage.

technet article on windows 2009 failover cluster

share|improve this answer

Yes, you do. See this article.

If you are installing on win2k8, you may want to do some checking about possible issues and workarounds. There are some questions on SF that deal with that.

share|improve this answer
    
For what I read I need the Windows cluster Service, not to have the two windows servers installed in cluster. Is this correct? –  Jedi Master Spooky May 4 '10 at 14:43
    
The Windows Cluster Service is used to configure a cluster. Read msdn.microsoft.com/en-us/library/ms189910.aspx for more info. –  Holocryptic May 4 '10 at 15:31

Just one note: if you are going to install it on a Windows Server 2008 R2 cluster, you have to slipstream Service Pack 1 into SQL Server 2008 before installing. If you are not familiar with slipstreaming, have a look at the following article:

http://blogs.msdn.com/petersad/archive/2009/06/17/creating-a-merged-slipstreamed-drop-containing-sql-server-2008-rtm-service-pack-1.aspx

share|improve this answer

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.