SQL failover cluster - prestaging objects in AD

• N.D

  Ten Centuries

  Points: 1132

  More actions

  September 10, 2013 at 2:51 am

  #297576

  Hi all,

  What I'm looking for is a succint summary of what needs to be created & what permissions granted in AD to facilitate a failover cluster install in a low permission environment (ie. where SQL can't create these objects itself). I have an idea of what needs to be created and granted, but want to make sure that it covers everything without granting too much 😀

  nb. I am a SQL person not an AD person - I have had a look at the MS articles on granting cluster permissions ... and am a bit lost in all the AD terminology :hehe:

  So here's what I have so far:

  Create computer object for each physical node in AD & the Cluster name (I understand this is done by the Windows clustering)

  Create MSDTC object in AD (not sure where this gets done?)

  Create Virtual SQL Name object in AD

  Grant full control of this to the following:

  Cluster computer object

  Each physical node's computer object