Storing encrypted files on an SQL Server 2000

Tags:
Encryption
Microsoft SQL Server 2000
SQL Server
We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?

Answer Wiki

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

Doing this isn’t natively supported in 2000. Here is an article about it. I have done it by using System.Security. Cryptography in .net and either binary, varbinary, or image data type in the database. You can also convert the bytes to a base64 encoded string in .net and save it in the database in a varchar field. Regardless doing this in .net requires you to encrypt and un-encrypt the data via code each time. (You could write a wrapper around the db object to do this automatically.)

——–

You might want to use something a little more current than SQL 2000. That was released 10 years ago and there have been 2 versions released since then with another version being released in the next few months.

Discuss This Question: 1  Reply

 
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
  • SQL Server Ask the Experts
    [...] Gent01 and MrDenny team up again to answer a SQL question on storing encrypted files on SQL Server 2000. .topsy_widget_shortcode,div.topsy-sm {display:inline;} .post {padding-left: 10px;}   [...]
    0 pointsBadges:
    report

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