Hi.

I would like to clarify some points regarding the SQL Server security and encryption.

The requirement
The Client application wants to store some data on the SQL Sserver where the data can only be read by the Client with out using client side encryption.

The Solution
The Client will encrypt the data using SQL SERVER 2005 encryption features
Reference:
http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx

Problem
Database admin also can access the users’ certificates and then finally he can decrypt the data.

Can some one please help me to understand correct way of implementing SQL SERVER encryption features?

Thank You

Koolb