Wednesday 25 May 2016

Reset Admin password for sitecore using SQL Query

Run this SQL query in your core database

UPDATE dbo.aspnet_Membership

SET [Password]='qOvF8m8F2IcWMvfOBjJYHmfLABc=', [PasswordSalt]='OM5gu45RQuJ76itRvkSPFw==',
[IsApproved] = '1', [IsLockedOut] = '0'
WHERE UserId IN (SELECT UserId FROM dbo.aspnet_Users WHERE UserName = 'sitecore\Admin')