Here are a few examples
Connection with username / password
Server=127.0.0.1;Database=DBName;User Id=username;Password=password;
Connection with windows credentials
Server=127.0.0.1;Database=Some DB;Integrated Security=true;
Connection with column encryption
Server=127.0.0.1;Database=Some DB;Integrated Security=true;Column Encryption Setting=enabled;
Here is an article that explains how to use column encryption
Part 1 Part 2
Tags
SQL Server