I have been tasked with migrating our NT 4.0 domain to a Windows 2003 domain structure. I have a Windows 2000/SQL 2000 Cluster running critical applications in my current NT 4.0 domain.

I've created a separate trusted 2003 domain, and I intend to move all of my accounts over to it using the Active Directory Migration Tool. I am concerned about users that have been migrated to the new 2003 domain losing their ability to access the SQL Application Cluster, while it is still in the NT 4.0 domain. I would greatly apreciate any advice that anyone could share with me, regarding the safest way accomplish the migration of this cluster without risking user access

Will there be any risk to Windows based SQL authentication, if I move the user accounts and groups prior to changing the domain membership of the SQL Cluster? Any cross domain issues that anyone knows about? Cluster issues

Thanks in advance for your help

When you change domains your SIDs change and SQL uses the SIDs during
authentication. So you have to resync with the new domain's SIDs.

314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.