Forum Discussion

krugerm's avatar
krugerm
New Contributor
3 years ago

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 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-ver16

 

 

 

 

  • krugerm's avatar
    krugerm
    3 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
    3 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"