Home / server / Questions / 138376
Accepted
Jedi Master Spooky
Asked: 2010-05-05 05:44:56 +0800 CST

Using SqlServer 2008 in cluster do I need to have Windows in Cluster?

  • 772

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

sql-server load-balancing

3 Answers

  1. 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.

    • 0
  2. Best Answer

    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

    • 0

  3. 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

    • 0