restore database bug

Hi,
I'm having some problem with restoring a database from another server.
The problem is that sql server 2000 is telling me at the end of the
restore process, the user is invalid in the database. It is the same
user which stated the restore statement, but on a testserver. the
database is still restored
The sql-account i'm using is a member of dbcreators.
Should the restore be successful and have an valid owner or is this a bug?
Perhaps you want to read up on sp_change_users_login within Books Online
http://msdn.microsoft.com/library/de...ca-cz_8qzy.asp
Here are some other articles that you may find helpful:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Keith Kratochvil
"Jason" <jasonlewis@.hotmail.com> wrote in message
news:%236FkksI6GHA.1012@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I'm having some problem with restoring a database from another server.
> The problem is that sql server 2000 is telling me at the end of the
> restore process, the user is invalid in the database. It is the same user
> which stated the restore statement, but on a testserver. the database is
> still restored
> The sql-account i'm using is a member of dbcreators.
> Should the restore be successful and have an valid owner or is this a bug?