Hi All

I am a novice/intermediate use of SQL Server 2000 so please go easy.

I am interested to know how to add passwords for users in the database in an encrypted fasion, so basically even if a person has access to the database they cannot obtain peoples passwords, is there an easy and logical way of doing this?

Any examples or advice,pls suggest me.

Thanks
monika

If you use SQL Server logins, the passwords are already encrypted.

--Jeff Moden

there are internet available tools to decript the MS password storage system. It all depends on how secure your passwords need to be. Any password system basically works this way you have a input in this case a password and some sort of cryptography mechnism. Then you store the encrypted password. To get it out you then take the encrypted password and run it through a corresponding decryption system. If you encryption system is fixed as it is with sql then your decryption system is fixed. This creates some sort of security where the novice users see a encrypted password. But any web savy or programming savy or encryption/decryption savy person can easily find this info out and decrypt your passwords. If you need greater security use and external encrypting system.