AppWorx, Dollar Universe and Sysload Community

 View Only

 "RE: Encryption using SSL/TLS for SQLSRVR"

Ashok Raju's profile image
Ashok Raju 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