Database Encryption

[devoas]

hello,

We are trying to use Database Encryption Tool:  DBDefence for SQL Server 2008 (http://www.dbdefence.com/), once any Database is Encrypted it requires to have following kind of SQL statement to be executed.

OPEN SYMMETRIC KEY DBDX DECRYPTION BY PASSWORD = ‘...’ 

this will enable Database access for particular Connection, 

Kindly advise how we can use this with Open Access, I tried to run this after NewObjectScope by scope.GetSqlQuery(script)

 and also by  ExecuteDDLScript  but it did't worked.. Access is not granted, seem that I need call this anywhere else. Please advise.

Thanks 

devoas

[Damyan Bogoev]

Hello devoas,

You can try to setting this statement to the "Connection init SQL" option in the Backend configuration settings dialog. The dialog can be found under the Telerik -> OpenAccess -> Configuration menu.
Hope that helps.

Regards,
Damyan Bogoev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[devoas]

Dear Damyan,

Thanks for you reply. Unfortunately this did not worked.  I put the decryption code in initSql thru Backend configuration setting dialog but I cannot even use the database in reverse mapping.  Infact  I cannot see/verify that the commands written in initSql is working or not as If I write some incorrect code in it, still it is not giving any error .....   How can I see if the statements written with initSql are running or not.

Thanks 

devoas

Thanks 

devoas,

[devoas]

Dear Damyan,

Thanks for you reply. Unfortunately this did not worked.  I put the decryption code in initSql thru Backend configuration setting dialog but I cannot even use the database in reverse mapping.  Infact  I cannot see/verify that the commands written in initSql is working or not as If I write some incorrect code in it, still it is not giving any error .....   How can I see if the statements written with initSql are running or not.

Thanks

devoas

[Damyan Bogoev]

Hi devoas,

You could the logging mechanism of the Telerik OpenAccess ORM in order to see whether the statements written inside the initSql are running. You could set the logging from the Telerik | OpenAccess | Configuration | Backend Configuration Settings dialog under the Logging node.
Please set the Event Tracing option to True as well as the Log level to all. You should specify how the events should be logged in a text file or displayed in a console window.
Hope that helps.

All the best,
Damyan Bogoev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.