For which user did you change the IsSuperUser flag?  You don't want to change it for the same account for which you are trying to recover the password.  Instead, you want to register a new account, and then make it a super user, then log in as the new super user, go into super users in the host menu and reset the password for the lost password account there.

---

Shane Miller

While I was writing my first post, I remember something that could work and gone do it! And it worked!

Since I have access to the database, I know the ADMIN password (not HOST), all I have to do is put the PASSWORD and PASSWORDSALT of ADMIN in HOST field of ASPNET_MEMBERSHIP table.

Then, logon with ADMIN password and voilá! We're inside with HOST account!

And some filed like IsLocked and IsApproved have to be correctly. This hack works because  admin account is not IsSuperUser, but since we changed the password and passwordsalt, the login for host has the same password! It's easy to understand, but when we're stuck without host password, this is a big problem!

Thanks for all your reply's. They did help me understant this a bit.

Adelino