How to Encrypt Column in SQL Server?

Forum|Forum|19 years ago
September 11, 2006
2 replies
453 views

Hi all,

I am using ColdFusion MX 7 and Microsoft SQL Server 2000 database. I have a column that contains social security numbers of my users and am feeling the need to encrypt that column.

Trouble is, I have no clue how to do this in SQL Server or how I could display the data from that column in my web app once the column is encrypted.

Can anyone offer any suggestions?

Thanks in advance!

Database access

This topic has been closed for replies.

M

mikematAuthor

Participant

Thanks Tim. I'll give that a try.

N

Newsgroup_User

Inspiring

Here's one way...
To encrypt:
URLEncodedFormat(Encrypt(yourSStoencrypt, application.encKey)) then
store this value in MSSQL

To decrypt:
Decrypt(URLDecode(yourSStodecryptfromDB), application.encKey)

HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded