Encrypt a Column in SQL Server 2005

5 pts.
Tags:
SQL
SQL Server
SQL Server 2005
SQL Server security
I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is it possible? I appreciate any help. I hope I made this clear enough. Thanks, Jay
ASKED: March 7, 2008  4:39 PM
UPDATED: September 9, 2013  4:14 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This answer may help you: How to Encrypt a column in SQL Server 2000/2005.

If your C# application is using stored procedures to access the data then you can change the stored procedures to use the code in the above link. If you aren’t using stored procedures then you’ll need to get the source code to modify it. There is no way in SQL 2005 to encrypt a column without changing the code.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following