AppWorx, Dollar Universe and Sysload Community

 View Only
Expand all | Collapse all

"RE: Encryption using SSL/TLS for SQLSRVR"

  • 1.  "RE: Encryption using SSL/TLS for SQLSRVR"

    Posted Nov 22, 2023 04:29 AM

    Hi Team,

    Our client is trying to create SQLSRVR login which has Encryption using SSL/TLS  in SQLSRVR if i mention dbSID then it is giving

    22:37:27.206 CSM:read3-appworxhost: .SocketManager$1: got Response 75 569 null java.sql.SQLException: I/O Error: DB server closed connection. So i have added below in the logs 

     transactional:pstuser;encrypt=true;trustServerCertificate=true in SQLSRVR SID

    Then it is throwing java.sql.SQLException: Login failed for user 'pstuser'.  error as per user user: pstuser is defined in DB.

    From db side below is the logs. Does any one have any solution . Please suggest

    • 2023-11-15 18:25:58.22 Logon Error: 17835, Severity: 20, State: 1.
    • 2023-11-15 18:25:58.22 Logon Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. [CLIENT: Appworxhost]

    Ashok T

  • 2.  RE: " Encryption using SSL/TLS for SQLSRVR"

    Broadcom Employee
    Posted Jan 17, 2024 04:04 AM

    Try appending ;ssl=request to the SQLSRVR sid field.

    E.g.: transactional:pstuser;ssl=request