Wednesday, March 28, 2012

Moving a SQL Server to a new domain?

Can anyone point me in the right direction here?
What do I need to be aware of when moving a SQL 2000 server from a 2000 to a
different 2003 domain (not upgrading the existing domain)? The server has
roughly 40 SQL users and they are all configured to use SQL Authentication.
Is it as simple as removing the server from one domain and joining the other
with some possible workstation configuration changes to reflect the new FQDN?
Thanks in advance!If it was 6.5, then you would have lots of work. But 2000 is fairly
transparent. The only thing you can have to do is recreate the login because
their GUID changed on the new domain.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"FombyJambox" wrote:
> Can anyone point me in the right direction here?
> What do I need to be aware of when moving a SQL 2000 server from a 2000 to a
> different 2003 domain (not upgrading the existing domain)? The server has
> roughly 40 SQL users and they are all configured to use SQL Authentication.
> Is it as simple as removing the server from one domain and joining the other
> with some possible workstation configuration changes to reflect the new FQDN?
> Thanks in advance!

No comments:

Post a Comment