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

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

You may need third party encryt tool.

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

Regards,
Teixeira

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