There are many methods in Sql server 2012 which allows you to encrypt password easily. ENCRYPTBYPASSPHRASE(YOURKEYPHRASE,PASSWORD)will give you varbinary result. To Get the actual result you need to convert using convert(varchar(50),DECRYPTBYPASSPHRASE(YOURKEYPHRASE,ENCRYPTED_VALUE)).