Wednesday, March 6, 2013

Reseting admin password in Sitecore

Sitecore inside Core db stores users information. In order to reset password to 'b' for a user 'admin' one has to run a following script
UPDATE [aspnet_Membership] SET Password='8dC23rEIsvuttG3Np1L4hJmJAOA=', PasswordSalt=' joeLPwcwMq6L7kyuVfVS7g=='   
WHERE UserId IN (SELECT UserId FROM [aspnet_Users] WHERE UserName = 'sitecore\Admin') 
It is important to set both Password and PasswordSalt.

No comments: