Reset or recover admin password ver 3.6

Hello,
I'm using ver 3.6 and I need to reset or recover my admin password. Can someone give me the steps needed? I do have access to the database through MS SQL Server Manager.
Thanks

Jim

jimkoh wrote:
Create new user.
Now go to MS SQL Server Manager
Get the Id of that customerTable.
Now to go to Customer_CustomerRole_Mapping.
Set a new entry where Customer_Id= that Id and CustomerRole_Id=1;
Now new user become admin.
From new user you can reset password of that admin.

Thanks, that worked.