Using the SQL server you have two options to ensure an encrypted connection. You can enforce the encryption by the server or you enforce it by each client individually.
Enforcing TLS encryption by the client works like the follwing:
- Using SQLCMD the parameter
Code: Select all
-N
- Using JDBC the parameter
Code: Select all
encrypt=true;trustServerCertificate=false;
So what is the parameter for TLS encryption when using a custom connection String in the SQL Databases configuration page of Advanced Installer:
Code: Select all
Driver=[\{]SQL Server[\}];Server=[SERVER_PROP],[PORT_PROP];Uid=[SA_USERNAME_PROP];Pwd=[SA_PASSWORD_PROP];??
Angelo