It seems there is a mismatch between the SQL
authentication Schema at the server from where the
database was backed up and the new server.

Check the Authentication Schema and login/user details at
the destination server that had the complete access to the
database.

HTH


>-----Original Message-----
>I have posted this message a week ago, however, still
>haven't solve this issue.
>
>I tried to restore a SQL2000 db on a Win2000 box which
the
>tape was backuped from a WinNT 4. I only use Enterprise
>Manager to backup & restore and the tape is a brand new
>tape. So I am sure there are no password was enforced on
>the backup. However when I restore it, I got access
>denied, password failed error. How can it be happen? How
>can I solve it? It hold back all the upgrade from WinNT
>to Win2000... please help.
>
>Thanks,
>Ian
>.
>

Report this post to a moderator