SQL Anywhere 17 - Validate Encrypted Database

[Former Member]

Hi,

I use full database encryption (AES256) method to create a new Encrypted database for our project. Testing team want to verify the Database is encrypted or not.

How to validate whether the database is encrypted or not?

Thanks, Jeyan

[Chris26]

If you try to start an encrypted database without an encryption key you get an error. I guess that is quite a good validation...

Could not connect to the database.

Incorrect or missing encryption key
[Sybase][ODBC Driver][SQL Anywhere]Incorrect or missing encryption key
SQLCODE=-840
SQLSTATE=08001

[VolkerBarth]

You could also try to open the database file in a (hex) editor and try to "grab some readable contents". Of course that would usually also fail even if the database is just obfuscated via "simple encryption"...