How do I configure my MSSQL Server to use ssl-encryption?

Question

We would like to secure the connection between QIE and our MSSQL server using ssl. The QIE service has the encrypt=true connection URL parameter, but my server is not accepting it.

Answer 1

The documentation for setting up a MSSQL Server to use ssl-connections can be found on the Microsoft website at:
https://docs.microsoft.com/en-us/sql/connect/jdbc/using-ssl-encryption

For information on setting the connection properties see:
https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties
https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver