Forum Discussion

krugerm's avatar
krugerm
New Contributor
2 years ago
Solved

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 ...
  • krugerm's avatar
    krugerm
    2 years ago

    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"

krugerm's avatar
krugerm
New Contributor
2 years ago

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"