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 · 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/

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

Milu Swain · Answer

Thank you guys for helps

Midhun T P · 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