Hello,

A system that houses an app and it's database was restored.

The database called testdb has a user called testdbuser.  When I check
the users for this db - it shows testdbuser - the properties show the
Login Name as <none> after the restore.

In the Security Folder - testdbuser does not exist.  I tried to
recreate it and give the the correct password and database access.
However, when I do that - it says the 'users already' exists.

It will not let me drop testdbuser from the db because it is the owner
of tables.

However when the app tries to access it - it says:
Cannot open database requested in login 'testdb'. Login fails.

When I try to login with query analyzer, I get
Login failed for testdbuser

Previous to this restore - it used to work.

How can I rename the login to 'testdbuser' as it was previously?

Any other suggestions?

Thanks,

Tmuld