Reset Sitecore Admin Password using SQL

In case you forget the Sitecore Admin password and you are not able to login into the Sitecore. Now the question is If you are not able to login into the Sitecore system then How can you rest the password? There is one solution to reset the Sitecore Admin password to “b” by SQL Server database. 

Perform the below steps to reset the Sitecore Admin password to “b”:

  1. Login into SQL Server Database
  2. Go to the respective Core Database, open a new query window.
  3. Execute the below query.
  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'
      ) 
Reset-Sitecore-Admin-Password

The above script will reset Admin User Password to “b”.

Happy Sitecoreing ðŸ˜Š

Comments

Popular posts from this blog

Sitecore Installation Error: Failed to Start Service 'Sitecore Marketing Automation Engine'

Import CSV Data in Sitecore Using PowerShell: Part-3

Sitecore : The database principal owns a schema in the database, and cannot be dropped message