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
- see more..
Categories
ALLAsp.Net (3)
Sitecore (11)
Issues Resolved (9)
Sitecore 9.3 (2)
International Business (1)
Innovations in Industries (3)
Supply Chain Management (1)
Industrial Engineering (14)
Sitecore 10 (4)
Sharepoint (1)
Azure (4)
Cloud Computing (1)
Online Courses (1)
Online Resources (2)
C# (1)
Blazor WebAssembly (2)
Sitecore form (1)
MS Sql Server (1)
Angular 11 (2)
Automobile Engineering (5)
Sitecore powershell (1)
Devops (2)
Microservice Architecture (1)
Sitecore Interview Questions (2)
Dotnet interview questions (1)
Sitecore useful links (1)
Privacy&Cookies (2)
Solr Search (2)
JavaScript (1)
sitecore xm cloud (3)