Best encryption method for SQL Server 2000

Tags:
ASP
PHP
SQL Server 2000
SQL Server encryption
What is a good encryption method to use in SQL Server 2000 if your database is accessed by two different languages, PHP and ASP?

Answer Wiki

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

SQL Server 2000 doesn’t support encryption natively you have to use third party DLLs as extended stored procedures to handle the encryption and decryption of data. These extended stored procedures should be called from within your regular stored procedures so it doesn’t matter what front end language you use.
**************************
Another option is to use 3rd party vendor solution. There are a number vendors who support database encryption (data at rest) with both symmetrical and asymmetrical encryption keys. They support full database encryption or column level encryption. These systems are program or language independent. The data are kept encrypted & encryption/decryption occurs when valid users (supported by Policy Enforcement Module) access the data. Of course this solution is a bit expensive. It works on enterprise level so one can use the system for any number of databases.

It works on any database and for any language. I do not want to bias by giving the name of a particular vendor. But a search for database encryption on the Internet will reveal the names of a number of leading vendors.

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