Hi Team,
Our client is trying to create SQLSRVR login which has Encryption using SSL/TLS but check is giving following error, in SQLSRVR i have given dbSID then it gave
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 for the same. 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]