How to modify User under the database after restore

tomchu

When the database restored, the entire users in the database has restore under the database. (but not on the server)
I can not login to the database using the same user name and password.
There is no option in Enterprise Manager I can change the user login names and password. (Under the database)
Then I try to delete it and the error said the user own an object and I can not delete.

I just need to get access using the same user name.

Please help

petey

See the following for details

http://msdn2.microsoft.com/en-us/library/ms175475.aspx

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

http://support.microsoft.com/kb/918992/