Our Admin left and forgot to leave the password.
How can I go about resetting the CMS admin login without an admin login.
I have full admin access to the web and db server.
What version are you using?
Starting from version 8, I guess, there is emergency password reset available through web.config. Simply add this:
<add key="CMSAdminEmergencyReset" value="admin;password;true" />
More details here.
You could also set the global admin pass as blank in the DB, then reset it from within the CMS
Update CMS_User set UserPassword = '' where UserName = 'administrator'
If you're going to go SQL path, make sure admin account is enabled.
Please, sign in to be able to submit a new answer.