Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Connect SQList securely to a SQL Azure database through an encrypted connection

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):


Using this connection string SQList will communicate securely with the SQL Azure database.