By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

encrypt password

P: n/a
Hi All,
Does anyone know how to encrypt the password before store in the sql database?
In addition, decrypt the password from database before comparison.

The purpose to do it because to hide the human readable password although
the user open the sqlserver database.

Any ideas? Any better suggestion? any guidelines?
Thank you in advance.

Best regards,
Ocurnos
Nov 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ocurnos,

The common approach is to hash passwords one way. You can't decrypt it.
Rather you hash the user entry with the same algorythm and compare the
hashed values. Look in

How To: Use Forms Authentication with SQL Server 2000
http://msdn.microsoft.com/library/de...SecNetHT03.asp

Eliyahu

"Daniel" <Da****@discussions.microsoft.com> wrote in message
news:04**********************************@microsof t.com...
Hi All,
Does anyone know how to encrypt the password before store in the sql database? In addition, decrypt the password from database before comparison.

The purpose to do it because to hide the human readable password although
the user open the sqlserver database.

Any ideas? Any better suggestion? any guidelines?
Thank you in advance.

Best regards,
Ocurnos

Nov 19 '05 #2

P: n/a
you can use System.Security.Cryptography classes to encript the password and
then store it in the database.
for more info: http://www.codeproject.com/aspnet/encrypt.asp

Cheers,

Dhanushka Nuwan
sh******@yahoo.com
"Daniel" <Da****@discussions.microsoft.com> wrote in message
news:04**********************************@microsof t.com...
Hi All,
Does anyone know how to encrypt the password before store in the sql database? In addition, decrypt the password from database before comparison.

The purpose to do it because to hide the human readable password although
the user open the sqlserver database.

Any ideas? Any better suggestion? any guidelines?
Thank you in advance.

Best regards,
Ocurnos

Nov 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.