Restore SQL 2000 different domain?

Hello. Would anyone know of the most advisable method in moving our SQL
2000 on ServerA to another SQL 2000 machine ServerB where we plan on
retiring ServerA and ServerB will take on the same name and IP address as
ServerA? I'm mainly wondering since we have some windows authentication
logins on our SQL Server and moving it to a different domain/machine would
affect anything.
Thanks in advance.
J
Hi
"J" wrote:

> Hello. Would anyone know of the most advisable method in moving our SQL
> 2000 on ServerA to another SQL 2000 machine ServerB where we plan on
> retiring ServerA and ServerB will take on the same name and IP address as
> ServerA? I'm mainly wondering since we have some windows authentication
> logins on our SQL Server and moving it to a different domain/machine would
> affect anything.
>
See http://support.microsoft.com/kb/246133/ on how to transfer logins from
one server to another.
If you rename the server you will need to drop it and re-add it. See
http://support.microsoft.com/kb/303774/
General information about moving databases see
http://support.microsoft.com/kb/314546

> Thanks in advance.
> J
John
|||Thanks for the info. Much appreciated.
Take care.
J
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FC96D7E6-AEC9-4CC7-8602-75B61F1F571E@.microsoft.com...
> Hi
> "J" wrote:
> See http://support.microsoft.com/kb/246133/ on how to transfer logins from
> one server to another.
> If you rename the server you will need to drop it and re-add it. See
> http://support.microsoft.com/kb/303774/
> General information about moving databases see
> http://support.microsoft.com/kb/314546
>
> John

Restore SQL 2000 different domain?

Hello. Would anyone know of the most advisable method in moving our SQL
2000 on ServerA to another SQL 2000 machine ServerB where we plan on
retiring ServerA and ServerB will take on the same name and IP address as
ServerA? I'm mainly wondering since we have some windows authentication
logins on our SQL Server and moving it to a different domain/machine would
affect anything.
Thanks in advance.
JHi
"J" wrote:
> Hello. Would anyone know of the most advisable method in moving our SQL
> 2000 on ServerA to another SQL 2000 machine ServerB where we plan on
> retiring ServerA and ServerB will take on the same name and IP address as
> ServerA? I'm mainly wondering since we have some windows authentication
> logins on our SQL Server and moving it to a different domain/machine would
> affect anything.
>
See http://support.microsoft.com/kb/246133/ on how to transfer logins from
one server to another.
If you rename the server you will need to drop it and re-add it. See
http://support.microsoft.com/kb/303774/
General information about moving databases see
http://support.microsoft.com/kb/314546
> Thanks in advance.
> J
John|||Thanks for the info. Much appreciated.
Take care.
J
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FC96D7E6-AEC9-4CC7-8602-75B61F1F571E@.microsoft.com...
> Hi
> "J" wrote:
>> Hello. Would anyone know of the most advisable method in moving our SQL
>> 2000 on ServerA to another SQL 2000 machine ServerB where we plan on
>> retiring ServerA and ServerB will take on the same name and IP address as
>> ServerA? I'm mainly wondering since we have some windows authentication
>> logins on our SQL Server and moving it to a different domain/machine
>> would
>> affect anything.
> See http://support.microsoft.com/kb/246133/ on how to transfer logins from
> one server to another.
> If you rename the server you will need to drop it and re-add it. See
> http://support.microsoft.com/kb/303774/
> General information about moving databases see
> http://support.microsoft.com/kb/314546
>> Thanks in advance.
>> J
> John

Restore SQL 2000 different domain?

Hello. Would anyone know of the most advisable method in moving our SQL
2000 on ServerA to another SQL 2000 machine ServerB where we plan on
retiring ServerA and ServerB will take on the same name and IP address as
ServerA? I'm mainly wondering since we have some windows authentication
logins on our SQL Server and moving it to a different domain/machine would
affect anything.
Thanks in advance.
JHi
"J" wrote:

> Hello. Would anyone know of the most advisable method in moving our SQL
> 2000 on ServerA to another SQL 2000 machine ServerB where we plan on
> retiring ServerA and ServerB will take on the same name and IP address as
> ServerA? I'm mainly wondering since we have some windows authentication
> logins on our SQL Server and moving it to a different domain/machine would
> affect anything.
>
See http://support.microsoft.com/kb/246133/ on how to transfer logins from
one server to another.
If you rename the server you will need to drop it and re-add it. See
http://support.microsoft.com/kb/303774/
General information about moving databases see
http://support.microsoft.com/kb/314546

> Thanks in advance.
> J
John|||Thanks for the info. Much appreciated.
Take care.
J
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FC96D7E6-AEC9-4CC7-8602-75B61F1F571E@.microsoft.com...
> Hi
> "J" wrote:
>
> See http://support.microsoft.com/kb/246133/ on how to transfer logins from
> one server to another.
> If you rename the server you will need to drop it and re-add it. See
> http://support.microsoft.com/kb/303774/
> General information about moving databases see
> http://support.microsoft.com/kb/314546
>
> Johnsql