Friday, February 24, 2012

Domain Change for W2K/SQL2k

I am looking for information/procedures for changing the domain for an
existing W2K/SQL2K cluster. The cluster currently is a part of an NT4.0
domain and will be migrating to a W2K AD domain. This seems like it should
be a simple change but I can't seem to find any info or anyone who has done
this. Any assistance/lessons learned would be greatly appreciated. The
process I think should work is below:
1. Move all cluster resources to a node A and stop cluster services on node
B.
2. Stop cluster services on node A
3. Join node A to the W2K AD domain
4. Change the account used for cluster services on node A to be the cluster
account in the new AD domain.
5. Change the account used for SQL services on node A to be the SQL account
in the new AD domain.
6. Start cluster services on node A and bring the cluster back online.
7. Join node B to the W2K AD domain.
8. Change the account used for cluster services on node B to be the cluster
account in the new AD domain.
9. Change the account used for SQL services on node B to be the SQL account
in the new AD domain.
10. Move the node B resources back to node B and test applications.
Jeff Teall
Dude are you in luck.
Changing Domains for a SQL Server 2000 Failover Cluster
http://www.sqljunkies.com/HowTo/14E7...BAB3F0254.scuk
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Teall" <jteall57@.yahoo.com> wrote in message
news:uu%23Lx3NaEHA.1840@.TK2MSFTNGP11.phx.gbl...
> I am looking for information/procedures for changing the domain for an
> existing W2K/SQL2K cluster. The cluster currently is a part of an NT4.0
> domain and will be migrating to a W2K AD domain. This seems like it
should
> be a simple change but I can't seem to find any info or anyone who has
done
> this. Any assistance/lessons learned would be greatly appreciated. The
> process I think should work is below:
> 1. Move all cluster resources to a node A and stop cluster services on
node
> B.
> 2. Stop cluster services on node A
> 3. Join node A to the W2K AD domain
> 4. Change the account used for cluster services on node A to be the
cluster
> account in the new AD domain.
> 5. Change the account used for SQL services on node A to be the SQL
account
> in the new AD domain.
> 6. Start cluster services on node A and bring the cluster back online.
> 7. Join node B to the W2K AD domain.
> 8. Change the account used for cluster services on node B to be the
cluster
> account in the new AD domain.
> 9. Change the account used for SQL services on node B to be the SQL
account
> in the new AD domain.
> 10. Move the node B resources back to node B and test applications.
> Jeff Teall
>

No comments:

Post a Comment