Login Password Problems

[YL5956]

I'm copying from a SQL 7.0 to a SQL 2000 database and my passwords are not being moved across correctly.

I run the sp_help_revlogin script to move over the logins and then copy the database over using DTS. The problem I'm having is when I try to connect to Query Analyzer using one of the SQL logins, I get a msg 18456 level 16 state 1 error.

What am I doing wrong? Isn't the sp_help_revlogin script suppose to sync up the passwords? Can anyone help? Thanks.

 

[Corran007]

are you sure that it is really running? When you look in security, do you see the users there, do you see the users set up correctly in the databases?

This article has more info on it if you did not already know it

http://support.microsoft.com/default.aspx?kbid=246133