Thegrideon Software. One less reason to worry.
Home » QuickBooks Forensics » QB Internals SQL 2

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.

Default pair "Admin" with empty password converted into SQL Anywhere:
UID=41646d696e
PWD=064e7afebcfbae000b22c7c85e5560f89a2a028000
PWD format for QuickBooks 2018 & 2019 (SQL Anywhere 17) is different:
PWD=074c99f858df3c75f8add53fe5b3413e25cb3c2f98ec3545ae8dbe5bebda83d9fa00

SQL Anywhere UID & PWD Calculator is part of functionality.

SQL Anywhere UID & PWD Calculator
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.)

© 2003-2019 | Privacy | Terms of use.
All trademarks are the property of their respective holders.