Encrypt / Decrypt password field

[ANGELFIRE]

I have a problem regarding the encryption and decryption of password field in SQL? How can I encrypt / decrypt the password? Could someone give me a sample code for encryption and decryption?

 

[Bernadette]

Hi There

In SQL Server logins are encyrpted by default. However you can create a login without encrypting the password, but it is not recommended.

--------------------------------------------------------
Example: Creating a login for Mary with password
- rose without an encrypted password
------------------------------------------------------
EXEC sp_addlogin 'Mary', 'rose',
@encryptopt = 'skip_encryption'

--------------------------------------------------------
To read the password in Master..syslogins:
--------------------------------------------------------
SELECT password FROM syslogins where name = 'Mary'

--------------------------------------------------------
To create a password with encryption (default)
--------------------------------------------------------
EXEC sp_addlogin 'Mary', 'rose

--------------------------------------------------------
Read encrypted password for Mary
--------------------------------------------------------
SELECT CONVERT(VARBINARY(32), password)
FROM syslogins
WHERE name = 'Mary'


Hope this helps
Good Luck
Bernadette