There many ways to do that in SQL server. It depends on what usage is required for Encryption.

As an example, if you prefer not to store clear text passwords...