dbTalk Databases Forums  

Domain Change for W2K/SQL2k

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Domain Change for W2K/SQL2k in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Teall
 
Posts: n/a

Default Domain Change for W2K/SQL2k - 07-13-2004 , 08:33 AM






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



Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Domain Change for W2K/SQL2k - 07-13-2004 , 09:16 AM






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 (AT) yahoo (DOT) com> wrote

Quote:
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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.