Encrypt password in sqlserver

Question

How can I implement encrypt password in sqlserver.
I can do in c# side but I need sqlserver implement. Please help me.......

Manas Mohapatra · Accepted Answer

declare @encrypt varbinary(200)
select @encrypt = EncryptByPassPhrase('key', 'manas' )
select @encrypt;
select convert(varchar(100),DecryptByPassPhrase('key', @encrypt ));
More on encryption and decryption please follow:
http://www.c-sharpcorner.com/uploadfile/chinnasrihari/data-encryption-and-decryption-in-sql-server-2008/

Milu Swain · Answer

Thank you guys for helps

Ananth G · Answer

refer below url it may be help you https://www.mssqltips.com/sqlservertip/4037/storing-passwords-in-a-secure-way-in-a-sql-server-database/ http://info.townsendsecurity.com/bid/64783/4-ways-to-encrypt-data-in-microsoft-sql-server

Midhun Tp · Answer

Hi,
Please check below article-
http://www.aspdotnet-suresh.com/2015/04/sql-server-encrypt-and-decrypt-string-password-in-sql-2008.html?m=1