Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Encryption in Sql 2000

Locked

I want to encrypt my site user passwords which r stored in a table Login so that when anyone wants to see the passwords he will see only encrypted not the actual one.But the admin can see the actual passwords by some means.I am using Sql server 2000and ASP as the programming language and my site is situated at VSNL india.So pls give me some solution for encryption and decryption also??

regards
pankaj

Topic

Encryption in Sql 2000

In reply to Encryption in Sql 2000

pankaj,

See my article on the topic of encryption with VB at this URL:

http://www.techrepublic.com/article.jhtml?id=r00820010521sem01.htm

No matter what you do, if it is encrypted in the table, it will appear encrypted. You’ll need to write a small VB app with the decryption routine for the admin to view the passwords.

The download of the encryption DLL is available on my website, http://www.pointweb.net.

HTH

S

Encryption in Sql 2000

In reply to Encryption in Sql 2000

The question was auto-closed by TechRepublic

Encryption in Sql 2000

In reply to Encryption in Sql 2000

Point is, what you put in the database is what you also see.

The essence of encryption in applications is that you should first encrypt data before you insert these in the database, and when getting the data from the database, you should decrypt it so as to view “human readable” data.

I suggest that you create encryption and decryption functions in your ASP code. This should help secure your database data aside from the security that the SQL database itself implements.

You may createyour own encryption algorithm or better yet, implement n-DES, there are lots of resources about this on the Net.

good luck.

Encryption in Sql 2000

In reply to Encryption in Sql 2000

The question was auto-closed by TechRepublic

Encryption in Sql 2000

In reply to Encryption in Sql 2000

This question was auto closed due to inactivity

[Author]

Replies