Recently I needed to encrypt my MSSQL databases. I found the following guides helpful Although this guide mentions the older Server 2008, it explains things well https://technet.microsoft.com/en-us/library/cc278098(v=sql.100).aspx#_Toc189384676 A more recent article https://msdn.microsoft.com/en-AU/library/bb934049.aspx