aspnet_membership Reset Password

Hi Dear , i have one Database in my site for login to it . now i forgot password for login .
i open database and see username and password but password is hash .
now my question is how can i reset it ? or replace new KNOW Hash password for it ?

or anyway for decrypt it . Password Format is 1 .

thanks
iMehranAsked:
Who is Participating?
 
Alan WarrenConnect With a Mentor Commented:
Hi iMehran,
Re:
i open database and see username and password but password is hash .

Can you access the database?
Do you have login credentials for the DB?

If so, run some SQL like this:
select U.Username, U.UserID, U.LastActivityDate, M.islockedout 
from aspnet_users U inner join 
         aspnet_membership M on U.UserId = M.UserId  
where M.LoweredEmail = 'youremailaddress' -- all lowercase


Then substitute your userid for the userid in the following sql:
Update aspnet_membership 
set password = 'eW8dWoLWPAcEIdSB+EbEUAL+V+4=', passwordsalt = 'a1H1fIERaJLD6/VpbLQUlQ==' 
Where userid = '02378D3D-B45B-4B92-B124-E14F73BFD1D7'

Open in new window

Password is: let_me_in

Alan ";0)
0
 
BardobraveCommented:
Well... usually you should create on your site an application to reset passwords, when using aspnet_membership, as this system stores passwords encrypted for security reasons.

However, if you haven't added it, you still can manage your site security, roles and users from Visual Studio / Web Developer 2010 web management. You can access it from your solution explorer clicking on the Configuration .NET button (the one with the hammer and the world, usually the rightmost on the top of solution explorer).

If you don't manage to change password this way you always can try to execute any of those two stored procedures that should be on your database:
dbo.aspnet_Membership_GetPassword
dbo.aspnet_Membership_ResetPassword

You can also change passwords on your app users through code directly by using  MembershipService.ChangePassword method.

More info on Membership in:
http://msdn.microsoft.com/en-us/library/aa478949.aspx
0
 
iMehranAuthor Commented:
thanks for your answer , i just installed visual Web Developer 2008 Express Edition  on my Server and i not found Configuration .NET button (the one with the hammer and the world, usually the rightmost on the top of solution explorer).

Can help me where is it ?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
BardobraveCommented:
I'm not sure if Web Developer 2008 have it  :-(
0
 
iMehranAuthor Commented:
Alan Thanks for your nice comment , i exactly looking like this and do it and Now can login to it  .

Thanks again .
0
 
iMehranAuthor Commented:
Very nice
0
All Courses

From novice to tech pro — start learning today.