SQL Anywhere 17 - Validate Encrypted Database

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

encryption

asked 22 Feb '19, 02:18

Jeyan
26●1●1●4
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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

permanent link

answered 22 Feb '19, 02:42

Christian Ha...
647●13●16●30
accept rate: 42%

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"...

(22 Feb '19, 03:27) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

encryption ×46

question asked: 22 Feb '19, 02:18

question was seen: 1,309 times

last updated: 22 Feb '19, 03:27

SAP SQL Anywhere

SQL Anywhere 17 - Validate Encrypted Database

Follow this question

Related questions