After trying to update the username, password and email via direct sql statements, i still had no success. So here is what i did:
Open the solution for your store with Visual Studio
Register as a new customer, make sure you enter all the fields specially your email address and password (write those down). Close Visual Studio.
Open your SQL server, look for the CustomerID of the customer you just created. Let's suppose his CustomerID is 38.
Run the following SQL statement:
update dbo.Nop_Customer
set IsAdmin = 1
where CustomerID = 38
Open the solution for your store with Visual Studio
Log in with the email address and password of the customer you just created. Since you made him admin, you should have access to the "Administration" area at the top menu bar.
Let me know if that helped, it worked for me. As they say, "There is more than one way to skin a cat".
Robert Lobaina
www.integratedbrands.biz
[email protected]