SQL Connection Strings

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