I am restoring a database locally. We have implemented a custom auth module and when new users were created, we set the password in .net membership to "new Guid" since we never actually used it. So none of the actual passwords are known.
Locally I am attempting to use a straight OOTB install with the .net membership password. I have attempted updating the aspnet_membership table by updating hte user's password to "password" with format=0 but I'm unable to login after the update.
I'm running 6.1.4.28245 - is there anything else to try?
I was able to create a new user (non admin) so i'd be fine if there was a sproc I could run to add that user to the Administrators role as well...