QuickBooks Internals: SQL Anywhere UID & PWD

As highlighted several times in the previous parts QuickBooks company files are SQL Anywhere database files, but QB credentials are not used for SQL Anywhere directly. User name is converted to Hex string and password is calculated based on QB password and converted to hex string as well.

Login "Admin" with password "thegrideon" converted into SQL Anywhere UID / PWD:
UID=41646d696e
PWD=06e95f2c3d6c34123dad6b4059783e8fad88fd8f00
PWD format for QuickBooks 2018 and later versions (SQL Anywhere 17) is different:
PWD=079cd059af17c31b13f7d5e4c7f83075035c696ee44863dcb7ddf2b88168afe8ab00

SQL Anywhere UID & PWD Calculator is part of QuickBooks Forensics functionality.


Please note: Every connection changes database in one way or another, so it quite easy to make it QB incompatible! For example there are several scheduled events (backup, performance, search) and some triggers you might want to disable right away.