Encryt/decrypt password using SQL Server 2000 and my C# code

[teixeira]

Hi,

How can i encript passwords in my database and use the same algorithm in my C# code to decrypt it?

I don't want to send between my app and DB server the logins in clear text, i would like to send it encrypted from my C# code and with the same algorithm decrypt it in the sql server.

Thanks in Advance,
Teixeira

[rmiao]

You may need third party encryt tool.

[teixeira]

Do you know any open source or free tool for that?

Regards,
Teixeira

[jezemine]

you should never decrypt passwords. You should encrypt them, and then when you need to compare two passwords, encrypt them both and compare the result.

Here's a way to do the encryption in sql:

http://sqlblindman.googlepages.com/encryptpassword