UPDATE Users SET PasswordHash = 'newpasswordhash', Password = 'newpasswordplaintext' WHERE UserName = 'YourAdminUsername'; GO
A command window will appear. Wait for it to finish the process. Note that if the account is currently locked due to too many failed attempts, you may need to wait up to 15–60 minutes for the lockout to expire before you can log in again.
UPDATE Users SET PasswordHash = 'newpasswordhash', Password = 'newpasswordplaintext' WHERE UserName = 'YourAdminUsername'; GO
A command window will appear. Wait for it to finish the process. Note that if the account is currently locked due to too many failed attempts, you may need to wait up to 15–60 minutes for the lockout to expire before you can log in again. UPDATE Users SET PasswordHash = 'newpasswordhash'