Restoring DB (users/login Problems)

Hi,

I have a few db's that I am backing up from an old sql2000 system and moving them to the new sql2005 server. The first db's restored without any problems but now I am getting some problems with users and logins.

I am restoring in the following order

1.) Creating empty db "123"
2.) Restoring database from file to database "123"
3.) Creating Login to this database (error happens when linking it to the database, "user exists")

When connecting thru QA I get "Cannot open user default database login failed"

I only have 1 login per database and I don't mind manually deleting and recreating them all but it doesnt seem to be working :S



Any suggestions much appreciated!! :)

Thanks!
mike123