Login failure after Restore

[Ravi]

hi,
My requirement is as follows:

1. I Dump my Database into a dump device
2. I Rebuild my mater Database
3. I Restore my User Database.
4. At the end of the above exercise I find my relationship between sysusers (User Database) and syslogins (master) is totally screwed up. This has been causing logon problems to my User Database…
5. I tried using sp_change_users_login …but it does not seem to work.

Thanking you in advance for your help rendered

[Ray Miao]

Drop and recreate users in the db.


------------
Ravi at 6/26/00 8:24:59 AM

hi,
My requirement is as follows:

1. I Dump my Database into a dump device
2. I Rebuild my mater Database
3. I Restore my User Database.
4. At the end of the above exercise I find my relationship between sysusers (User Database) and syslogins (master) is totally screwed up. This has been causing logon problems to my User Database…
5. I tried using sp_change_users_login …but it does not seem to work.

Thanking you in advance for your help rendered