Re: Changing Windows Domain

I just did this last night for a customer. If you are already using the new
domain's service account, it's pretty easy. I take it your cluster & SQL
service accounts are already in the local administrators group on each node.
Take all cluster groups offline. Join one node at a time to the new domain,
reboot, when both are back up in and in the new domain start the groups.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC Clustering
class

"CarolinaKB" <CarolinaKB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CB00A57B-A0E5-450D-9C83-9818B7883595@xxxxxxxxxxxxxxxx
>I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000
> Enterprise Edition. The cluster supports a 24x365, mission critical
> application.
>
> The nodes are currently members of a Windows NT4 domain which trusts a
> Windows 2003 Active Directory Domain. All user and service accounts
> (including SQLServer and SQLServer Agent accounts) are "ADDomain"
> accounts.
>
> I am planning on using the procedure described in KBs 269196 and 319016 to
> move the cluster from "NT4Domain" to the trusted "ADDomain". The TCP/IP
> names and addresses will not change, and to reiterate, the user and
> service
> accounts are already logging into the trusted domain "ADDomain", not
> "NT4Domain".
>
> When I look at 319016, however, I get the impression that that KB was
> written more to address a changed TCP/IP domain as opposed to a changed
> Windows domain. My questions are:
>
> 1) Does 319016 even apply in this situation?
>
> For example, step 1 of 319016 calls for a rerun of SQLServer setup. Since
> 1) the TCP/IP address is not changing and 2) the SQL service account is
> not
> changing, do I need to perform step 1? I'm not sure what all setup might
> be
> doing there.
>
> Also, step 2 of 319016 calls for the new TCP/IP address to be entered for
> each instance. Again, the IP address is not changing. As info, there is
> only the default instance.
>
> 2) I think that I need to move both nodes into the new domain and restart
> the cluster service on both (with SQLServer resources kept offline) before
> any SQL changes. Is that correct?
>
> 3) Assuming there are no GP changes, are there other concerns I'm
> overlooking? I saw a similar question in which the admin was leaning
> toward
> rebuilding from scratch instead of moving the cluster. That seems like a
> lot
> more work (rebuilding systems, cluster resources, and
> reinstalling/configuring applications) than moving as described above.
>
> Thanks for any feedback
>


.

Relevant Pages

  • Re: Cluster service do not start after restart.
    ... Are your machines affected by group policy by ... Did you change the service account by chance? ... > Hi I have a compaq CL 380 cluster server with windows 2000 ad srvr ... > These user rights were granted to the Cluster service account during ...
    (microsoft.public.windows.server.clustering)
  • Re: Installation fails when creating virtual resource on node
    ... The cluster logs indicate that you initially tried to create a Named ... account for the SQL Server services. ... what account do you want me to run the SQL Server services under. ... How to change the SQL Server or SQL Server Agent Service account without ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding a node to a one-node functional cluster
    ... On a cluster, the SQL service account, the cluster service account, and the ... install account must be domain users in the local administrators group on ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • RE: System State backup fails
    ... I figured if I made the domain Cluster Service Account a member of the local ... Administrators Group on each node in the cluster it might make a difference. ... > The system state backup will run on either node as long as it is holding the ...
    (microsoft.public.windows.server.clustering)
  • Re: MSDTC - Cluster Resource = Not
    ... 243204 Microsoft Distributed Transaction Coordinator (MSDTC) Recovery ... Windows NT/2000/2003 Cluster Technologies ... >> Once you've completed the uninstall and install of MSDTC on Windows ...
    (microsoft.public.windows.server.clustering)
Loading