Unable to connect to SQL 2019 server
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 ...
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"
