Encrypting Database

JBhav

Hello everybody,

Can anyone suggest how to encrypt a whole navision database (Version 2009 r2)

Thanks in advance

Luc_VanDyck

There is an encryption option in WinZip which you can use to encrypt your database. But somehow, I don't think that's what you meant :-k

JBhav

Luc Van Dyck wrote:

There is an encryption option in WinZip which you can use to encrypt your database. But somehow, I don't think that's what you meant :-k

Thanks but what i meant was that the database contains some confidential data. As per requirements, those data has to be encrypted.
Is there any possibilities to encrypt the database in navision itself? The database is on sql server 2008.

Sam_Morris

The only way I know is to use an automation. There are a few out there.

ChilKat Crypt is one I have used before. You have to use the automation to encrypt the data before you write it to the database, and then unencrypt it before you use it. I'm not sure how well this would work with a whole database though! We only used it with specific bits of data.

Sog

JBhav wrote:

Thanks but what i meant was that the database contains some confidential data. As per requirements, those data has to be encrypted.

So it's not the whole database.
As Sam said, you could use chilkat crypt automation, or any algorythm to encrypt your data. AES is the safest.

stryk

If you are running SQL Server 2008 you could use the "Database Encryption" feature:
http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx

But REALLY handle that with care - if you are doing anything wrong or if you are loosing your certificates etc. then your database IS LOST!
Read the Documentation, understand the Concept, don't do anything Wrong - mistakes are not forgiven.

sunmorningindia

Hi,

Check Codeunit 824 Encryption Mgt.
This might help you.