Unable to connect to SQL 2019 server

[krugerm]

Hello,

In a test environment I am trying to install an instance of Collaborator 14 using MS SQL 2019 and it appears there are several SSL certificate related problems accessing the database. SQL server exists on the same system and TCP/IP is enabled. I have attached 3 log files. 

This Microsoft document might provide a work around: https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-with-ssl-encryption?view=sql-server-ver...

[krugerm · Accepted solution]

There are probably several ways to deal with SSL certificates, etc. While you could just disable it completely within the JDBC connection string within ROOT.XLM using: encryption=false , that's probably not ideal for a production environment. A better aproach might be to just accept the self signed SQL server certificate.

Original connection string

url="jdbc:sqlserver://localhost:1433;databaseName=smartbear"

Modified connection string

url="jdbc:sqlserver://localhost:1433;databaseName=smartbear;encrypt=true;trustServerCertificate=true"