Reset The Sitecore Admin Password To "b" From SQL Server

Forgot Your Sitecore Admin Password? Reset It From SQL Server

Sometimes, we may forget the Sitecore admin password that was entered during installation or after changing it. After being locked out, your only option is to reinstall the new instance.

Sitecore Password Reset

But you can avoid that by running the simple SQL query in the core database of the Sitecore instance. Doing this will reset the Sitecore admin password to "b".

Steps To Reset Your Sitecore Admin Account Password To "b"

Step 1

Log into the SQL server instance using SQL Server Management Studio(SSMS) and select the Sitecore instance’s core database to run the query.

Sitecore Password Reset

Step 2

Copy and run the SQL query below.

    [IsApproved] = '1', 
    [IsLockedOut] = '0'
    UserId IN (
        SELECT UserId FROM dbo.aspnet_Users WHERE UserName = 'sitecore\Admin'

The above query also unlocks your account if it was locked due to wrong password attempts. Now you can log into Sitecore using the credentials username - admin and password - b.

This query works on all versions of Sitecore, including 8, 9, 10.1, 10.2, and 10.3.

👋 Hey Sitecore Enthusiasts!

Sign up to our bi-weekly newsletter for a bite-sized curation of valuable insight from the Sitecore community.

What’s in it for you?

  • Stay up-to-date with the latest Sitecore news
  • New to Sitecore? Learn tips and tricks to help you navigate this powerful tool
  • Sitecore pro? Expand your skill set and discover troubleshooting tips
  • Browse open careers and opportunities
  • Get a chance to be featured in upcoming editions
  • Learn our secret handshake
  • And more!
Sitecore Snack a newsletter by Fishtank Consulting