4 Replies Latest reply on Nov 23, 2019 11:00 PM by Srikanth patevar

    How to Create JDBC connection for MSSQL with SSL and TSLv1.2 in CAI

    Srikanth patevar Seasoned Veteran

      Hi,

      We recently bought SSL encryption to DB. the old connection string specified in the JDBC connection is not working, could someone help with the right URL?

      Encryption Method is SSL

      Crypto Version: TSLv1.2

       

       

      old URL-

      jdbc:sqlserver://SKKDSQL03:1433;databaseName=Dummy;integratedSecurity=true

       

      New URL After Encryption:

      jdbc:sqlserver://SKKDSQL03:1433;databaseName=Dummy;integratedSecurity=true;Encrypt=true;trustServerCertificate=false;hostNameInCertificate=SKKDSQL03.Investcorp.com

       

      We don't have TrustServer and TrustServerPassword

       

       

      Please help.