Migrate SQL Server 2000 to SQL Server 2005: login

Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>|||Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:ejLryIm1GHA.4264@.TK2MSFTNGP05.phx.gbl...
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)|||The best way to do this is to transfer the logins with sp_help_revlogin to a
clean server - i.e. one with no logins. Do this just before you want to cut
over or advise your users that their password won't be current on the new
box if they change their passwords on the old box after you've transferred
them. You won't need sp_change_users_login in that case.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:%23Xf$aNm1GHA.4908@.TK2MSFTNGP02.phx.gbl...
Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>sql