Return to Answer

updated code. included updated salt

Source Link

edited Feb 21, 2017 at 13:13

2.7k
11
27

In addition to the answer above, if you have the misery of forgetting the Sitecore password then this will save you:

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

It resets the password to the classic 'b'.

In addition to the answer above, if you have the misery of forgetting the Sitecore password then this will save you:

UPDATE [aspnet_Membership] SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc='
WHERE UserId IN (SELECT UserId FROM [aspnet_Users] WHERE UserName = 'sitecore\Admin')

It resets the password to the classic 'b'.

In addition to the answer above, if you have the misery of forgetting the Sitecore password then this will save you:

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

It resets the password to the classic 'b'.

Source Link

created Oct 4, 2016 at 11:48

Steven Newstead

2.7k
14
23

In addition to the answer above, if you have the misery of forgetting the Sitecore password then this will save you:

UPDATE [aspnet_Membership] SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc='
WHERE UserId IN (SELECT UserId FROM [aspnet_Users] WHERE UserName = 'sitecore\Admin')

It resets the password to the classic 'b'.