Reset sitecore 9.1 password as b using sql query or command

Prem Murmu on 10/17/2020 7:50:17 AM

I was setting up existing sitecore 9.1 project,later i found I am unable to login in to Sitecore.

It was in my case,but i happens either you forget password and may be another reason and your sitecore passwod in changed.

In that case, first of all you have to reset the sitecore login to default as:

UserName: admin

Password: b

 I find many pages in google to reset sitecore password,but sql query i used worked in sitecore 9.1 and infact it also work in all sitecore 9 versions.




Find the sql command or query below to reset your sitecore login credential to default:

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'

)



find the other references below if it doesnt work.


Reference:

https://sitecorepassion.wordpress.com/2018/06/28/sitecore-9-admin-password-reset-as-b/

http://www.navavayas.com/blog/reset-sitecore-admin-password/

0 Comments on this post

Comments(0)||Login to Comments


InterServer Web Hosting and VPS
  • see more..