I'm hoping someone can help me. I installed a third party user module to my 3.2.2 portal (with 4 subportals). After uninstalling the third party module, I am getting the "User Accounts is currently not available" error. After spending a couple of days searching through the various support forums I guess this has to do with the aspnet_Users (etc.) table being out of sync with the Users (etc.) tables. I don't know enough about SQL to fix this myself. Can anyone perhaps explain what to do in order to synchronise these tables again? I don't mind deleting all users to start from scratch, but I'm unsure how to do this in a clean way without causing more damage or locking myself out.

For the record, the script...

select * from aspnet_Users au left outer join Users u on au.UserName = U.UserName where U.UserName is null

...returns nothing.