SQL Server Performance Forum – Threads Archive

How to encrypt a column?

According to my understanding, MS SQL Server does not have any built-in mechanism to encrypt a column. One way to encrypt column seems to use Microsoft CryptoAPI. Does anyone have any example how to do this? Thank you for any help.

http://www.netlib.com/sql-column-encryption-api.htm for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Why does this need to be done at the server? More or less easy exercise for any front-end language.
–Frank
http://www.insidesql.de

All that you need to do is encrypt the data before you enter it into your database. If you’re using a .NET language, encryption is very easy.

Try this for server-side encryption:http://www.activecrypt.com/

]]>