To connect to a SQL database, SQList uses standard connection string built using the database and credentials details entered in the SQL connection in SQList Manager.
Although the form does not have specific options to configure encryption, it is still possible to generate a connection string that uses encryption by appending the encryption instructions to the server name.
For example, let's assume we want to connect to the following SQL Azure database:
Server: axiosql01.database.windows.net
Database: Demo
SQL user: user1
Password: password1
To connect securely to it, the connection in SQList Manager must be entered as follow:
Server Name\Instance: tcp:axiosql01.database.windows.net,1433;Encrypt=True;TrustServerCertificate=True
Database Name: Demo
Database engine: SQL Azure
Authentication mode: SQL Authentication
Username: user1
Password: password1
Those settings will generate the following connection string (note the encryption instructions):
server=tcp:axiosql01.database.windows.net,1433;Encrypt=True;TrustServerCertificate=True;database=Demo;user=user1;pwd=password1
Using this connection string SQList will communicate securely with the SQL Azure database.