Guys, I have checked everywhere how do I reset my managers password manually as I don’t seem to manage to get inside it. Thanks!
Not getting the email when resetting through the dashboard?
These general instructions for a database reset should work with some minor changes for MSSQL. Basically set the hash_class value to hashing.modMD5, and add a MD5 hash (which for a random password you can also create online, or on the command line) to the password field.
If you still can’t get in, check core/cache/logs/error.log for any issues. Perhaps a table crashes or it can’t connect to the database preventing the login instead.
Finally, please note MSSQL support is deprecated and has been removed from 3.0. So long-term you’ll want to migrate to MySQL.