This serves as a reminder to my future self, as I often encounter issues during Sitecore installations or occasionally forget the admin user’s password.

The easiest way to reset the admin user’s password is to execute a SQL command on the Core database within SQL Server.

Here is the command I typically use to reset the password to “b” (a legacy password that every Sitecore developer should be familiar with 😉):

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'
    ) 

Ensure that you select or use the _Core database, as attempting this on the Master or Web database will not work.

Reference link: https://www.getfishtank.com/blog/reset-the-sitecore-admin-password-to-b-from-sql-server

Hope it helps..

Thank you.. Keep Learning.. Keep Sitecoring.. 🙂