Migrating SQL2000 users and the password to a new server

[fredong]

I have bought a new server and I am trying to move my database and current SQL200 users login and password to the new server. I know how to move the database but what are steps have to be done to keep the same logins and passwords in the new server to synchronize with database users. Thanks.

 

[JayKusch]

Here is a great link to guide you!

http://www.databasejournal.com/features/mssql/article.php/1479841

Thanks

J. Kusch

 

[JayKusch]

Must appologize ... That was for moving SS7. Here is the one I used for SS2K move to a Win2003 server ...

http://vyaskn.tripod.com/moving_sql_server.htm

Thanks

J. Kusch

 

[JayKusch]

Must appologize ... That was for moving SS7. Here is the one I used for SS2K move to a Win2003 server ...

http://vyaskn.tripod.com/moving_sql_server.htm

Thanks

J. Kusch

 

[fredong]

Thanks. I will read it and let you know.