Moving/Migrating an SQl server to another domain

[BigAl68]

I was wanting to move an SQL2000 server running Windows 2003 to a new domain. Can anyone point out any problems that I might run into.

 

[SQLSister]

I'd read up on orphaned users in BOL first.

"NOTHING is more important in a database than integrity." ESquared

 

[nomadicalloy]

I don't see any problem if you are just changing the domain. make sure you have all the security settings replicated.



This is Signature

http://www.xpherion.com/

 

[ptheriault]

If you are using NT Authentication you could orphan users as SQLSister has pointed out.

Do you have a test SQL Server you could move first?

- Paul
- If at first you don't succeed, find out if the loser gets anything.